Hi Guys

If you have any idea in this issue, Please give some tips onthis..and detailed process

1. how to pass parameter values dynamically into lastperiods() in MDX 2005

i did like...

Hi Jeff

I got your point..here is my MDX query

select

[Measures].[Total Days Cash on Hand] ON ROWS,

LastPeriods

(5,[Time].[Fiscal].[Fiscal Year].&[2009].&[2]) ON COLUMNS

FROM

MyCube

bu using this i got the result for...

My SSRS report on OLAP cube...

how can we calculate the last 2 qtrs fiffrence dynamically, wheather in OLAP cube / Data tab or somewhere else..pls let me know

Thanks

Gail

Hi

Matrix layout my report: year / ...

Hi Will

I think my problem is different, i saw that link in the earlier.

I have one data set 1with ast periods() and another data set2 with year and qtr...