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: Value, Goal, Status, and Trend.
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 ...
Get MDX with Microsoft SQL Server 2016 Analysis Services Cookbook - Third Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
