Defining Dependencies for Design-Time Prompts
You can define inclusive and exclusive dependencies for cross dimension, dimensions, dimension, member, members, and member range design-time prompts. If you designate a prompt (for example DTP1) as inclusive of another prompt (for example DTP2), when a user is prompted for DTP1, only the dimensions from DTP2 will display. If you designate a prompt (for example DTP3) as exclusive of another prompt (for example DTP4), when a user is prompted for DTP3, only the dimensions that are not used in DTP4 will display.
Note:
Design-time prompts can only be inclusive or exclusive of the design-time prompts that come before them in the design-time prompt grid, so the order of the design-time prompts is very important.
To define dependencies: