how do we optimise the below script using NON EMPTY Member or TUPLE command ,
Summary
how do we optimise the below script using NON EMPTY Member or TUPLE command ,Content
how do we optimize the below script using NON EMPTY Member or TUPLE command , I am new to ASO MDX scripting and I am getting syntax issues
execute allocation process on database 'APP'.'DB' with
POV"CROSSJOIN( {Descendants([Destination],[Destination].Levels(0),Self)},CROSSJOIN( {Descendants([Model],[Models].Levels(0),Self)},CROSSJOIN( {Descendants([Period],[Period].Levels(0),Self)},CROSSJOIN( {Descendants([Year],[Year].Levels(0),Self)},{Descendants([Actual],Levels([Version],0))}))))"
amount "([Member1]*[Member2])"
target ""
range "({ [Member3]})"
spread;
Can anyone suggest where to place and also suggest if we can optimize the above script
0