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].&.&)
2. dataset2 with main query values..
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()..
Please give the me directions to solve this issue
Thanks in Advance.