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

This feature is especially useful when dealing with dynamic calculation members, which are

usually specified by the application designer. By activating Navigate Without Data, you are

effectively telling Essbase not to calculate values dynamically (that is, calculate the database at

retrieval time) while you are creating the spreadsheet report. Dynamic calculation is discussed

in more detail in “Retrieving Dynamic Calculation Members” on page 117.

➤ To navigate through the worksheet without retrieving data:

1 Select Essbase > Navigate Without Data.

Essbase displays a check mark next to the menu item.

You can also disable Navigate Without Data by clearing the appropriate option in the Global

tab of the Essbase Options dialog box or by clicking the Navigate Without Data button on the

Essbase toolbar.

2 In cell D2, double-click the secondary mouse button to drill up on Qtr2.

Essbase shows the collapsed Year dimension but withholds retrieving any data that is changed

as a result of drilling up. The cells where data would usually be displayed are blank. The result

is shown in Figure 36.

Figure 36 Result of Zooming Out (Navigate Without Data Enabled)

3 In cell D2, drill down (double-click) on Year by pressing and holding down the Alt key.

Essbase drills down without retrieving data.

4 In cell C3, select Actual and select Essbase > Pivot.

Essbase executes the pivot but does not retrieve data. The result is shown in Figure 37.

Note:

You get the same result by pivoting any of the other Scenario members.

Basic Tutorial

1 2 ... 45 46 47 48 49 50 51 52 53 54 55 ... 199 200

Sem comentários

Arrow Storage Products EN106 Guia do Utilizador Página 50