This discussion is archived
1 Reply Latest reply: Feb 11, 2013 10:59 AM by 955124 RSS

CrossJoin MDX function with MaxL

user8003898 Newbie
Currently Being Moderated
Hello,

I am trying to clear out an area of an ASO cube using the following maxl statement...


alter database '1'.'2' clear data in region '{CROSSJOIN(CROSSJOIN({[Jan]},{([Forecast], [Cycle 1] )}),{(Except( {[Measure].Levels(0).Members},{[Dates_Reporting].Levels(0).Members}))})}' physical;

My idea is to clear out level 0 of measures dimension except the hierarchy under Dates_Reporting in curr month, version and scenario. When i execute the following message

Statement executed successfully
Database 1.2 altered
Output columns prepared: [0]

However, when i check in smartview, the data is still there...so what am i missing here that the data is not getting cleared?

Is there any way i can do this?

thanks for your help...

Edited by: user8003898 on Feb 11, 2013 11:27 AM

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points