OLAP Spreadsheet Add-in User's Guide for 1-2-3

Using Linked Reporting Objects

A linked reporting object is an external file, cell note, or World Wide Web resource that you link to a cell in a Hyperion Essbase database. The file, note, or Web resource (indicated by a URL, or Uniform Resource Locator) can then be retrieved by the Hyperion Essbase Spreadsheet Add-in users who have access to the database.

Note:

If your organization has licensed and implemented Hyperion Essbase Partitioning option, you can also access linked partitions from cells in Hyperion Essbase Spreadsheet Add-in. For more information on linked partitions, see Accessing Linked Partitions.

This section describes the following procedures:

• Linking a File to a Data Cell
• Linking a Cell Note to a Data Cell
• Linking a URL to a Data Cell
• Accessing and Editing Linked Reporting Objects

Linking a File to a Data Cell

With the linked reporting objects feature, you can link an external file to a data cell in Hyperion Essbase Spreadsheet Add-in. Hyperion Essbase stores the file on the Hyperion 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.123 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.

Follow these steps to link a file to a data cell:

1. Select File > Open.
2. From the \essbase\client\sample directory, open the Asymm.123 file.
3. Make sure that you are connected to the Sample Basic database. If you are not connected, see Connecting to a Database.
4. Select cell D5.

   Note:

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

   Figure 140. Selecting a Data Cell for Linking an External File
   

5. Select Essbase > Linked Objects.

   Hyperion Essbase displays the Linked Objects Browser dialog box.

   Figure 141. Linking a File
   

6. In the Linked Objects Browser dialog box, click the Attach button.

   Hyperion Essbase displays the Attach Linked Object dialog box.

7. Under the Attachment Type option group, select File.

   Figure 142. Linking a File to a Data Cell
   

8. Click the Browse button (next to the File Name text box).

   Hyperion Essbase displays the Browse Files dialog box.

9. Go to the \essbase\client\sample directory and select the Budasmp.txt file.
10. Click Open.
11. Under File Description, enter a brief description for the file as indicated in Figure 143.

    Figure 143. Selecting and Describing a File to Link
    

    Note:

    Entering text in the File Description text box is optional.

12. Click OK to close the dialog box and link the file to the cell.

    Hyperion Essbase copies the file to the server and establishes a link to the current data cell.

13. Click Close to close the Linked Objects Browser dialog box.
14. Do not close the Asymm.123 file. You use it in the next tutorial task.

    To recognize cells that have linked reporting objects attached to them, you may want to apply a visual cue, or style, to the cells.

To apply styles:

1. Select Essbase > Options and select the Style tab.
2. In the Data Cells area, select Linked Objects.
3. Click Format.
4. In the Font style list box, select Italic.
5. In the Color list box, select Purple. Click OK.
6. Select the Display tab.
7. In the Cells option group, select the Use Styles box. Click OK.
8. Select Essbase > Retrieve to refresh the worksheet and apply the styles.

   Cell D5 (the cell you just attached the linked file to) is now displayed in purple, italic font. Hyperion Essbase also refreshes the worksheet with the other options set in the Essbase Options dialog box.

   Figure 144. Result of Applying a Style to a Linked Reporting Object Cell
   

9. Leave the Asymm.123 file open for the next tutorial task.

Linking a Cell Note to a Data Cell

In addition to linking external files to a data cell in Hyperion Essbase Spreadsheet Add-in, you can also link individual cell notes that contain information on particular data cells. Cell notes can have no more than 599 characters. If you need to link information to a data cell that is longer than 599 characters, you need to create and save an external file and then link the file to the data cell.

To link a cell note to a data cell:

1. In the Asymm.123 file, select cell C5.

   Note:

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

2. Select Essbase > Linked Objects.

   Hyperion Essbase displays the Linked Objects Browser dialog box.

3. In the Linked Objects Browser dialog box, click Attach.

   Hyperion Essbase displays the Attach Linked Object dialog box.

4. Under the Attachment Type option group, select Cell Note.
5. In the Cell Note box, type the note as indicated in the following illustration:

   Figure 145. Creating a Cell Note to Link
   

6. To close the dialog box and link the cell note, click OK.

   Hyperion Essbase copies the note to the server and establishes a link to the current data cell.

7. To close the Linked Objects Browser dialog box, click Close.
8. Select Essbase > Retrieve to refresh the worksheet and apply the style you defined for linked objects.

   Now Hyperion Essbase displays two data cells (C5 and D5) in purple, italic font to represent a cell that contains a linked reporting object.

   Figure 146. Result of Creating a Linked Cell Note
   

9. Leave the Asymm.123 file open for the next tutorial task.

Linking a URL to a Data Cell

A URL is an address string that identifies resources on the World Wide Web, such as documents, images, and downloadable files. With the linked reporting objects feature, you can link a URL to a data cell so that users who have access to the database can link directly to the specified URL. When you access the cell from Hyperion Essbase Spreadsheet Add-in, your default Web browser opens and displays the specified URL.

Note:

For more information on URL syntax, see the Hyperion Essbase Spreadsheet Add-in online help.

If you have a Web browser and Internet access, follow these steps to link a data cell to the Hyperion Web site:

1. In the Asymm.123 file, select cell E5.

   Note:

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

   Figure 147. Selecting a Data Cell for Linking to a URL
   

2. Select Essbase > Linked Objects.

   Hyperion Essbase displays the Linked Objects Browser dialog box.

3. In the Linked Objects Browser dialog box, click Attach.

   Hyperion Essbase displays the Attach Linked Object dialog box.

4. Under the Attachment Type option group, select URL.

   Figure 148. Linking a URL to a Data Cell
   

5. Enter a URL in the Location text box and a brief description in the URL Description text box, as indicated in Figure 151.

   Figure 149. Entering and Describing a URL to Link
   

   Note:

   Entering text in the URL Description text box is optional. The text field for entering the URL location is limited to 512 characters. The text field for entering the URL description is limited to 80 characters.

6. To close the dialog box and link the URL to the cell, click OK.

   Hyperion 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 creation time; Hyperion 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. To close the Linked Objects Browser dialog box, click Close.
8. Select Essbase > Retrieve to refresh the worksheet and apply the style that you defined for linked objects.
9. Leave the Asymm.123 file open for the next tutorial task.

   Now that you have learned to create linked reporting objects, you are ready to learn how to access them from Hyperion Essbase Spreadsheet Add-in.

Accessing and Editing Linked Reporting Objects

You have two options 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.

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.123 file, select cell D5.
2. Select Essbase > Linked Objects.
3. In the Linked Objects Browser dialog box, select the Budasmp.txt file.

   Figure 150. Accessing a Linked External File
   

4. To view the linked file, click View/Launch.

   The Budasmp.txt file is opened from the source application.

   Figure 151. Viewing the Contents of a Linked External File
   

   Note:

   Edit the contents of a file in the source application. After the edits are made and the file saved, you can re-attach the edited file by clicking the Edit button in the Linked Objects Browser dialog box. Hyperion Essbase displays the Re-attach Linked Object dialog box, which you can use to re-attach, or relink, the edited file to the data cell. For more information, see the Hyperion Essbase Spreadsheet Add-in online help.

5. Close the Budasmp.txt file and click Close to close the Linked Objects Browser dialog box.
6. Leave the Asymm.123 file open for the next task.

Accessing a Linked Cell Note

Sometimes you have to edit a cell note that was previously created.

To access and edit the cell note that you previously created:

1. In the Asymm.123 file, select cell C5.
2. Select Essbase > Linked Objects.

   The Linked Objects Browser dialog box displays the cell note that is linked to the selected data cell.

3. In the Linked Objects Browser dialog box, select the cell note.

   Figure 152. Accessing a Linked Cell Note
   

4. To edit the contents of the cell note, click Edit.

   Hyperion Essbase displays the Edit Cell Note dialog box with the selected cell note displayed.

   Figure 153. Editing the Contents of a Linked Cell Note
   

   Note:

   If you simply want to view the contents of the cell note, click the View/Launch button instead of the Edit button in the Linked Objects Browser dialog box.

5. Edit the contents of the cell note as indicated in the following illustration:

   Figure 154. Result of Editing Cell Note Contents
   

6. Click OK to close the Edit Cell Note dialog box and save the edits you made to the note.

   Hyperion Essbase saves the edits to the cell note on the server.

7. To close the Linked Objects Browser dialog box, click Close.
8. Leave the Asymm.123 file open for the next tutorial task.

Accessing a Linked URL

If you followed the steps in Linking a URL to a Data Cell, you can access and edit the URL that you created.

To access the URL:

1. In the Asymm.123 file, select cell E5.
2. Select Essbase > Linked Objects.

   The Linked Objects Browser dialog box displays the URL that is linked to the selected data cell.

3. In the Linked Objects Browser dialog box, select the URL.

   Figure 155. Accessing a Linked URL
   

4. To view the linked URL, click View/Launch.

   Hyperion Essbase checks the syntax of the URL. If there are syntax errors, Hyperion Essbase displays an error message. If the URL syntax is correct, the default Web browser launches and connects to the specified site. In this case, the syntax for the URL is correct, so the default Web browser launches and connects to the Hyperion Web site.

   Figure 156. Viewing a Linked URL
   

5. Close the Web browser.

To edit the URL:

1. In the Linked Objects Browser dialog box, select the URL.
2. To edit the linked URL, click Edit.

   Hyperion Essbase displays the Edit URL dialog box with the selected URL displayed.

   Figure 157. Preparing to Edit the Contents of a Linked URL
   

3. Edit the URL location and description as show in the following illustration:

   Figure 158. Editing the Contents of a Linked URL
   

4. To close the Edit URL dialog box and save the edits that you made, click OK.

   Hyperion Essbase saves the edits to the URL on the server.

5. To view the new URL, click View/Launch.

   The Web browser launches and connects to the new URL.

   Figure 159. Viewing an Edited URL
   

6. Close the Web browser.
7. To close the Linked Objects Browser dialog box, click Close.
8. Close the Asymm.123 file without saving it.