Calculated Members

Calculated Members

Members can be defined within the cube definition, as part of the definition of a level. You can also create calculated members, which are typically based on other members. You can define calculated members in two ways:

• Within the WITH clause of a query. The member is available within the rest of the query, but is not available in other queries.

• Within the CREATE MEMBER statement. The member is available within the rest of the session (for example, within the rest of the session in the MDX shell).