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

MDX Query Optimize

Received Response
7
Views
4
Comments
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!