I´m having a problem with custom rollups for a Survey´s cube.

I have the following structure on the subject matter db:

Survey_Code SK_Question Answer_Value Q_surveys
01042-26-05-2004 4 9 61
01042-26-05-2004 4 6 61
01075-02-07-2004 4 5 32
01075-02-07-2004 4 7 32

So, Q_Surveys (quantity of people who answered the survey) repeats on each
question of each survey.

I need to make a measure or calculated member to represent the Q_Surveys for
more than one survey or question.

By now, we where making a MAX, but aggregations need to show the sum. We did
that for the dimension with a custom rollup formula at the "dimension level":

Survey (dimension)
( all member formula:
SUM({[Codigo Encuesta].[Codigo Encuesta].Members},
[Measures].[C_Encuestados x Preg]
)

º Survey Year
ºº Survey Month
ººº Survey Code

There we have the total for all surveys fine but not by month or by year. If
i use that code for the custom rollups of the other levels I get the sum of
max(q_surveys) (which is the same as the dimension total).

Any help is highly appreciated, sorry about my english.

Thanks in advance,

Julieta

Can you create a separate cube for the Q_Surveys measure, with only a
single fact record per question/survey combination? This cube can be
combined with the other in a virtual cube, and no custom rollup should
then be needed.


- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!