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 the MDX dictionary

MDX expressions become complex easily. The syntax requires precise references to cube objects. Unique member names are long and tend to make expressions hard to follow. Members can appear in multiple hierarchies. All in all, it's a jungle for those not experienced with SSAS.

Additionally, MDX expressions can sometimes return a wrong value if the context is not established properly. It's easy to know something went wrong when they throw an error or return nulls, like in previous examples in this chapter. That's because the reporting dimension was not related to any measure group. But, when we reference a dimension, there is a small chance we are missing something related to forcing the proper context. It's normal. ...

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