Attaching a Linked Reporting Object to a Data Cell

You can attach one or more linked reporting objects to a data cell.

To attach a linked reporting object to a data cell:

  1. Ensure that you're working with a connected worksheet.

    Note:

    If you are working with a saved ad hoc sheet or a grid layout that contains no data yet (for example, a free-form grid), you are not required to refresh the sheet first. Ensure that you are connected to the data provider, then right-click the correct database in the Smart View Panel, and then select Set Active Connection for this Worksheet.

  2. Select a data cell.
  3. From the Essbase ribbon, select Linked Objects.
  4. From Linked Reporting Objects, click Attach button and select one of the following:
    • Cell Note to attach an annotation to the data cell

    • File to attach an external file to the data cell

    • URL to attach a URL to the data cell

    The dialog box appropriate to your selection is displayed.

  5. Enter information as follows:
    • Cell Note: Enter text for the note. Then click Close. The first few words of the note are displayed in the Description column of the Linked Reporting Objects list.

    • File: Use the Browse button to navigate to the file that you want to attach to the data cell. You can add a brief description for the file. Then click Close.

    • URL: In URL, enter a URL for a web site, a network or local directory, or a document in a network or local directory. You can add a brief description for the URL. Then click Close.

  6. Repeat the procedure to attach other linked reporting objects as needed.

    The objects that you created are displayed in the Linked Reporting Objects list as shown here:


    Linked Reporting Objects dialog box with Launch, Attach, Edit, Delete, and OK buttons. Linked reporting objects are displayed in a list.
  7. Refresh the grid to apply the cell style (if specified) to the cell.

To edit or delete a linked reporting object, use the Edit button Edit button or Delete button Delete button. Deleting an object removes it from the database.

Related topics: