My time dimension has levels going through from year down to hour
(Y,Q,M,D,H). At day level I have a property which specifies the days full
name as apos it's position in the month. Let's say I have a measure called
[Calls Received].

What would be the best approach to calculating the average number of calls
received per hour, for each hour (0-23), over the last quarter on a Sunday?

I'm sure this type of problem has been faced before, but I can't find any
reference to a similar scenario as a starting point.

Any pointers/advice would be greatly appreciated.

Joe

I've typically set up separate Date and TimeOfDay dimensions. Even with
your hierarchical time dimension, you should be able to set up DayOfWeek
and HourOfDay virtual dimensions, based on corresponding member
properties (at the Day and Hour levels). Such dimensions would enable
you to select just Sunday, and report averages by hour.


- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!