One of the advantages of using OLAP is the ability to use an intuitive reporting framework. This framework lets you quickly translate large data volumes with the goal of making informed business decisions. Analysis Services leverages this capability through Key Performance Indicators (KPIs). KPIs are defined as quantifiable measures that represent a critical success factor in an organization. The emphasis is on the action of quantifying something in the environment. For example, the KPIs must be measurable to successfully be monitored and compared against a given objective.
In IT Analytics Solution, KPIs are created from existing measures. However, not all measures are good candidates for KPI utilization. A measure should be leveraged in a KPI only if it represents a critical success factor to gauge performance. Besides being measurable and performance-oriented, KPIs should be used to track progress against the strategic and typically long-term goals that remain fairly static in nature.
KPIs consist of four critical elements, and IT Analytics Solution offers the flexibility to define each of the following expressions:
A Value Expression is an MDX expression that represents the primary measurement for this KPI. For example, Computer Count.
A Goal Expression is an MDX expression that represents the desired target for the measure that is used for the Value Expression.
A Status Expression is typically used to compare the Value Expression with the Goal Expression. However, it can be any MDX expression that is meaningful for this KPI. This expression is typically a number between 1 (goal has been met) and -1 (goal has not been met).
A Trend Expression is typically used to represent the current trending over time of the Value Expression as compared with the Goal Expression. However, it can be any MDX expression that is meaningful for this KPI. This expression is typically a number between 1 (increasing or getting better) and -1 (decreasing or getting worse).
The default KPIs included with the IT Analytics Solution are samples and should be reviewed and tailored to each unique environment.
For more information on KPIs in SQL Server Analysis Services, see the Microsoft TechNet Web site at the following URL: