In Analysis Manager Ive a cube with the following time dimension

DayView --> Year
--> Week
--> Day

Ive one measure called Hours

What I need to do is to add a calculated measure which will give me the
MONTH to date figures.

Does anyone know how I can add a monthly running total to my cube.

I need to have something like this :-

2003
Week 19 Week 20
May 1 May 2 May 3 May 4 May 5 May 6

Hours 5 6 5 3 4 2
Month2Date 5 11 16 19 23 25


Does anyone have any Ideas ?

Thanks,
John.

Check out the MTD and PeriodsToDate MDX functions in Books Online.

- Matt Carroll
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"John" <jcarter@impaq.co.uk> wrote in message
news:24122ddd.0308040356.222a460d@posting.google.c om...
> In Analysis Manager Ive a cube with the following time dimension
>
> DayView --> Year
> --> Week
> --> Day
>
> Ive one measure called Hours
>
> What I need to do is to add a calculated measure which will give me the
> MONTH to date figures.
>
> Does anyone know how I can add a monthly running total to my cube.
>
> I need to have something like this :-
>
> 2003
> Week 19 Week 20
> May 1 May 2 May 3 May 4 May 5 May 6
>
> Hours 5 6 5 3 4 2
> Month2Date 5 11 16 19 23 25
>
>
> Does anyone have any Ideas ?
>
> Thanks,
> John.

Ive looked at both of these functions however they seem to require a month to
be part of my time dimension for them to generate the required results.

Ive tried adding a second time dimension which has a month element
however this only works when the second time dimension is in use.

Its a requirement that the year - week - day dimension is used.

Thanks,
John

According to BOL:
PeriodsToDate(level, member) is the same as
TopCount(Descendants(Ancestor(member, level), member.Level), 1):member

You could create a month member property on the day level, take the above
MDX and add to it a filter to just include members with the same month. It
will take some fiddling with and may not be super fast, but it should be
doable.

- Matt Carroll
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"John" <jcarter@impaq.co.uk> wrote in message
news:24122ddd.0308050047.8c82ed4@posting.google.co m...
> Ive looked at both of these functions however they seem to require a month
to
> be part of my time dimension for them to generate the required results.
>
> Ive tried adding a second time dimension which has a month element
> however this only works when the second time dimension is in use.
>
> Its a requirement that the year - week - day dimension is used.
>
> Thanks,
> John