Book Image

Expert Cube Development with SSAS Multidimensional Models

Book Image

Expert Cube Development with SSAS Multidimensional Models

Overview of this book

Table of Contents (19 chapters)
Expert Cube Development with SSAS Multidimensional Models
Credits
About the Authors
About the Reviewers
www.PacktPub.com
Preface
Index

Different kinds of calculated members


There are three kinds of calculated members:

  • Query-scoped calculated members: These are calculated members defined in the WITH clause of an MDX query. They are specific to the query and cannot be referenced outside it. They are very useful to developers for testing, debugging, and ad hoc reporting, but as defining a calculated member requires knowledge of MDX, it is not something a normal end user will be able to do.

  • Session-scoped calculated members: These are calculated members that exist in the context of the session created when a user connects to a cube. These calculated members are available for use in all queries executed in a particular session until either the session is closed or the calculated members are dropped. Session calculations are a convenient means for a client tool to simplify the queries it generates, but apart from that, they are rarely used. They are created by the client tool executing a CREATE MEMBER statement.

  • Globally-scoped...