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

Note:

The Partitioning product also enables the Essbase application designer to set up transparent or

remote partitions. For more information on partitioning, see the Hyperion Essbase - System 9

Database Administrator's Guide.

You can set visual cues, or styles, for cells tagged as linked objects. These cells are access points

to the linked partition within the linked database. Two options are available for accessing a linked

partition from a data cell in Spreadsheet Add-in:

● Select the cell and select Essbase > Linked Objects.

● Enable double-clicking for linked object browsing.

If you enable double-clicking for linked object browsing, double-clicking behavior changes

for retrieving data and performing drill actions. For more information on these changes,

see the Spreadsheet Add-in online help.

When you select Essbase > Linked Objects from a linked partition cell, Essbase completes the

following actions:

● Essbase displays the Linked Objects Browser dialog box, which contains a list of possible

partitions which you can access. From this dialog box, select the partition to connect to.

The Linked Objects Browser dialog box may also contain a list of linked reporting objects,

such as cell notes and external files. For more information on linked objects, see “Using

Linked Reporting Objects” on page 133.

● After you select a partition, Essbase creates a new worksheet that contains corresponding

members and dimensions for the cell in the linked partition.

Note:

Essbase does not preserve formulas across partitions.

● Essbase retrieves data values from the linked partition.

You can now perform operations such as drill down and drill up to get more information on

the new worksheet.

Note:

The Sample Basic database that you are using for this tutorial does not contain a linked partition.

However, the instructions for accessing a linked partition are shown as an optional task in the

light-colored box below.

This task is optional. Optional tasks do not need to be performed as part of the tutorial. They are provided for information

only.

To access a linked partition in Spreadsheet Add-in if the Essbase application designer has set up a linked partition:

1. Locate a linked object cell, as indicated by the style applied to the cell.

2. Access the Linked Objects Browser dialog box in either of these ways:

146

Advanced Tutorial

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

Sem comentários

Arrow Storage Products EN106 Guia do Utilizador Página 146