Data Administration › Datamart Stoplights › Create Datamart Stoplights

Create Datamart Stoplights

To create a Datamart stoplight

1. Select Datamart Stoplights from the Data Administration menu.

   The Stoplights page appears.

2. Click New.

   The Stoplight Properties page appears.

3. Complete the following fields:

   Name

   Defines the name for the stoplight.

   Examples: Proj on Target, Proj Over Budget, or Resource Overbooked.

   Description

   Defines the description for the stoplight.

   Limits: 256 characters

   Red SQL Rule

   Defines the SQL formula that defines the red stoplight.

   Yellow SQL Rule

   Defines the SQL formula that defines the yellow stoplight.

   Note: There is no green SQL rule. A stoplight is green when both the red and yellow stoplights evaluate to false.

4. Click Submit.