Home Forums Data Warehousing Analysis Services Passing parameter values to MDX query using SSRS RE: Passing parameter values to MDX query using SSRS

  • October 1, 2015 at 6:02 am

    #1830711

    Try the StrToMember function. Also make sure your parameter strings are formatted correctly. Here's a snippet of code I used that is working.

    {StrToMember(@MonthYear, CONSTRAINED).lag(23):StrToMember(@MonthYear, CONSTRAINED)}