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 this:
1. dataset1 with lastperiod() static values
for this statics i used MDX LastPeriods(5,[Time].[Fiscal].[Fiscal Year].&[2009].&[2])
2. dataset2 with main query values..
Reuirement:
when i pick the year and qtr values dynamically from parameters ...those year and qtr values to pass to lastperiod(), then accroding that values need to find out last periods()..
:hehe::hehe:
Please give the me directions to solve this issue
Thanks in Advance.
SR