I recently asked a question about shell dimensions
here. I have got this working nicely using my user account dimension. The problem I have is the size of this dimension. The cube I developed this with has a dimension with just under 1 million members. I would now like to apply this
to other cubes but I am not looking at a dimension of over 18 million members with all the problems of processing and query performance.
So, I was looking at splitting up the dimension using this concept : Breaking up Large Dims
I created the 3 keys, and the small dimensions and linked everything up. So far so good.
But I am not stuck on how to write the mdx to get the data in the shell dimension. With the single dim I used: