0 Replies Latest reply on Aug 12, 2017 6:38 AM by Abhiiiiiii

    Pass multiple selected values using Presentation Variable in GO URL

    Abhiiiiiii

      Hi Guys,

       

      I have a go URL in my report. The dashboard where this report is placed, there is a multiselect Prompt with a Presentation variable defined. I am trying to pass this selected value to target dashboard using GO URL. I am able to pass it successfully when there is only 1 value selected.

       

      However when i select multiple values OBIEE replaces the presentation variable with just comma separator and on the target dashboard this URL tries to push the value captured by Presentation Variable as single value and I dont get any data there.

       

      Here is the syntax which is used:

       

      Selecting single value

      ====================

      http://localhost:9502/analytics/saw.dll?Dashboard&PortalPath=%2Fshared%2FField%2F_portal%2FPathway&Page=EventSummary&Action=Navigate&col1=%22-%20Dim%20-%20Sales%22.%22Level2%20Name%22&val1=%22Ali,Moe%22&col2=%22-%20Fact-Sales%22.%22Event%20Name%22&val2=%22Application,%20Development%20%26%20Integration-%20Sydney,%20AUS%22&var3=SALES_LEVEL&val3=%222%22

       

      Value Selected:  Application, Development / Integration- Sydney, AUS

      Status Working Fine

       

      Selecting multiple values:

      ======================

       

      http://localhost:9502/analytics/saw.dll?Dashboard&PortalPath=%2Fshared%2FField%2F_portal%2FPathway&Page=EventSummary&Action=Navigate&col1=%22-%20Dim%20-%20Sales%22.%22Level2%20Name%22&val1=%22Ali,Moe%22&col2=%22-%20Fact-Sales%22.%22Event%20Name%22&val2=%22Application,%20Development%20%26%20Integration-%20Sydney,%20AUS,Security%20%26%20Risk%20Paulo,%20BRA,Orlando%22&var3=SALES_LEVEL&val3=%222%22

       

       

      Values Selected:   Application, Development / Integration- Sydney, AUS

                                    Security / Risk Paulo, BRA

                                    Orlando

       

      Status Not Working Fine. As OBIEE passing it as single value like "Application, Development / Integration- Sydney, AUS,Security / Risk Paulo, BRA,Orlando"

       

      Any suggestions?

       

      Regards

      Anand