O'Reilly logo

MDX with Microsoft SQL Server 2016 Analysis Services Cookbook - Third Edition by Sherry Li, Tomislav Piasevoli

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required