sum up 2 calculated member into a dimension member, SSAS 2008
I have a dimension member an ex; ABC, under ABC i created 2 calculated member say ABC1 and ABC2 using calculation tab in cube designer. using some mdx query, i got values for the 2 calculated members. But in the browser able to see ABC with no value, under ABC i have values for ABC1 and ABC2, problem is the 2 calculated member is not summing up value to upper level "ABC"![alt text] i would appreciate your help. Example Below: :
The calculated members are not additive. It means, that values of calculated members are not used in parent levels aggregations. You have to define calculations for all levels above the calculated member if you want to aggregate the calculated member value into it's parents aggregations. This is by design of SSAS.