Accessing Cousins

The COUSIN function enables you to access a cousin, given a member at a higher level.

For example, the following query finds the cousin of Q1 1943, within the year 1990:

SELECT MEASURES.[%COUNT] ON 0, COUSIN(birthd.[Q1 1943],birthd.1990) ON1 FROM demomdx
 
                                    %COUNT
Q1 1990                                   5

To determine relative positions, the system uses the default order of the members within the level, as determined by the cube definition.

Accessing Descendant Members

Accessing Siblings