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

Get MDX with Microsoft SQL Server 2016 Analysis Services Cookbook - Third Edition now with the O’Reilly learning platform.

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