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 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).