Sometimes, getting back to basics gets the job done

Thank yo very much, problem solved

Michael


"OLAPMonkey" <jjanke@spss.com> escribió en el mensaje
news:1112202692.231562.128020@g14g2000cwa.googlegr oups.com...
> Averages are usually handled by summing and counting...and then
> dividing the sub by the count in a calculated member.
>
> MPS wrote:
>> Hi, I will rewrite my question.
>>
>> I'm having trouble to show averages of a measure in a cube, where the
> normal
>> aggregation function for a measure is SUM.
>>
>> I see no AVG aggregation function for measures (I see Min, Max,
> Count,
>> Distinct Count and SUM).
>>
>> If I hide the measure (cost), and create a calculated member based on
> that
>> measure, ie Avg(cost), I have te problem of how to average it, since
> the
>> cube has two dimensions in the row axis, like:
>>
>> Time
>> ---------------------------------------
>> Product |
>> Customer | avg of cost
>>
>> If I use avg(nonemptycrossjoin(product.currentmember.childr en,
>> customer.currentmember.children), measures.cost) I get the same
> average for
>> every cell in the cube, what's not corrrect...
>>
>> Sorry to bother you all, but this thing is becoming a nightmare.
>>
>> Hope you can help
>>
>> Michael Prendergast
>
>