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

Resource Locator) can then be retrieved by the Spreadsheet Add-in users who have access to the

database.

Note:

If your organization has licensed and implemented the Essbase Partitioning option, you can also

access linked partitions from cells in Spreadsheet Add-in. For more information on linked

partitions, see “Ways to Access Linked Partitions” on page 145.

In this topic, the following procedures are discussed:

● “Linking a File to a Data Cell” on page 134

● “Linking a Cell Note to a Data Cell” on page 137

● “Linking a URL to a Data Cell” on page 138

● “Accessing and Editing Linked Reporting Objects” on page 140

For additional information on using linked reporting objects, see the Spreadsheet Add-in online

help.

Linking a File to a Data Cell

Using the linked reporting objects feature, you can link an external file to a data cell in

Spreadsheet Add-in. Essbase stores the file on the Essbase Server. Users who have access to the

database can then retrieve the file and view the data contained in the cell.

The following example uses the

Asymm.xls sample worksheet with data from the Sample Basic

database. It links a sample file,

Budasmp.txt, to a cell containing the Budget figure.

Budasmp.txt details the budgetary assumptions for the current year.

➤ To link a file to a data cell:

1 Select File > Open.

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

3 Make sure that you are connected to the Sample Basic database.

If you are not connected, see “Connecting to a Database” on page 89.

4 Select cell D5, as shown in Figure 141.

Note:

You can link objects only to data cells, not to cells containing member names.

134

Advanced Tutorial

1 2 ... 129 130 131 132 133 134 135 136 137 138 139 ... 199 200

Sem comentários

Arrow Storage Products EN106 Guia do Utilizador Página 134