Building Dashboards

  To build dashboards:

1. Use the Dashboard Studio wizard, or the Webdash Builder component Build Dashboard frame.

   See “Chapter 4, Using Dashboard Studio to Develop Dashboards” for wizard steps in the Hyperion Interactive Reporting – Object Model and Dashboard Development Services Developer's Guide, Volume 5: Dashboard Studio, or Dashboard Studio Webdash Builder Component.

2. Merge the necessary components to the document.

   See Merging Components.

3. Use the Query Panel to create query limits.

4. Set the Query Panel as the default startup section.

5. Import the Excel spreadsheet that was created when building a network of dashboards.

   The spreadsheet defines the sources and targets in the dashboard. For simplicity, the documents should share the same spreadsheet.

6. From Sections, select Drill Across Properties and identify the table that contains the source and target mappings.

   See Using the Drill Across Properties Frame.

   Using the OnCellDoubleClick event, the component:

   • Navigates to each embedded pivot on a dashboard that acts as a launch point for a drill across operation and enters Design mode

   • Copies and pastes the common line of script from any button on the toolbar into the OnCellDoubleClick event:

     ActiveDocument.Sections.Item(txlMe.Text).Qiq_onControlClick(this.Parent,this)