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

Figure 110 Result of Retrieving Second Range of Data

6 Close the file without saving it.

Retrieving Data by Using a Function

The Essbase cell retrieve function, EssCell, retrieves a single database value into a worksheet cell.

Enter an EssCell function directly into a worksheet or select an EssCell function from the

spreadsheet menu bar.

Note:

You must be connected to a database to use EssCell.

EssCell retrieves data when you perform an Essbase retrieval or when you recalculate a worksheet

through Excel. As part of the default Essbase installation, the

Summary.xls sample file is

provided with EssCell functions already set in cells B16 and B17.

➤ To view the Summary.xls file:

1 Select File > Open.

2 From the \AnalyticServices\client\sample directory, open the Summary.xls file.

Note:

Depending on how software is installed on your PC, the file may not be available or may be

located in a different directory. Contact the Essbase system administrator for the location of this

file.

114

Advanced Tutorial

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

Sem comentários

Arrow Storage Products EN106 Guia do Utilizador Página 114