This Essbase discussion board is provided as a free service and dedicated to all the Essbase professionals out there!
Respond to this messageReturn to Index
Original Message
  • ASO formula optimization help - How to use Non Empty
      • AlexS
      Posted Jul 10, 2012 12:37 PM

      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
    Login Status
  • You are not logged in
      • Login
      Password
       

      Optional
      Provides additional benefits such as notifications, signatures, and user authentication.

      Create Account
    Your Name
    Your Email
    (Optional)
    Message Title
    Message Text
    Options Also send responses to my email address
          



    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.