Lesson: Linking a URL to a Data Cell

You can link a URL to a data cell so that users who access the database can link directly to the specified URL. When you access the cell from Spreadsheet Add-in, the default Web browser opens and displays the specified URL.

  Using a Web browser and Internet access, follow these steps to link a data cell to the Oracle Web site:

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

    Selecting a Data Cell for Linking to a URL

    Note:

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

  2. Select Essbase, and then Linked Objects.

    The Linked Objects Browser dialog box is displayed.

  3. In Linked Objects Browser, click Attach.

    The Attach Linked Object dialog box is displayed.

  4. Under Attachment Type, select URL.

  5. Enter this URL in Location:

    http://www.oracle.com

    The  URL location is limited to 512 characters.

  6. Enter this optional brief description in URL Description

    Oracle home page

    The URL description is limited to 80 characters.

  7. Click OK.

    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 when it is created; 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.

  8. Click Close.

  9. Select Essbase, and then Retrieve.

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

User Reference

Linking URLs to Data Cells.