Hi,
I have a warehouse cube and I want to have different rollup for the Time
dimension. Is it possible?
If I have only two dimensions (product and time) I'd like to see sum of
product dimension and average of time. Would look like this (type one
products only):

Jan Fev Mar Apr Avg
Prod 1 10 10 10 10 10
Prod 2 10 10 10 10 10
Total 20 20 20 20 20

I am using Analisys Services 2000 with Sp3a and Excel as the front end.

I also would like to show a different rollup for a different level on
product dim. Like If I'm looking in the product level the rollup is sum,
however if I'm looking at the product type level I`d like to see Average. Is
it possible?


Jan Fev Mar Apr Avg
Prod Type 1 20 20 20 20 20
Prod Type 2 10 10 10 10 10
Avg 15 15 15 15 15


I think I'll need calculated members and custom rollup all at once. But I
have no idea on how to do it.

Thanks a lot for your help.

You want semiadditive behavior by Time - check out this whitepaper:
http://msdn.microsoft.com/library/de...l/semiadd2.asp

--
==================================================
Mosha Pasumansky - http://www.mosha.com/msolap
Analysis Services blog at http://www.sqljunkies.com/WebLog/mosha
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================

"Miguel Salles" <MiguelSalles (AT) discussions (DOT) microsoft.com> wrote