Hyperion Essbase (MOSC)

MOSC Banner

MDX Crossjoin with Except

edited Feb 23, 2018 4:26PM in Hyperion Essbase (MOSC) 8 commentsAnswered ✓

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),

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center