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

● Select Essbase > Linked Objects to open the Linked Objects Browser dialog box.

● In the Essbase Options dialog box, select the Enable Linked Object Browsing check box to enable double-

clicking to view linked objects.

3. Select the partition that you want to connect to and click View/Launch.

Essbase creates a new worksheet that contains the dimensions and members for the cell in the linked

partition.

You need the proper privileges to access a linked partition. If your user account and password

match the account information for the linked partition, Essbase establishes a connection with

the linked partition. Otherwise, Essbase displays the Essbase System Login dialog box for you to

enter the user account and password manually.

Updating Data on the Server

Data values are changed frequently in applications that involve planning, budgeting, and

forecasting. After you retrieve data into the worksheet, you can use Spreadsheet Add-in to change

values, enter formulas, and format data. Essbase is also designed to permit multiple-user,

concurrent database access and update.

Depending on your security privileges, you may be able to modify all data values or a certain

subset of values. To recognize cells to which you have read/write access, apply a visual cue, or

style, to the cells. For more information on applying styles, see “Applying Styles to Data Cells”

on page 59.

To update data from a worksheet, you must lock the database area that contains the values that

you want to change. Locking prohibits other users from changing the data that you want to

update. Other users can retrieve locked data but cannot lock or change the data. You have

exclusive update rights to that area.

Note:

You cannot update attribute-related data on the server because attribute data is always calculated

dynamically and, hence, is not saved.

You can lock data values in three ways:

● The Retrieve & Lock command retrieves data into the worksheet while locking

the corresponding data area on the server. When you perform a subsequent retrieval, Essbase

automatically unlocks the previous data values.

Note:

The Retrieve & Lock command is not supported with Dynamic Time Series members.

● The Lock command locks information that you have already retrieved. When you perform

a subsequent retrieval, Essbase automatically unlocks the previous data values.

● The Update Mode check box in the Mode tab of the Essbase Options dialog box

automatically locks the corresponding database area for each retrieval.

Updating Data on the Server

147

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

Sem comentários

Arrow Storage Products EN106 Guia do Utilizador Página 147