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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.