This Essbase discussion board is provided as a free service and dedicated to all the Essbase professionals out there!
 Return to Index  

ASO formula optimization help - How to use Non Empty

July 10 2012 at 12:37 PM
No score for this post
AlexS 
from IP address 209.85.224.104

Hello All,

I am new to ASO + MDX and am struggling with how to use Non Empty clauses/function to optimize calculation. We load data in MTD and need to convert it to history to date format (separate months and years dimensions like in planning). I created following formula for HTD and need help figuring out how to optimize this formula using NON EMPTY function:

IIF(
IsLeaf([Periods].CurrentMember),
Sum(
{
CrossJoin(MemberRange([Years].FirstChild,[Years].CurrentMember.PrevMember,LEVEL),[Periods].OpenBal.Level.Members),
CrossJoin({[Years].CurrentMember},MemberRange([Periods].OpenBal,[Periods].CurrentMember,LEVEL))
}
, [View].[MTD]),
MISSING
)

All help is appreciated. TIA

 
Scoring disabled. You must be logged in to score posts.Respond to this message   
Responses

  1. Re: ASO formula optimization help - How to use Non Empty - Gary Crisci on Jul 11, 2:26 PM
  2.  

RSS feed for this forum - http://www.network54.com/Forum/58296?xml=rss. Please email hypess (at) gmail.com, if you have any questions/feedback/issues.