Arrow Storage Products EN106 Guia do Utilizador descarregar pdf (Página 173)

● The same physical table and column in the relational source database

● The same member level in the underlying OLAP metaoutline

● The same hierarchy

A multi-cell drill-through operation is valid only if all three criteria noted above are met. A

message is displayed if the combination of cells you select is not valid for performing a multi-

cell drill-through operation.

2 Access the Linked Objects Browser in either of these ways:

● Select Essbase > Linked Objects to open the Linked Objects Browser dialog box, as shown

in Figure 184.

Figure 184 Linked Objects Browser Dialog Box with Drill-Through Entry Selected

● In the Essbase Options dialog box (Global tab), select the Enable Linked Object Browsing

check box.

This process enables you to double-click a linked object cell to open the Linked Objects

Browser dialog box.

This option works only with single-cell selection. If you select a range of cells, use the

Essbase > Linked Objects menu command.

3 Select the drill-through report entry and click View/Launch.

4 In the Select Drill-Through Report dialog box, select Market detail and click Execute.

The results of the drill-through report are displayed in a spreadsheet. The results of the Market

Detail report shows that the regional director for the East region is John West and that the

population for New York is between 18,000,001-21,000,000.

Figure 185 Results of Market Detail Drill-Through Report

If there is only one report available for the cells that you select in the spreadsheet and if that

report is not designed to be customized, the drill-through process generates the report and

immediately displays the results in the spreadsheet. The person at your organization who

Using Drill-Through

173

1 2 ... 168 169 170 171 172 173 174 175 176 177 178 ... 199 200

Sem comentários

Arrow Storage Products EN106 Guia do Utilizador Página 173