Why this blog?

Finding information from Oracle/Hyperion can be difficult as you search the thousands of pages of documentation. So I'm creating this blog with all of my tables and matrices for the Oracle Hyperion products. Questions like - How does Smart View compare to the Excel add-in? When should I use Financial Reporting or Web Analysis? I thought I would share this information with you in the simple format of tables and maybe a few bullet points. So no lengthy paragraphs on this blog... but hopefully some helpful Oracle Hyperion information.

Sunday, October 12, 2008

Smart View Query Designer vs. Regular Adhoc Query

In the latest versions of Smart View, a query designer is provided to create queries in Excel against Essbase. I've gotten a few questions from clients related to this new tool ... Why would I use the Query Designer vs. just using the adhoc analysis / member selection capabilities? See the matrix below to view a comparison:

Regular Query vs. Query Designer

Regular Adhoc Query

Query Designer

POV, Rows, Columns

Y

Y

Member Filters

Y

Y

Data Filters

N

Y

You know the Query Definition at the Beginning

Good

Best

You’ve drilled into a query and want to go back to original starting point

Good

Best

Free form MDX

N

Y

Save Queries using Microsoft Save

Y

Y

Copy across worksheets

Y

Y

1 comment:

Kevin Bermingham said...

This is a great site. Have you ever seen voice recognition and Hyperion Smartview work together? Check out Savant. http://talvisllc.com/savant/