Note: This is an old article. However, the troubleshooting tips may still apply to newer versions.
There is a limitation in SSAS that causes unintended behavior, when multiple parent-child dimensions are added to the same cube in the following scenario:
- More than one parent-child dimension is related to the same fact table.
- The parent-child dimensions uses custom rollup and/or unary operators The custom rollup- and unary operator definitions from one dimension will also affect others.
The attached document describes how to solve this problem using scopes.