MDX: Rolling YTD

8 Jun 2006 7:21 AM

RS

Hi,

I have been searching for a solution in MDX to create rolling
Year-to-Date calculated members.

For example:
When the current member time is June 2006, I want the total sales YTD
of last year, that
means from January 2005 till June 2005.

Thanks for any hints for a solution

RS.

ps.
My starting point was:

sum({ytd()},[Measures].[Sales])

But this formula is the sum YTD for this year. I'm searching for a
formula for the sum YTD of last year.

I've tried every combination with sum, OpeningPeriod(), lag,
ParallelPeriod().

8 Jun 2006 8:08 AM

datagrep

RS wrote:
Show quote

> Hi,
>
> I have been searching for a solution in MDX to create rolling
> Year-to-Date calculated members.
>
>
> For example:
> When the current member time is June 2006, I want the total sales YTD
> of last year, that
> means from January 2005 till June 2005.
>
>
> Thanks for any hints for a solution
>
>
> RS.
>
>
> ps.
> My starting point was:
>
>
> sum({ytd()},[Measures].[Sales])
>
>
> But this formula is the sum YTD for this year. I'm searching for a
> formula for the sum YTD of last year.
>
>
> I've tried every combination with sum, OpeningPeriod(), lag,
> ParallelPeriod().

> I datagrep is offer the solution for most of the problems
> so visit this for ur solutions
>http://www.datagrep.com