x

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

Sairampremkumar
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.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x174
x69
x25

asked: Jun 15, 2012 at 06:13 PM

Seen: 2133 times

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