Hi all,

I'm new to OLAP and I need some help with AVG and COUNT functions, I
spent four days without success, and I think it may take four minutes
from you.

I have a fact table (FactTable) which has a measure
([Measures].[MinutesElapsed]).
Also I have a Time dimension (Year, Quarter, Month, and Week)

How can I count Fact records for each week?
How can I calculate the average of [Measures].[MinutesElapsed] for each
week?

Any comments will be very helpful.

Best regards,

Atef

You should create a cube "count" measure, like [FactCount].
Then, if you're using AS 2000, the average weekly record count could be
like:

Avg(Descendants([Time].CurrentMember, [Time].[Week]),
[Measures].[FactCount])


Likewise, the average weekly [MinutesElapsed] would be:

Avg(Descendants([Time].CurrentMember, [Time].[Week]),
[Measures].[MinutesElapsed])


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***