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

Essbase retrieves all members of Market and Scenario, as shown in Figure 23. For the Market

dimension, Essbase drilled down two levels to get to the bottom-most members, which are

individual states. The Scenario dimension contains only one member level, so the members of

Scenario would also be retrieved if you selected Next Level in the Zoom In option group.

Figure 23 Result of Drilling Down to All Member Levels

5 Select Essbase > Options and select the Zoom tab.

6 Return the Zoom In option setting to Next Level.

If you want to drill up on only one quarter of the year, select Within Selected Group in the

Member Retention option group.

➤ To drill up only on Qtr1:

1 In the Member Retention option group on the Zoom tab, click the Within Selected Group check box and

click OK.

Make sure that Include Selection is also still checked.

2 Double-click the secondary mouse button to drill up on Qtr1 in cell B3.

Figure 24 shows that drilling up to the Year dimension affects only New York. All other states

show data for all four quarters.

Figure 24 Result of Drilling Up Within a Selected Group

3 Before moving on with the tutorial, disable the Within Selected Group option:

a. Select Essbase > Options and select the Zoom tab.

b. In the Member Retention option group, clear the Within Selected Group check box, and

click OK.

4 Select File > Close to close the worksheet.

Retrieving Data

1 2 ... 38 39 40 41 42 43 44 45 46 47 48 ... 199 200

Sem comentários

Arrow Storage Products EN106 Guia do Utilizador Página 43