SSAS report Action - Error passing parameter to SSRS report RRS feed

  • Question

  • Hi All,

    I am trying to pass a parameter from the report Action feature of SSAS . My year is a multi hierarchy : how do we pass the following parameter to SSRS ?

    my Year dimension has a hierarchy with 2 levels : one is a campaign and the other campaign year as seen below

    [Dim Campaign Year].[Campaign - Campaign Year].[Campaign].&[A].&[2009],

    I am trying to pass the parameter as :

    UrlEscapeFragment([Dim Campaign Year].[Campaign - Campaign Year].[Campaign].Currentmember.Name)

    but the cube does not recognize the above.  i have a feeling the second level is not being recognized

    any help much appreciated




    • Moved by Sean_Flanagan Wednesday, June 30, 2010 11:48 PM SSRS parameter issue (From:ProClarity - General)
    Wednesday, June 9, 2010 3:44 PM

All replies

  • moving to SSRS forum

    Microsoft ProClarity | This posting is provided "AS IS" with no warranties, and confers no rights.
    Wednesday, June 30, 2010 11:47 PM