question

Sairampremkumar avatar image
Sairampremkumar asked

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][1] i would appreciate your help. Example Below: [1]: http://ask.sqlservercentral.com/storage/temp/229-SSAS.png
ssasmdxcalculations
SSAS.png (12.3 KiB)
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Pavel Pawlowski avatar image
Pavel Pawlowski answered
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.
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.