The sample database used for this tutorial contains these dimensions: Scenario, Product, Market, Measures, and Year.
For this spreadsheet view, detail-level data exists in a relational data source—data that is not available from Essbase. For example, the relational source contains columns of data for market detail, measures detail, and product detail. The steps in this tutorial walk you through a sample drill-through session, where you drill down into the detail data from the relational source.
This tutorial uses two sample drill-through reports, “Measures Detail” and “Market Detail.” As with all drill-through reports, these reports are predefined to retrieve columns from the relational source. You use the Drill-Through Wizard to customize the report, “Measures Detail.”
The sample file also contains two more sample reports called “Product Detail” and “Two reports” that you can use for drill-through practice. In “Two reports,” select the drill-through cell B3 to select from two drill-through reports, “Product Detail” and Market Detail, select cell B6 to view “Market Detail,” and cell G3 to view “Product Detail.” |
The Essdt.xls file provides sample results of these drill-through reports:
The Market Detail drill worksheet displays the results for Market Detail when you run a drill-through report on cell G4 without customizing the report.
The Measures Detail drill1 worksheet displays the results for Measures Detail when you run a drill-through report on cell C4 without customizing the report.
The Measures Detail drill2 worksheet displays the results for Measures Detail when you run a drill-through report on cell G6 without customizing the report.
The Product Detail drill worksheet displays the results for Product Detail when you run a drill-through report on cell D5.