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.
Tomislav Piasevoli is a Business Intelligence Specialist with years of experience with SQL Server Analysis Services. He successfully implemented many still-in-use BI solutions and now specializes in dimensional modeling, cube design and MDX consulting worldwide. Tomislav has been honored with Microsoft's MVP award three times for his contribution to the SSAS community. Besides solving MDX, cube design and dimensional modeling puzzles, he occasionally presents at conferences, writes articles for magazines and maintains his blog at http://tomislav.piasevoli.com
. His recent experience includes writing a book named "MDX with SQL Server 2008 R2 Analysis Services Cookbook
“ published by Packt Publishing Ltd.