To define queries for data cubes
- Click the Query tab.
- Click Add. The Query window opens. Complete the fields in the Query window as described in the table below.
In this field: | Do this: |
---|---|
Name | Enter the name of the query. |
Data Cube | Choose a data cube to use as a data source for the custom dashboard.
|
Source Grouped By | Choose a column from Data Cube definition by which to group data. This drop-down list lists those data elements that are marked Group By in Data Cube definition. Changing the value under this drop-down should always reset values under Report On and Summary Type. |
Output Type | Choose the output type, which determines the output after grouping data based on Source Grouped By column. Following are the options
|
Report On | Choose a column defined in the data cube from among those designated as Summary. |
Summary Type | This drop-down shows a list of possible summary types. Values shown under this drop-down are based on the type of Report On data element:
|
Next, specify cache details in the Cache tab, as described in the following procedure.