Arrow Storage Products EN106 Guía de usuario descargar pdf (Pagina 162)

Figure 171 Example of a Drill-Through Sheet

The dimensional attributes of the cell are as follows: Actual, Profit, New York, Feb, and Product.

The combination of one or more of these attributes becomes the basis for a drill-through query

that returns data from the relational source.

From Spreadsheet Add-in, you can access a predefined drill-through report that is based on the

dimension or member intersections of Essbase data cells in the sheet. Using Integration Services

Console, an administrator at your organization sets up drill-through reports for you to access;

that is, each drill-through report is already defined in terms of what to retrieve from the relational

source.

In Spreadsheet Add-in, you can access drill-through reports from the Linked Objects Browser

dialog box, as shown in Figure 172. When you select a drill-through cell in the sheet and select

Essbase > Linked Objects, the Linked Objects Browser dialog box displays a drill-through entry

that you can select and launch.

Figure 172 Linked Objects Browser Dialog Box with Drill-Through Entry

You can define a style for cells tagged as “drill-through” to identify which cells in the spreadsheet

are associated with drill-through reports. For more information on definining styles for drill-

through cells, see “Accessing Drill-Through Reports from the Spreadsheet” on page 169.

About the Drill-Through Wizard

An administrator at your organization can predefine drill-through reports for you to view or to

customize. The person who develops a report determines whether the report can be customized

162

Using Drill-Through

1 2 ... 157 158 159 160 161 162 163 164 165 166 167 ... 199 200

Sin comentarios

Arrow Storage Products EN106 Guía de usuario Pagina 162