Module definitions (that result in Measure Groups) produces fact tables/views in in the data warehouse. Extra columns can be added here as:
|
Calculated Fact Dimension |
Expression with result as a dimension column |
|
Calculated Fact Measure |
Expression with result as a measure column |
Both these are based on an SQL expressions. It can be as simple as a value (e.g. ‘All’), or an expression based on SQL functions, operators and/or existing columns in same row (e.g. SalesGrossSalesAmt – SalesAmt).
Calculated Members
Calculated Members are members of a dimension or a measure group. These have an MDX source expression with a combination of cube data, arithmetic operators, numbers, and functions.
Profitbase Studio defines two types of calculated members:
|
Calculated Cube Measure |
Calculated Cube Measures are cube calculations and “WITH MEMBER” measures. They are often use other measures in the MDX expressions. |
|
Calculated Cube Dimension Member |
A Calculated Cube Dimension Member is a calculated dimension member in the cube resulting from a business logic expression (any MDX Expression). They can apply to a specific measure group or all. |
Named Set
A named set is a MDX expression that returns a set of dimension members. Named sets simplify MDX queries and provide useful aliases for complex, typically used, set expressions.
For example, use this to select top 10 customers, and the end user can use this in queries.
Script Command
This is generic MDX scripts that can apply to the whole cube, or to specific sections of the cube, at specific points within the execution of it. Use scope to limit it.
KPI
Key Performance Indicator or KPI is a measure object with calculations to evaluate business success. It has additional metadata that provides information about how client applications should display the results of the KPI's calculations. KPI’s are server-based (shared among clients).
It may use data from multiple measure groups to calculate its values, targets, goals, status and so on.
Properties:
|
Goal |
An MDX numeric expression or a calculation that returns the target value of the KPI. |
|
Value |
An MDX numeric expression that returns the actual value of the KPI. |
|
Status |
An MDX expression that represents the state of the KPI at a specified point in time. The status MDX expression should return a normalized value between -1 and 1. Values equal to or less than -1 will be interpreted as "bad" or "low." A value of zero (0) is interpreted as "acceptable" or "medium." Values equal to or greater than 1 will be interpreted as "good" or "high." An unlimited number of intermediate values can optionally be returned and can be used to display any number of additional states, if supported by the client application. |
|
Trend |
An MDX expression that evaluates the value of the KPI over time. The trend can be any time-based criterion that is useful in a specific business context. The trend MDX expression enables a business user to determine whether the KPI is improving over time or degrading over time. |
|
Status indicator |
A visual element that provides a quick indication of the status for a KPI. The display of the element is determined by the value of the MDX expression that evaluates status. |
|
Trend indicator |
A visual element that provides a quick indication of the trend for a KPI. The display of the element is determined by the value of the MDX expression that evaluates trend. |
|
Display folder |
The folder in which the KPI will appear when a user is browsing the cube. |
|
Parent KPI |
A reference to an existing KPI that uses the value of the child KPI as part of computation of the parent KPI. Sometimes, a single KPI will be a computation that consists of the values for other KPIs. This property facilitates the correct display of the child KPIs underneath the parent KPI in client applications. |
|
Current time member |
An MDX expression that returns the member that identifies the temporal context of the KPI. |
|
Weight |
An MDX numeric expression that assigns a relative importance to a KPI. If the KPI is assigned to a parent KPI, the weight is used to proportionally adjust the results of the child KPI value when calculating the value of the parent KPI. |
Measures and Calculated Columns are added through the column editor.
In addition you can add Key Performance Indicators or KPI's (see description of KPI above).
A Tabular KPI is based on a measure. This value from this base measure can be compared with a target value. The target value can be a static/fixed value or another measure. In addition you must select what kind of indicator to show in clients, its style and its thresholds.
An indicator can e.g. be a traffic light and you can use a style that has two thresholds for the split between red/yellow and yellow/green. You can also use style with green in center and red on edges witch requires 4 threshold values (red/yellow, yellow/green, green/yellow, yellow/red).
Threshold values are entered as % if target is a measure. For a static target, values are used.
These indicators, and their styles, is displayed in clients that supports these KPI styles.