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

6 Click OK to close the dialog box and link the URL to the cell.

Essbase copies the URL string to the server and establishes a link to the current data cell.

Note:

The syntax for the URL is not checked at the time of creation; Essbase checks the syntax when

the user accesses the URL from the worksheet. The default Web browser checks for the existence,

or validity, of the URL.

7 Click Close to close the Linked Objects Browser dialog box.

8 Select Essbase > Retrieve to refresh the worksheet and apply the style that you defined for linked objects.

Leave the Asymm.xls file open for the next tutorial task.

The following topics explain how to access linked reporting objects from Spreadsheet Add-in.

Accessing and Editing Linked Reporting Objects

Two options are available for accessing and editing a linked reporting object that is attached to

a data cell:

● Select the cell (as identified by the style applied to it) and select Essbase > Linked Objects.

● Enable double-clicking for linked object browsing.

Note:

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.

For this tutorial, you access the linked reporting objects that you created in the previous sections

by using the Essbase menu item instead of the double-clicking action.

Accessing a Linked File

Sometimes you want to check an external file that is linked to a data cell.

➤ To access the external file that you previously linked to a data cell:

1 In the Asymm.xls file, select cell D5.

2 Select Essbase > Linked Objects.

3 In the Linked Objects Browser dialog box, select the Budasmp.txt file, as shown in Figure 151.

140

Advanced Tutorial

1 2 ... 135 136 137 138 139 140 141 142 143 144 145 ... 199 200

Sem comentários

Arrow Storage Products EN106 Guia do Utilizador Página 140