Very Computer

by **Christian Hame** » Wed, 01 May 2002 07:42:53

Hello.
I would like to have a different aggregation for my measure based on the
level the user is. I mean, by default, the user is at the year level and I
want him to see the sum for the sales:
2001 1,000,000$
2002 2,000,000$
But when my user drill down to the week level, I would like him to see
an average. Is it possible ? I would also like to display this kind of
measure in DataAnalyzer. Hopefully it's possible. Thanks for any help.

Here's my cube definition :

Dimensions:
[Date]
[Year]
[Week]

[Products]
[Product Type]
[SKU]

Measure:
[Sales $]

by **Ashish Pande** » Wed, 01 May 2002 16:36:48

Look at custom rollup formulas... that should address your
problem. For simpler aggregations ( +, -, /, *, ~) unary
operators will do.

Quote:>-----Original Message-----
>Hello.
> I would like to have a different aggregation for my

measure based on the

Quote:>level the user is. I mean, by default, the user is at

the year level and I

Quote:>want him to see the sum for the sales:
> 2001 1,000,000$
> 2002 2,000,000$
> But when my user drill down to the week level, I

would like him to see

Quote:>an average. Is it possible ? I would also like to

display this kind of

Quote:>measure in DataAnalyzer. Hopefully it's possible.

Thanks for any help.

Quote:
>Here's my cube definition :

>Dimensions:
> [Date]
> [Year]
> [Week]

> [Products]
> [Product Type]
> [SKU]

> Measure:
> [Sales $]

>.

Very Computer

Different Aggregation for my measure based on the level?

Different Aggregation for my measure based on the level?

Different Aggregation for my measure based on the level?