You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

how do we optimise the below script using NON EMPTY Member or TUPLE command ,

edited Aug 2, 2018 2:36AM in Essbase 2 comments

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!