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
Skip to content
  • Register

    • MDX Query Optimize

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

    Summary

    MDX Query Optimize

    Content

    Hello,

    I am using below member formula on Account Member CC_Count to calculate total cost centers for their sales >0. if it is, then results should be count-1 or else just count.

    it's working fine as expected. But it's running for a long time even for small results. Could you help me how to optimize this MDX query

    IIF( NonEmptyCount(Filter(CostCenter.Levels(0).Members, [Sales] > 0)) >0,

      NonEmptyCount(Filter(CostCenter.Levels(0).Members, [Sales] > 0))-1,

      NonEmptyCount(Filter(CostCenter.Levels(0).Members, [Sales] > 0)) )

    Any Help would be on this appreciated.  please let me know If my Question is not clear.

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

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