Before starting the tutorial, you should be familiar with the Essbase product from using the Spreadsheet Add-in interface.
A sample Essbase database is the basis for the examples in this tutorial. The database administrator creates this sample Essbase database using the sample metaoutline supplied with Integration Services (see Oracle Essbase Integration Services Online Help). A sample spreadsheet file, Essdt.xls, contains a worksheet with the member intersections for the sample drill-through report. See About the Samples Used in This Tutorial.
If you plan to follow the examples in a live working session, check with the person at your organization who installs theIntegration Services product family for information on the sample database that you need for drill-through, and to which instance of Essbase Server you should connect.
The Essdt.xls file also contains sample results of the drill-through reports when you run them without customizing the reports. The results are provided in separate sheets in the workbook so that you can see the sample report results without working through the tutorial. See About the Samples Used in This Tutorial. |
Before starting the tutorial, ensure that you meet these requirements:
The Essbase system administrator must install the Essbase Server.
You must have access toIntegration Services and to an instance of Essbase Server. Contact the Essbase system administrator or the person who administers Integration Services at your organization.
You must have access to the underlying relational database (typically using a user name and password that differ from those that you use for Essbase). To obtain access, contact the Essbase system administrator or the person who administers Integration Services at your organization.
Ensure that the Essdt.xls sample drill-through report spreadsheet is available in EPM_ORACLE_HOME/products/Essbase/EssbaseClient/client/sample.
To use the Essdt.xls sample drill-through report spreadsheet, log on to a computer with Essbase Server and Integration Services installed. You must perform a member and data load and calculate the data for the sample Essbase database that you access from Spreadsheet Add-in.
The sample database containing the drill-through report must be running. The sample drill-through reports used in this tutorial (called “Market Detail,” “Measures Detail,” and “Product Detail”) are available with the sample spreadsheet files. Contact the person at your organization who installs Integration Services to ascertain the name of the sample database to use for drill-through.
See the Oracle Hyperion Enterprise Performance Management System Installation and Configuration Guide.