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

To update the server with data values from the worksheet, use the Send command on the Essbase

menu. After updating the server, the Send command automatically unlocks data (unless you are

in Update Mode). You must clear Update Mode to stop the automatic locking of blocks.

You can unlock data blocks in two ways:

● The Unlock command unlocks all blocks that you have locked.

● The server automatically unlocks data blocks that have been locked for the maximum time

allowed as defined by the Essbase system administrator. Automatic unlock ensures that

blocks are not locked for extended periods of time.

The

P&l.xls file is installed as part of the default Essbase installation. This file illustrates how

to update data on the server.

➤ To view the P&l.xls worksheet:

1 Select File > Open.

2 From the \AnalyticServices\client\sample directory, open the P&l.xls file.

3 Select Essbase > Retrieve & Lock.

Essbase retrieves data and locks the appropriate area of the database, as shown in Figure 159.

Figure 159 P&L Worksheet After Retrieve & Lock

4 Change the value for Sales in Jan (cell B12) to 4000 and press Enter.

Essbase changes the affected data values.

5 Select Essbase > Send to update the server with the new values.

Essbase updates the server and unlocks the data blocks.

148

Advanced Tutorial

1 2 ... 143 144 145 146 147 148 149 150 151 152 153 ... 199 200

Sem comentários

Arrow Storage Products EN106 Guia do Utilizador Página 148