Hello everyone,

I am working on a proof of concept to move some heavy analytical calculations into SSAS. Everything was working fine until I hit a particularly complex calculation. What appears to be occuring is the children are SUMMED correctly, but the All member is not.

Psuedo code

MEMBER Measures.x AS

SUM(

[Dimension].[Attribute]

,

CASE

WHEN [Measures].[Cost] > 0 AND ([Measures].[Measure1]*[Measures].[Measure2]*[Measures].[Measure3])/[Measures].[Cost] > 5 THEN

[Measures].[Cost]/([Measures].Measure1*[Measures].[Measure3])

ELSE [Measures].[Measure2]

END)

I understand why it is happening, It's taking the values of the All member for the measures vs summing the result of the children. The question is how do I get the sum of the CHILDREN for All vs the calculation of the values of the All member?

FYI, I have tried adding a Calculation in the cube and processed it, but I got the exact same result.

Any help is appreciated.