Variable Prompt not getting set via URL parameters

Greg Faris

I am trying to set a Variable prompt (presentation variable) for a dashboard by sending parameters in the querystring of the URL. I can get this working fine for normal column prompts, but I can't get the variable prompt to be set to the new value. It just remains the default value that I set it to in the prompt itself. I've tried a few different ways. Here is an example of the URL I am trying to use:

xxxxx.com/analytics/saw.dll?Dashboard&PortalPath=%2Fshared%2FPMRA%2FPublished%20Reports%2FDashboards%2FVES%20Delivery%20Dashboard&Page=Comparison%20Scorecard&Action=Navigate&var1=%22varDimName%22&val1="Vendor"

It doesn't appear the "Create Prompted Link" option works when using a Variable Prompt in your dashboard prompt.  I've tried to use this on a number of dashboards that have variable.

I use variable prompts to dynamically change the dimension that the data is being grouped by.  I need to allow another application to feed in input to this from the URL they're sending into the dashboard.

nm.Mani

Hi,

quick question, did you try with out Val1 from your go url.

i mean,

xxxxx.com/analytics/saw.dll?Dashboard&PortalPath=%2Fshared%2FPMRA%2FPublished%20Reports%2FDashboards%2FVES%20Delivery%20Dashboard&Page=Comparison%20Scorecard&Action=Navigate&var1=%22varDimName%22

oracle doc  -

https://docs.oracle.com/cd/E14571_01/bi.1111/e16364/apiwebintegrate.htm#BIEIT365

MM

Greg Faris

I need to set the column name to a specific field name.  If I don't pass a value for the presentation variable, it won't allow the URL to define the field to group the data on.  I just tried the URL without the val1 value, and it pretty much does the same thing as with the value...it just returns my default column.

Normally, the dashboard prompt itself overrides the default for the column.  Here's how I have the column defined in the analysis:

"Hierarchy - Order Manager"."Order Manager - @{varDimName}{Skill}"

nm.Mani

Defalut value is just to allow you for editing and testing the report before you add on to the dashboard. I dont think we can pass the value like this in GO URL.

after bit of google, you can use Replace

here is the example -

<a href=http:// ‘||VALUEOF(domain_name)|| ‘ :9704/analytics/saw.dll?GO&path=/shared/Operational%20Reports/Scorecard&Options=d&Action=Navigate&P0=3&P1=eq&P2=%22Reporting%20Line%22.%22Reporting%20Line%20Domain%22&P3=’||REPLACE(“Reporting Line”.”Reporting Line Domain”,’ ‘,’%20’)|| ‘&P4=eq&P5=Geography.Dominion&P6=’||REPLACE(‘@{DominionPromptVar}’,’ ‘,’%20’) ||’&P7=eq&P8=Geography.%22Country%20Name%22 &P9=’||REPLACE(‘@{CountryNamePromptVar}’,’ ‘,’%20′) ||’>’ || Link || ‘</a>’

Regards,

MM

Greg Faris

Is oracle's documentation wrong then?  Maybe it just doesn't work.  They have it posted you can pass in variables with values:

https://docs.oracle.com/middleware/12211/biee/BIEUG/GUID-5347837C-D903-43E8-90D1-89D65C8BFDA6.htm

FTisiot

Why don't you

1. create a "Fake Column" in the RPD like "Dim Variable"."Variable"

2. Create a prompt for "Dim Variable"."Variable" that manages the variable varDimName

3.  create the prompted link using "&col1=%22Dim Variable%22.%22Variable%22&op1=eq&val1="Vendor"

Greg Faris

FTisiot wrote:Why don't you1. create a "Fake Column" in the RPD like "Dim Variable"."Variable"2. Create a prompt for "Dim Variable"."Variable" that manages the variable varDimName3. create the prompted link using "&col1=%22Dim Variable%22.%22Variable%22&op1=eq&val1="Vendor"

Thanks for the workaround.  Looks like this'll work, but I'll have to put in a release to add the bogus columns.  I used an existing dimension to test setting the variable in a column prompt, and it worked.