nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

How to pass Presentation Variable to URL ?

Muhammad Kamal

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

Find more posts tagged with

Accepted answers

All comments

[Deleted User]

Why not simply capture the presentation value inside a column formula and then reference that column in the navigate action's parameters?

Muhammad Kamal

@Christian Berg

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 ??

[Deleted User]

Sure just tick the "Hidden" checkbox

Edit: And the action link itself like this of course:

Muhammad Kamal

@Christian Berg

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 ??

[Deleted User]

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?

Muhammad Kamal

@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 ??

[Deleted User]

Is "Fixed" true or false?

Muhammad Kamal

@Christian Berg

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 !!

asim cholas

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.

[Deleted User]

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.