Aggregates problem
From: JulietaI (JulietaI_at_discussions.microsoft.com)
Date: 10/08/04
- Next message: Jamie Thomson: "Re: Can a query return a list of all measures?"
- Previous message: Jim L: "Re: Can a query return a list of all measures?"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 8 Oct 2004 14:05:07 -0700
Hi!, 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).
An help is highly appreciated, sorry about my english.
Thanks in advance,
Julieta
- Next message: Jamie Thomson: "Re: Can a query return a list of all measures?"
- Previous message: Jim L: "Re: Can a query return a list of all measures?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
