Here are guidelines to keep in mind when working with members in Advanced Relational Access:
The first member of the accounts dimension must be a base or stored measure. It cannot be a user-defined member.
Relational members are not automatically expanded when part of an outline is expanded. To view the relational members, you must manually click the member node containing the relational members.
Relational members are not automatically collapsed when part of an outline is collapsed. To collapse the relational members, you must manually click the member node containing the relational members.
In Integration Services Console, you can specify multiple sort order columns for each generation, selecting ascending or descending order.
In Integration Services Console, you can associate a key column with each generation name and tag the key column as unique.