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

Figure 111 Worksheet Containing EssCell Functions

In Excel, cells B16 and B17 contain the EssCell function. If you select either of these cells, you

can view the syntax for the EssCell function in the formula bar at the top of the worksheet.

The EssCell function in Excel is defined in a cell as follows:

=EssCell(

mbrList

)

In Excel, mbrList is one of the following factors:

● A null value. If the parameters of the function are empty, Essbase returns the data value

from the top of each dimension.

● A comma-delimited list of member names. Member names must be enclosed in double

quotation marks, with only one member per dimension allowed. If you list no members

from a particular dimension, the function returns the data value from the top member of

the unspecified dimension. Furthermore, you can include aliases in the member list, subject

to the same rules as member names.

● A worksheet cell reference. The reference must point to a cell that contains a valid member

name. Member names, such as 200 and 300-10, need to be formatted as text cells, rather

than numeric cells.

For example, the syntax for the EssCell function in cell B16 in the

Summary.xls file for

Excel is as follows:

=EssCell("Sales", A1, A2, B4, F5)

When you open the worksheet, the values in these cells are #N/A. To update the values with

the data in your database, you must perform a retrieval from Essbase.

3 Select Essbase > Retrieve.

Essbase calculates the EssCell functions in cells B16 and B17.

Performing Advanced Retrieval Tasks

115

1 2 ... 110 111 112 113 114 115 116 117 118 119 120 ... 199 200

Sem comentários

Arrow Storage Products EN106 Guia do Utilizador Página 115