O'Reilly logo

MDX with Microsoft SQL Server 2008 R2 Analysis Services: Cookbook by 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

Creating a physical measure as a placeholder for MDX assignments

There can be many problems regarding calculated members. First, they don't aggregate up like regular members; we have to handle that by ourselves. Next, the drillthrough statements and security restrictions are only allowed for regular members. Not to mention the limited support for them in various client tools, for example in Excel. Finally, regular measures often noticeably beat their calculated measures counterparts in terms of performance or the ability to work with subselect.

On the other hand, calculated members can be defined and/or deployed very easily. They don't require any drastic change of the cube or the dimensions and therefore are good for testing, debugging, as a ...

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