How to make this Clear a Select and run in MDX editor so I can see what is cleared?
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: