MDX Crossjoin with Except
Hello,
I am working with MDX for the first time, and struggling with a crossjoin that uses an Except clause. There are a number of nested crossjoins, but I think this first one that specifies account dimension is the problem. I gave each line a letter.
CrossJoin(EXCEPT(
A {Descendants([Accommodation],15,LEAVES)},
B {UDA([Accommodation], "DYNAMICMBR"),
C Descendants([Unit_of_Measures],2,LEAVES),
D [NoOfRooms_Closing_Reportable].nextmember,
E [NoOfRoomNights_Closing_Reportable].nextmember}
)
Is this doing A - B - C - D - E?
CrossJoin(EXCEPT(
A {Descendants([Accommodation],15,LEAVES)},
B {UDA([Accommodation], "DYNAMICMBR")},
C Descendants([Unit_of_Measures],2,LEAVES),