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

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.