Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 216 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Variable Prompt not getting set via URL parameters
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.
Answers
-
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
0 -
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}"
0 -
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
0 -
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
0 -
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"
0 -
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.
0