Defining a Hardcoded Combination of Members

In many cases, it is useful to define a coarser grouping that combines multiple members of the same level. To do so, create a non-measure calculated member that has a value_expression of the following form:

%OR({member_expression, member_expression,...})

For example:

%OR({colord.red,colord.blue,colord.yellow})

Each non-measure member refers to a set of records. When you create a member that uses the %OR function, you create a new member that refers to all the records that its component members use.

For example:

WITH MEMBER CalcD.[primary colors] as '%OR({colord.red,colord.blue,colord.yellow})' 
SELECT calcd.[primary colors] ON 0, 
{MEASURES.[%COUNT], MEASURES.[avg test score]} ON 1 FROM demomdx

Defining a Combination of Members Defined by a Term List

Defining Age Members