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

Figure 122 Retrieving Data into a Free-Form Report

Now define a free-form report that does not contain all the dimensions from the database. In

Advanced Interpretation mode, you may need to enter a dummy data value, such as 0, into the

first data cell to indicate to Essbase where the data starts in the worksheet. Be sure to use a numeric

value as the dummy value.

For example:

6 Select Essbase > FlashBack.

7 Delete cells A1, B1, and C1.

8 In cell B4, type 0 to provide Essbase with a data cell reference point.

Figure 123 Defining a Free-Form Report Without All Dimensions

9 Select Essbase > Retrieve.

Essbase adds the dimensions that were omitted from the free-form report to the worksheet and

retrieves data.

Figure 124 Retrieval in a Free-Form Report Without All Dimensions

10 Select File > Close to close the worksheet.

You do not need to save the worksheet.

Using Free-Form Mode

Similar to Advanced Interpretation mode, Free-Form mode enables you to enter member names

into any location in a worksheet and then interprets the contents of the worksheet when fulfilling

the retrieval request. In addition, with Free-Form mode, you can use Essbase report script

commands to retrieve data into a worksheet.

124

Advanced Tutorial

1 2 ... 119 120 121 122 123 124 125 126 127 128 129 ... 199 200

Sem comentários

Arrow Storage Products EN106 Guia do Utilizador Página 124