none
Report Action from SSAS to Report(SSAS or SSRS) RRS feed

  • Question

  • Hello,

    I am struggling to pass a parameter from SSAS cube to SSAS or SSRS report from Report Action window.

    I am trying like below

    condition:[PRODUCT DIM].[PRODUCT].currentmember.Level is [PRODUCT DIM].[PRODUCT].[PRODUCT]

    parameter:UrlEscapeFragment([PRODUCT DIM].[PRODUCT].CurrentMember.MemberValue)

    or

    UrlEscapeFragment([PRODUCT DIM].[PRODUCT].CurrentMember.UniqueName)

    or

    UrlEscapeFragment(MEMBERTOSTR([PRODUCT DIM].[PRODUCT].CurrentMember))

    My problem is,it is opening up the detail report but not passing the parameter value,i tried detail report by keeping

    dropdown list or empty box i.e user has to enter value in detail report.Problem is SSAS is picking the right value from

    my excel but it is not highlighting the value in detail report.It is been two days i am struggling with this,any help is greatly appreciated!!

    thanks

    krishna

    Wednesday, April 16, 2014 5:19 AM