Following is an example of a standard menu for Fact Tables and KPI Fact tables:
WhereScape RED supports the use of keyboard shortcuts—the underlined letter of a menu option. For example, pressing P opens the Properties window of the selected table, pressing D displays data, etc. Ensure that the Windows > Control Panel > Ease of Access setting associated with keyboard shortcuts is enabled, to display keyboard shortcuts in RED. Refer to the relevant MS Windows documentation for details.
The menu options available for Fact Tables are a subset of the options for Data Store Tables. KPI Fact Tables have three additional menu options as mentioned below.
Menu Options | Description |
|---|---|
Display KPI's | Select this option to display all KPIs that have been set up for the KPI fact table in the Drop Target pane (middle pane). |
Add KPI's | Select this option to add a new KPI. |
Create Script To Test All KPI's | Select this option to generate an SQL script to test the KPI definitions for a specified time window. |