Average custom rollup on measure

#1

Hi,
i'm very new in MDX so please I need help on the following issue:
I have a cube with 4 dimensions and 1 measure PRICE. By default the PRICE is sumarized when rolling up, BUT I need an average to show?
Could you help me with the MDX syntax and where to put it?

Thnx in advnce,
Hrvoje

#2

Hi Juraj,

thnx for reply. Yes, I'm trying to use AVG on time dimension.
That could be it.

Thnx again!
Cheers

"Juraj" wrote:

Quote:

Hi Armando,

Try

AVG( DESCENDANTS(<Dim>.CurrentMember, <Dim>.<Leaf Level>),
Measures.[price])

It is not clear on which dimension the average is based; is it average per
time, organization unit, product? There are couple of examples on the web how
to use avg() function.

Regards

Juraj

"Armando" wrote:

Hi,
i'm very new in MDX so please I need help on the following issue:
I have a cube with 4 dimensions and 1 measure PRICE. By default the PRICE is sumarized when rolling up, BUT I need an average to show?
Could you help me with the MDX syntax and where to put it?

Thnx in advnce,
Hrvoje

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Average custom rollup on measure

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

Average custom rollup on measure - 06-15-2004 , 04:31 AM

RE: Average custom rollup on measure - 08-24-2004 , 03:05 AM