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

The Sample Basic database that you are using for this tutorial does not contain predefined

substitution variables. If the application designer had set a substitution variable in the database

that you are using, you could enter a substitution variable directly into a worksheet.

For example, you could open a blank worksheet and type member names, as shown in

Figure 119.

Figure 119 Entering a Substitution Variable in a Worksheet

Notice the substitution variable (CurMnth) in cell A2. When you enter a substitution variable

directly into a cell, you must precede it with an ampersand (&).

In this example, a retrieval produces the results shown in Figure 120.

Figure 120 Result of Retrieval on a Substitution Variable

Essbase queries the server for the value of the substitution variable CurMnth, which is August.

Data is returned only for August.

Note:

If you save a worksheet containing a substitution variable as a template, make sure that you save

the worksheet before you retrieve data. For example, if you save the worksheet shown in

Figure 120 as a template, each time you retrieve the template, August rather than the substitution

variable CurMnth is displayed.

Using Free-Form Reporting to Retrieve Data

So far, you have been shown how to retrieve Essbase data into a worksheet through ad hoc

retrieval, Essbase Query Designer queries, and Member Selection operations. In addition to these

retrieval methods, Essbase supports free-form reporting.

Free-form reporting enables you to tell Essbase specifically what you want to retrieve by typing

data into the worksheet. This free-form of reporting is especially useful when you are familiar

with the dimensions and members in the database outline.

Essbase provides two different retrieval modes for free-form reporting:

● Advanced Interpretation

● Free-Form

122

Advanced Tutorial

1 2 ... 117 118 119 120 121 122 123 124 125 126 127 ... 199 200

Sem comentários

Arrow Storage Products EN106 Guia do Utilizador Página 122