SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 06:23 PM
| ||||
| ||||
 Help with measure aggregation functions 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      |
|
02-27-2008, 06:23 PM
| |||
| |||
| Re: Help with measure aggregation functions 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 |
|
02-27-2008, 06:23 PM
| ||||
| ||||
| Re: Help with measure aggregation functions 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 > > |
Linear Mode
