Hi,

I have an aggregation problem with my cube in Analysis Services 2005. I
created a parent-child-dimension with three levels containing questions on
the lowest level and two levels of categories above. The fact table contains
integers between 1 and 6 (answers from several respondents to the
questions). Additionally there is a calculated member for the average of all
answers to achieve meaningful results.

On the lowest level (level of single questions) the average of all answers
is calculated properly, but the subtotals (level of subcategories and
categories) are wrong. Problem: The single averages are simply added up
instead of calculating its average.

I know this should be avoided with custom rollups - but I didn't succeed
yet. I added a MDX attribute to the question table containing a specific MDX
expression in the case of a categories entry and NULL in the case of
question entry. After assigning the MDX attribute to the parent as a
"CustomRollupColumn", the average of the subcategory is calculated
correctly - but all averages of the single questions disappear! What's
wrong? :-)

Hope anybody can help, try to solve that for a long time now.... :-/ Thanks
in advance!

Nikolas