Define queries for shell dashboard data cubes

To define queries for shell dashboard data cubes

Click the Query tab.
Click Add. The Query window opens. Complete the fields on the Query tab.

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. For a company-level custom dashboard, the data cube must be defined as Company Data Cube. For a shell-level custom dashboard, the data cube must be defined as Shell Data Cube.
Show Data From	Determine the level from which the data cube should pull information. Current Shell Only Subshells Only Current Shells and sub-shells
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 Record Count Summary Value
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: For Numeric type of data element: Summary, Min, Max, Average For Date type of data element: Min/Max

Last Published Monday, October 4, 2021