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

Figure 16 Result of Drilling Down on the Market Dimension (Nested Rows)

Because worksheets can accommodate more rows than columns, Essbase is preset to retrieve

data into rows when you drill down on a member. You can change this default behavior and

display the results of a drill-down across columns. Drilling across columns applies only to the

top-level member of a dimension (for example, Market or Scenario).

➤ To drill down on Scenario and retrieve its respective members into columns rather than rows:

1 Press and hold down the Alt key.

2 Double-click Scenario (in cell E1).

3 Release the Alt key.

Essbase displays the data in columns across the worksheet, as shown in Figure 17.

Figure 17 Result of Drilling-Down on the Scenario Dimension (Nested Columns)

4 Keep this worksheet open, but do not save it yet.

You use this worksheet again in “Drilling Up to Less Detail” on page 41.

You will open a new worksheet to complete the steps in “Drilling Down on Attribute Members”

on page 39 and “About Drilling Down on Level 0 Attribute Members” on page 40.

Drilling Down on Attribute Members

You can use the Essbase attribute feature to retrieve and analyze in terms of characteristics, or

attributes, of dimensions. For example, you can analyze product profitability based on the

attributes of size or packaging. Attribute dimensions are associated with base dimensions.

You can use an attribute dimension to drill down on the base dimension with which it is

associated. In the Sample Basic database, the Product base dimension is associated with several

attribute dimensions, such as Caffeinated, Ounces, and Pkg_Type. Each attribute dimension

Retrieving Data

1 2 ... 34 35 36 37 38 39 40 41 42 43 44 ... 199 200

Sem comentários

Arrow Storage Products EN106 Guia do Utilizador Página 39