Objects for Business Reporting Workshop
|
Name |
Formula |
Dimensionality |
Conditionality |
|
Customer Count |
COUNT(Customer) |
||
|
Discount |
SUM(Discount) |
||
|
Distribution Center Count |
COUNT(Distribution Center) |
||
|
Dollar EOH |
SUM(Dollar EOH) |
Quarter Grouping (Ending EOH) |
|
|
Dollar Sales |
SUM(Dollar Sales) |
||
|
Freight |
SUM(Freight) |
||
|
Rush Charge |
SUM(Rush Cahrge) |
||
|
Unit Cost |
SUM(Unit Cost) |
||
|
Unit Price |
SUM(Unit Price) |
||
|
Units Received |
SUM(Units Received) |
|
Name |
Object |
Object Name |
Operator |
Value |
|
Year 1997 |
Attribute |
Year |
In List |
1997 |
|
Year 1998 |
Attribute |
Year |
In List |
1998 |
|
Empty Filter |
None |
None |
None |
None |
|
On Promotion |
Attribute |
Promotion |
In List |
All promotions |
|
Not on Promotion |
Attribute |
Promotion |
Not in List |
All promotions |
|
Top 5 Customers by Dollar Sales |
Metric |
Dollar Sales |
Function = Rank Operator = Top Level = Customer |
5 |
|
Top 5 Employees by Dollar Sales |
Metric |
Dollar Sales |
Function = Rank Operator = Top Level = Employee |
5 |
|
Top 5 Products by Dollar Sales |
Metric |
Dollar Sales |
Function = Rank Operator = Top Level = Item |
5 |
|
USA |
Attribute |
Country |
In List |
USA |
|
England |
Attribute |
Country |
In List |
England |