Adding KPIs to our cube
KPIs are used by businesses to evaluate performance over time. KPIs in multidimensional models in SSAS are server-based and can be used by various end user tools such as Excel. The advantage here is that a business KPI can be created and shared easily within an organization.
Understanding the basics of a KPI
A typical KPI is built on the following components:
- Goal or target
- Value or actual
- Status of the value compared to the goal
- Trend of the value to meeting the goal
These values can use indicators that typically work from a -1 to 1 value system. Here, -1 is measured as not meeting the goal, and 1 as meeting the goal. All these values are built with MDX, which is what we will dig into now.
Building your KPI
First, you need to open the KPI tab in the Cube Design window in your Visual Studio project. Once you have that open, create a new KPI by right-clicking in the KPI Organizer pane or selecting the New KPI option from...