Setting Up Dynamic Link Views

Use dynamic link views to customize link behavior. With a dynamic link view, you can change the connection, row, column, POV, and column information.

To set up a dynamic link view:

  1. Set the HypUseLinkMacro flag to True.

    When HypUseLinkMacro is set to False, the predefined link query is performed.

  2. Set the macro name to run.

    The macro name you set should contain all the function calls to initialize the grid and to set the connection, row, POV, and column items as needed.

  3. Connect the sheet and retrieve the appropriate grid onto the sheet.
  4. Select a data point on the sheet.
  5. From the Essbase ribbon, select Visualize, then Visualize in Excel.

    The macro set in step 2 is executed, and the link action is performed.