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 custom rollups using MDX formulas

The reporting dimension created in the previous recipe is not connected to any measure group. That means it can't be used to display meaningful data. Yet.

Welcome custom rollups using MDX formulas!

Custom rollups are a way to tell dimension members what data to show. They are in fact MDX expressions that return a value. That value is displayed as the value of a member in the dimension. Each member can have its own expression, its own custom rollup. This expression, stored in a column in the relational table or a view, can be specified as the value of a certain property of any parent-child dimension. However, that only works when the dimension has a relationship with a fact table, with a measure group. ...

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