In a report - I need to rollup measures across two hierarchies. Further - each hierarchy contains a code and a description I need to put on the report. If I do a cross join between the two using:
SELECT NON EMPTY
[Request Code].[BK Request Code].[BK Request Code].ALLMEMBERS *
[Request Code].[Request Code Description].[Request Code Description].ALLMEMBERS *
[Derived Request Code].[BK Derived Request Code].ALLMEMBERS *
[Derived Request Code].[Derived Request Code Name].ALLMEMBERS
from yada yada yada....
I get 4 lines of result for each 1 line I want. The second code and description come out as
I am only interested in the last line - where both the code and the description are filled in. How can I do a "limited cross join" where I do not get the "all" results?