View data
You can view data with the Spreadsheet Add-in, other Hyperion tools, or third-party tools.
View data using Spreadsheet Add-in
- Add Spreadsheet Add-in to Microsoft Excel or Lotus 1-2-3.
- Install the Essbase Toolbar (for Excel only).
- Start Spreadsheet Add-in.
- Connect to the database on OLAP Server.
- To retrieve data, select Essbase > Retrieve in the spreadsheet.
- To drill down to more detailed data for a member, select the member and select Essbase > Zoom-in (also called drill-down).
- Alternatively, to create a query with Essbase Query Designer (EQD), select Essbase > Query Designer.
- To view the results of the query, in the navigation panel, click the right-mouse button and select Apply Query.
View data using other tools
You can also use other Hyperion tools, for example Hyperion Analyzer, or third-party tools to view data. For details, see the documentation for that particular tool. For a list of tools, visit the Hyperion site: http://www.hyperion.com .