Including Click-through Capability Using the Dashboard Wizard

Dashboard designers can include sub-charts on a dashboard when creating the dashboard, or later, by editing the dashboard. The click-through capability is available for chart widgets.
To include click-through capability to sub-charts or dashboards on a widget, do the following:
  1. Click (gear) on the widget that will have the click-through capability to edit the settings.
  2. Select the sub-chart type or
    Dashboard
    in the Drill Down field.
  3. Click
    Add
    .
  4. (Chart only) Configure the chart query as follows:
    1. Select the type of query. The options are MDX/Cube Query or SQL/Database Query.
    2. Select the connection.
    3. Enter the server name. This is the server that has the data.
    4. Select the database.
    5. (MDX query only) Select the cube to query.
    6. (Optional) Click
      Cache Query
      to cache the query results.
    7. Define the query as follows:
      Modifying an MDX query using the Query Editor invalidates and disables the Query Designer for the widget.
      • For an MDX query, select the fields by dragging the field to the Selected Fields area, and entering additional query specifications in the MDX Segments area. The Query Editor can also be used to enter an MDX query.
      • For a SQL query, enter a query in the Query Editor area.
        When defining a Gantt chart, ensure there are start and end date columns for each result. The date columns must be
        datetime
        types.
    8. Click
      Generate Columns
      under the Columns tab to generate the columns for the query.
    9. (Optional) Edit the column elements listed in the Column Source area by clicking an element, and selecting
      Edit
      . After you have made your changes, click
      Update
      to save.
      You can customize elements, such as the following:
      • Change the text that appears for the Measure Label
      • Set word wrap for displayed text
      • Define which columns are exportable to Microsoft Excel
      • Set the number format
      • Set the Group By option
      Only one column can be selected as the Group By column.
      For Gantt charts, ensure that the start and end date columns are identified in the Column Collection section.
    10. (Optional) Set colors for the chart. Colors can be set by returned results order or by measure. For information about setting colors, refer to Setting Custom Colors.
    11. Click
      Update
      to save the edits.
    12. Click
      Save
      to save the sub-chart settings.
  5. (Dashboard only) Select the dashboard for the click-through, and then click
    Save
    .
  6. (Optional, chart only) Repeat the preceding steps to add another sub-chart or dashboard to the sub-chart.
  7. Click
    Save
    to save the widget, and then click
    Save
    to save the dashboard.

Editing a Click-through Chart Using the Dashboard Wizard

To edit a click-through chart or dashboard using the dashboard wizard, do the following:
  1. In the
    Symantec ICA
    Administration section, select
    Dashboards
    , and then select
    Dashboards
    .
  2. Right-click the dashboard name, and select
    Edit
    .
  3. Select the widget that has the sub-chart or dashboard.
  4. Click (gear) on the widget.
  5. Click
    Edit
    in the Drill Down section.
    A click-through chart or dashboard can be removed by clicking
    Delete
    .
  6. Edit the sub-chart or select a different dashboard, as needed.
  7. Click
    Save
    to save your changes, and then click
    Save
    to save the chart.
  8. Click
    Save
    to save the dashboard.