Platinum Sponsor

Universal calculated measures in MDX queries

Among many of its functions, MDX language has one special set function - Axis() function. That function allows creation of calculated measures that are fully context aware and, if wanted, don't need to refer to any dimension or hierarchy in the cube. In other words, such measures are universal or independant, which means they can be used in any MDX query.

In this session we will present such measures and explain how they work. We'll also show the way how to design them for various scenarios and discuss their potentials and weaknesses.

Previous experience in writing MDX queries is recommended.

Presented by Tomislav Piasevoli at SQLBits IV