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 drill through statements and security restrictions are only allowed for regular members. Not to mention the limited support for them in various client tools, such as Excel. Finally, regular measures often noticeably beat their calculate measures counterparts in terms of performance or the ability to work with the 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 temporary ...

Get MDX with Microsoft SQL Server 2016 Analysis Services Cookbook - Third Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.