MDX Query Optimize
Summary
MDX Query OptimizeContent
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.
0