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
SSAS.png (12.6 kB)
more ▼

asked Jun 15, 2012 at 06:13 PM in Default

Sairampremkumar gravatar image

10 1 1 1

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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.
more ▼

answered Jun 18, 2012 at 04:59 AM

Pavel Pawlowski gravatar image

Pavel Pawlowski
22.3k 9 11 21

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Jun 15, 2012 at 06:13 PM

Seen: 2010 times

Last Updated: Jun 19, 2012 at 05:34 AM