Script Facts for Stop Lighting

Products

EUREKA:Strategy

Issue/Introduction

Script Facts for Stop Lighting

Environment

Release:
Component: STGY

Resolution

Executive Summary

Script facts allow an end user additional functionality beyond standard Eureka Strategy calculations. The following example illustrates how script facts can prepare a report for 'Stop Lighting'. Stop lighting is used to highlight data rows that are exceptionally high or low compared to standard numbers. There is only one additional fact table needed to accommodate this type of special reporting. Follow the example below to see how this is done.

Standard Fact Table

PerKey	CustKey	ProdKey	MktKey	SalesDols	Number of Prods
1/1/98	Company A	Widget AA	Eastern	10	100
1/2/98	Company A	Widget BB	Eastern	70	700
1/4/98	Company B	Widget DD	Southern	120	1200
2/3/98	Company C	Widget AA	Eastern	10	300
2/8/98	Company D	Widget EE	Southern	20	200
2/8/98	Company C	Widget DD	Central	10	100

Threshold Fact Table - defined by Business Users

MktKey	SalesDols Low	SalesDols High
Central	50	75
Eastern	50	100
Southern	50	120

Illustration A: Required Fact Tables

Facts
Facts need to be created to accommodate the following values:

Fact Names	Definition
SalesDols	Volumetric from Standard Fact Table
SalesDols Low	Volumetric from Threshold Fact Table
SalesDols High	Volumetric from Threshold Fact Table
ScriptFact	See below for script definition

Illustration B: Required Facts

<Please see attached file for image>

Illustration C: Creating the Script Fact

The variables defined with in the script fact are:

Variable	Fact	Definition
actual	SalesDols	Volumetric from Standard Fact Table
low	SalesDols Low	Volumetric from Threshold Fact Table
high	SalesDols High	Volumetric from Threshold Fact Table

Create a report with the following definitions from the facts defined above:

Report
FACT DEFINITIONS

SalesDols
SalesDols Low
SalesDols High
ScriptFact

FILTER DEFINITIONS
Period in section: 2 Months Total at Day Level Filter
Market in rows: All Markets Items and Totals
Product and Customer are not on the layout.
Facts in columns: SalesDols, SalesDols Low, SalesDols High, ScriptFact

2 Months Total
	SalesDols	SalesDols Low	SalesDols High	ScriptFact
Central	10	50	75	1
Eastern	90	50	100	3
Southern	140	50	120	2
Market Total	240	150	295	6

Illustration D: Sample of report with Script Fact displayed

Notice where the values lie in relation to the Low and High SalesDols. To make this a stop light report now, simply apply an exception to the report.

Based on the script fact values set the color accordingly. In the following example cell A equals the ScriptFact advanced calculation. In addition, you do not need to return a numerical value. You could return the word 'Low' or 'High' to indicate the threshold of SalesDols.

<Please see attached file for image>

Illustration E: Creating the exception through Application Workbench

Final Report
The final report would look something like the following:

2 Months Total
	SalesDols	SalesDols Low	SalesDols High	ScriptFact
Central	10	50	75	1
Eastern	90	50	100	3
Southern	140	50	120	2
Market Total	240	150	295	6

Or if you utilized character strings...

2 Months Total
	SalesDols	SalesDols Low	SalesDols High	ScriptFact
Central	10	50	75	Low
Eastern	90	50	100	Moderate
Southern	140	50	120	High
Market Total	240	150	295	NA

Illustration F: Sample of report with Script Fact displayed

Available Documentation
Additional information on script facts can be found in the following DecisionSuite documentation:

Manual	Page
Workbench Users Guide Addendum	251 and 252
Workbench On Line Help