If you want to create a calculated member that intersects all measures, where do you put it and why?
• A member, based on other members can be created in MDX, . You can define two kinds of calculated members: ones that are measures and ones that are not.
• A calculated measure is based on other measures. For example, one measure might be defined as a second measure divided by a third measure.
• The phrase calculated measure is not a standard MDX phrase. Non-measure members are typically aggregated together by other non-measure calculated member.
• Like other non-measure members, this calculated member is a group of records in the fact table.
• For example, member A refers to 300 records in the fact table and member B refers to 150 records in the fact table. Suppose that you create a member C that aggregates A and B together. Then member C refers to the relevant 450 records in the fact table.
• To create one or more calculated members within a query, use syntax as follows:
WITH with_clause1 with_clause2 ... SELECT query_details
Note: That do not include commas between the clauses.
- Each expression with_clause1, with_clause2, and so on has the following syntax:
MEMBER MEASURES.[new_measure_name] AS 'value_expression'
- query_details is your MDX query.