Constructing Calculated Members

Throughout the chapters of this book, you have been assembling calculated members in the WITH clause of your SELECT statements. These calculated members are only accessible to the queries with which they are defined. As such, they are referred to as query-scoped calculated members.

Cube-scoped calculated members, on the other hand, are accessible to all users with access to a cube. These are defined within a cube’s MDX script through CREATE MEMBER statements. Cube-scoped calculated members have access to a bit more functionality to provide greater consistency than their query-scoped counterparts. They are also essential when analytic applications do not support the ad hoc definition of calculated members.


In addition ...

Get Microsoft® SQL Server® 2008 MDX Step by Step now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.