My users want a cube that has average ratings. The cube I've developed has
sums of the individual ratings. I tried inserting a calculated measure, but
I could not get the AVG function to parse properly.

Eventually, these cubes will be displayed in pivot tables in Excel.
Apparently, when using an OLAP cube in Excel, one cannot add calculated
fields.

How can I include the average ratings in my cube.

TIA,

Mike

In your fact table, create a column that returns a 1 or 0 (call
ReviewCount) depending if it should be counted in the denominator. Now
you have the ratings as the numerator and ReviewCount as the
denominator. Create a calculated member as Ratings/ReviewCount. Excel
will see this a just another measure.

Hi,

This appears to work most of the time. However, I have a cube that shows
several averages of ~ 15, even though the highest possible rating is 7. This
either is clearly a bug or there is a problem with my calculation. Here is
the calculation:

[Measures].[Rating]/[Measures].[Count Column]

[Count Column] always equals 1.

TIA,

Mike

"Gary Gibbs" wrote: