About the Query Designer in the Dashboard Wizard
The Query Designer is available when configuring a query widget, such a bar chart or pie chart. The dashboard designer uses the Query Designer to create an MDX query for the widget. All queries must include at least one measure. The Query Designer has the following fields:
Query Designer Field | Description |
|---|---|
Column Collection | Shows the fields that can be measured or axis values. |
Field List | Lists the available fields in the Symantec ICA cube. |
MDX Segments | Allows additional criteria that limits the query results. |
Selected Fields | Lists the selected fields. |
Where Clause | Filters data based on the criteria in the WHERE clause. |
Dragging a measure or dimension to the Selected Field section brings up the properties page. The following fields are on the properties page:
Properties Field | Description |
|---|---|
Display | Sets the displayed field name. |
Is Default Sort | Sets the default column used for sorting. |
Name | Sets the field name. This links the field to any available entity actions. |
Node Value | Sets the node value. |
Sort Direction | Sets the sort order. |
Source | Shows the source of the fields. The source is the dimension or measure. |