Setting Up Dynamic Link Views

Use dynamic link views to customize the link behavior according to your requirements. With dynamic link view, you can change the row, column, POV, and column information as well as the connection information.

  To set up a dynamic link view:

  1. Set the HypUseLinkMacro flag to true.

  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 name set in step 2 is executed and the link action is performed.

Note:

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