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

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

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