Referencing reporting dimension's members in MDX formulas

MDX formulas that were used in previous recipes referred to either existing cube measures or other dimension's members. There were no relations between report items themselves; each stood alone in the hierarchy. That is, until we introduced unary operators (in the previous recipe) and showed how to replace simple formulas with an operator.

Still, unary operators are very limited in what they support. As their name says, they are operators, not expressions. They can help us by not having to specify every formula in case the values can be rolled up from children. And that's it.

The other way to enhance the reporting dimension is to allow references to its members in MDX formulas. It makes perfect ...

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.