Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
How to pass Presentation Variable to URL ?

Hi All,
We have Oracle Business Intelligence EE 12c v12.2.1.2.0
what we need to do is pass a parameter to URL using Action Link - Navigate to a Web Page from one of our Dashboards, the options available for this parameter are:
- Value
- Session Variable
- Repository Variable
- Column Value
but what we need to pass is Presentation Variable "not available in previous menu", because we have some Dashboard Prompts in this Dashboard, we are using them to set some Presentation Variables, and the only options available for Prompts to set are:
- Presentation Variable
- Request Variable
we tried to select "Value" option, then fill the box with the following: "where P_VAL is the Presentation Variable comes from the Prompt"
- @{P_VAL}
- @[P_VAL]
but with no success
any idea how can we mange to do this ??
thanks in advance
Answers
-
Why not simply capture the presentation value inside a column formula and then reference that column in the navigate action's parameters?
0 -
thanks for the reply, solved my first question,
now my second one:
How to hide the Dialog Windows with Execute button??
we need the URL comes direct after clicking the link, no need for this Dialog Windows to show us first which values we are passing, is that possible ??
0 -
Sure just tick the "Hidden" checkbox
Edit: And the action link itself like this of course:
0 -
Thanks, when we ticked the "Hidden" checkbox, the "Fixed" checkbox ticked automatically, also all parameters passed as NULL, and the URL didn't return correct results, any idea ??
0 -
You've got to look at this more in detail. What is the URL passing? What isn't it passing? Are the parameter missing? Are they passed wrong? Are they not applied?
0 -
@Christian Berg thanks for the reply
here is what we actually do, we have this intranet URL:
http://something.com/?Road_NO=@{R}&AreaCode=@{A}&Date_from=@{DF}&Date_to=@{DT}
we used this URL in the Navigate to a Web Page - Action, we defined all 4 parameters as mentioned before as Columns, if we leave the Hidden Option unticked, then every thing works fine, the parameters passed like a charm,
but when we tick the Hidden Option, then yes the Dialog Window doesn't show up, but all parameters passed as null values, and the web page tries to call the URL as following:
http://something.com/?Road_NO=&AreaCode=&Date_from=&Date_to=
any idea ??
0 -
Is "Fixed" true or false?
0 -
Once we tick the Hidden Option, the Fixed Option turn itself ticked automatically, and if we untick it again, then the Hidden Option untick itself back too !!
0 -
It could be an issue with your internal security. There is no reason i could find values are not passing while it is hidden. Try from a different environment and see.
0 -
Just tested and with column values this effectively gets dropped in 12.2.1.2.0. Damn.
So alternative approach. Change from presentation variables to request variables. Yes you'll need to create 4 fake placeholder session variables but you can defer their execution.
0