• 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