Hello Everyone,

I'm currently working with YTD calculation and i got some logic problem
....

with member [Measures].[Unit Sales YTD] AS
'SUM(YTD([Time].CurrentMember),[Measures].[Unit Sales])'
member [Measures].[Store Sales YTD] AS
'SUM(YTD([Time].CurrentMember),[Measures].[Store Sales])'

SELECT crossjoin({[Time].[1998],[Time].[1997]},{[Measures].[Unit Sales YTD],
[Measures].[Store Sales YTD]}) on columns, non empty
[Customers].[Country].members on rows from [Sales]

But in the case I only have Jav-Feb-March of data in 1998.. I would like to
have the same period for the 1997 YTD

with member [Measures].[Unit Sales YTD] AS
'SUM(YTD([Time].CurrentMember),[Measures].[Unit Sales])'
member [Measures].[Store Sales YTD] AS
'SUM(YTD([Time].CurrentMember),[Measures].[Store Sales])'
member [Time].[Last Year] AS 'ParallelPeriod([Time].[Year],1,
[Time].[1998])'

SELECT crossjoin({[Time].[1998],[Time].[Last Year] },{[Measures].[Unit Sales
YTD], [Measures].[Store Sales YTD]}) on columns, non empty
[Customers].[Country].members on rows from [Sales]

Why Time.Last Year return nothing. IF i replace it by
ParallelPeriod([Time].[Year],1, [Time].[1998]) i got data ...

Thanks

Best Regards,

Patrice

Hi Patrice

Not sure exactly what you want here, but it looks like a solve order issue to me. Does the following do what you want

with
member [Measures].[Unit Sales YTD] A
'SUM(YTD([Time].CurrentMember),[Measures].[Unit Sales])', solve_order=
member [Measures].[Store Sales YTD] A
'SUM(YTD([Time].CurrentMember),[Measures].[Store Sales])', solve_order=
member [Time].[Last Year] AS 'ParallelPeriod([Time].[Year],1
[Time].[1998])', solve_order=

SELECT crossjoin({[Time].[1998],[Time].[Last Year] },{[Measures].[Unit Sales YTD], [Measures].[Store Sales YTD]}) on columns, non empt
[Customers].[Country].members on rows from [Sales

Regards

Chri

----- Patrice Lamarche wrote: ----

Hello Everyone

I'm currently working with YTD calculation and i got some logic proble
...



But in the case I only have Jav-Feb-March of data in 1998.. I would like t
have the same period for the 1997 YT
with member [Measures].[Unit Sales YTD] A
'SUM(YTD([Time].CurrentMember),[Measures].[Unit Sales])
member [Measures].[Store Sales YTD] A
'SUM(YTD([Time].CurrentMember),[Measures].[Store Sales])

SELECT crossjoin({[Time].[1998],[Time].[1997]},{[Measures].[Unit Sales YTD]
[Measures].[Store Sales YTD]}) on columns, non empt
[Customers].[Country].members on rows from [Sales
with member [Measures].[Unit Sales YTD] A
'SUM(YTD([Time].CurrentMember),[Measures].[Unit Sales])
member [Measures].[Store Sales YTD] A
'SUM(YTD([Time].CurrentMember),[Measures].[Store Sales])
member [Time].[Last Year] AS 'ParallelPeriod([Time].[Year],1
[Time].[1998])

SELECT crossjoin({[Time].[1998],[Time].[Last Year] },{[Measures].[Unit Sale
YTD], [Measures].[Store Sales YTD]}) on columns, non empt
[Customers].[Country].members on rows from [Sales

Why Time.Last Year return nothing. IF i replace it b
ParallelPeriod([Time].[Year],1, [Time].[1998]) i got data ..

Thank

Best Regards

Patric

Thanks it work

Best Regards,

Patrice
"Chris Webb" <OnlyForPostingToNewsgroups (AT) hotmail (DOT) com> wrote