Hello,

I created a sales cubes containing actual and budget figures. I need a new
year '2006 ACT_BUDG' which contains the actual figures up to today and the
budget figures where no actual figure exists yet.
Therefore I created in the Analysis Server Cube Editor the calculated member
2006 ACT_BUDG for the year dimension. The formula of the calc member is:

iif(([Date].&[2006])=0, [Date].&[2006 BUDGET], [Date].&[2006])

The new member works fine on the date,month, and quarter level. I do not
understand why the aggregation on the year level as well as the all member
level does not work correctly. It seems, that the aggregation only works for
cells where both year member '2006' and '2006 BUDGET' exist. Budget figures
will not be aggregated.

Can anybody help me to solve the problem? Thanks a lot in advance.


Sales Quarter
Qu1 Qu2
Month
Year Jan Feb Mär Subtotal Qu1 Apr Mai
Subtotal Qu1 Total
2006 3 5 2 10
0 10
2006 BUDGET 5 4 5 14 5
3 8 22
2006 ACT_BUDG 3 5 2 10 5 3
8 10 (!!!) instead of 10+8=18