Define queries for Company Dashboard data cubes

To define queries for data cubes

  1. Click the Query tab.
  2. 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.

  • 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.

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

Next, specify cache details in the Cache tab, as described in the following procedure.


Legal Notices | Your Privacy Rights
Copyright © 1998, 2022

Last Published Tuesday, April 12, 2022