Implementing metadata-driven KPIs
Metadata-driven calculations can be used for KPIs too. In SSAS, KPIs are like measures, except that each consists of four basic calculations:
A common way to implement them is to define the name for a KPI and then those four calculations. If we go that way, we can have funny icons for Trend and Status calculations: traffic light, arrows, symbols, and so on.The other advantage of implementing KPIs using the built-in functionality of the cube is that we can combine them in a parent-child structure, which is a nice feature.
Of course, there is always the option to use normal calculated measures, four of them. In our case, that means to define three additional measures (since we already ...