Hyperion Essbase (MOSC)

MOSC Banner

How to make this Clear a Select and run in MDX editor so I can see what is cleared?

in Hyperion Essbase (MOSC) 6 commentsAnswered ✓

Hello,

We have a process that uses a calc script to export data to a file from cube A, a maxl that clears data from cube B, then another maxl that loads the file from cube A to cube B.

The calc script has a fix that includes this selection of account members:

@REMOVE(@LIST(@RELATIVE("Accommodation",0),@RELATIVE("Unit_of_Measures",0)),@LIST(@UDA(Account,"DYNAMICMBR"))), /*Account*/

The maxl has an MDX? that clears data from these account members:

CrossJoin(EXCEPT({Descendants([Accommodation],15,LEAVES)},{UDA([Accommodation], "DYNAMICMBR"),Descendants([Unit_of_Measures],2,LEAVES),[NoOfRooms_Closing_Reportable].nextmember,[NoOfRoomNights_Closing_Reportable].nextmember})

Below is the entire maxl command:

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