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 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:
Query Designer Properties Fields
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.