Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Pass multiple selected values using Presentation Variable in GO URL

Question
1
Views
0
Comments
Abhiiiiiii
Abhiiiiiii Rank 1 - Community Starter

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