Log in  ::  Register  ::  Not logged in

## Calculated member formula for All member is not SUM of children

 Author Message cliffb SSCrazy Group: General Forum Members Points: 2329 Visits: 438 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 codeMEMBER 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. cliffb SSCrazy Group: General Forum Members Points: 2329 Visits: 438 Nevermind, I found what I needed.For the Set argument, I used a case statement.SUM(CASE [Dimension].[Attribute].CURRENTMEMBERWHEN [Dimension].[Attribute].[All] THEN [Dimension].[Attribute].CURRENTMEMBER.CHILDRENELSE [Dimension].[Attribute].CURRENTMEMBEREND, ...) write2mmk14 Forum Newbie Group: General Forum Members Points: 5 Visits: 0 Thanks for posting the solution.It was a life saver! I had a similar problem and being an MDX newbie, was breaking my head to find the solution..