I have a cube with the time dimensions:

year.month.day
and
meter

and the measure:
discharge

I need to know average for all years for the periods June 1-june 6
I mean if we had 20 years we would select 20 sets june 1- june 6 and then
average them

How can I do this?

Make new virtual dimension "month-day"

with
set AllYears as '{[year-month-day].[years].memebers}'
member [measures].[YourAverage] as
'sum({[month-day].[06/02]:[month-day].[06/06]}, [measures].[discharge]) /
count(AllYears, EXCLUDEEMPTY)'

select
[measures].[YourAverage] on columns,
[meter].members on rows
from YourCube


"Pavel" <paul_unix (AT) shaw (DOT) ca> schrieb im Newsbeitrag
news:43749bc0.0406071404.6e6e1a5e (AT) posting (DOT) google.com...