Arrow Storage Products EN106 Betriebsanweisung PDF herunterladen (Seite 41)

members in columns pivot to rows, and level 0 attribute members already in rows remain

in rows.

● A drill-down on non-level 0 attribute members is the same as the current drill- down

behavior for other types of members.

The drill-down behavior for non-level 0 attribute members is the same as the current drill-down

behavior for other types of members. See the Spreadsheet Add-in online help for examples of

drilling down on level 0 attribute members. For more information on attributes, refer to the

Hyperion Essbase - System 9 Database Administrator's Guide.

Drilling Up to Less Detail

With Essbase, you can drill up to higher levels in the multidimensional database outline by

collapsing the current member tree. For example, if you previously drilled down on a dimension,

such as Scenario, to view data for Actual and Budget, you may need to drill up to view aggregate

data for the Scenario dimension.

Three options are available for drilling up on a member:

● Select the member and select Essbase > Zoom Out.

● Select the member and double-click the secondary mouse button.

● Select the member and click the Zoom Out button on the Essbase toolbar.

➤ To drill up on the Scenario dimension in the current worksheet:

1 Return to the worksheet that you kept open in step 4 on page 39

2 On any member of the Scenario dimension (that is, cell C2, D2, E2, F2, or G2), double-click the secondary

mouse button.

Essbase collapses the members of the Scenario dimension. The result is shown in Figure 20:

Figure 20 Result of Drilling Up on the Scenario Dimension

3 In cell A3, double-click the secondary mouse button to drill up on East.

Essbase collapses East, West, South, and Central into the single Market dimension and keeps

the dimension in the A column, as shown in Figure 21.

Retrieving Data

1 2 ... 36 37 38 39 40 41 42 43 44 45 46 ... 199 200

Keine Kommentare

Arrow Storage Products EN106 Betriebsanweisung Seite 41