Different kinds of calculated members

There are three kinds of calculated member:

• Query-scoped calculated members 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 are calculated members that exist in the context of the session that is 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...