How to pass a presentation variable via GoURL/prompted URL?

airwolf_86

Hello everyone,

I am using 12c.

Question 1

This is the scenario.

I have 2 dashboard pages.

Dashboard page 1 has a District column with a Presentation variable attached to it. Let's call it PV_DISTRICT. (this is a prompt). This has a default district selected.

This page has a performance tile, which when clicked on takes the user to dashboard page 2.

The navigation is via an Action link to a web page. (basically a GoURL).

Note - I created the URL for the action link by going to dashboard page 2 and clicking on "Create prompted link".

Now on dashboard page 2, i have the same prompt as dashboard page 1 which is District. I have used the same presentation variable on it as well.

I want the district from page 1 to be passed on to page 2.

How can I pass it via a GoURL to page 2?

&var1=

&psa1=

&val2=

--------------------------------

Question 2

When I created the prompted link the URL is created to something similar.

https://www.myDEV.com/analytics/....

But when I promote this from DEV to TEST environment or any other environment, I iwll have to manually change the URL.

Does BI have a format where I an exclude the "https://www.myDEV.com/analytics/ " part of the URL and type in the rest? I tried this but it didn't work.

Do I need to create a Repository variable in the RPD for the URL and change that URL in the RPD when it's migrated across environments?

Or is there another way?

[Deleted User]

ad 1) Is the prompt on dashboard 2 based on the same BM or do the columns at least have the same fully qualified name? Because then the value passing happens automatically.

ad 2) RPD server variable. That's what they're there for and you can easily change them during deployment with a simple command and a JSON file.

https://docs.oracle.com/middleware/12212/biee/BIEMG/GUID-FEBD6FB9-FB8E-461C-9447-056F2CB93A3C.htm#updt_repos_var_cmd

airwolf_86

Hi Christian,

Many thanks for the reply.

1) The prompts are from two different subject areas but the fully qualified name is the same. If I use an action link, it passes the value automatically. But since i'm using the GoURL, it doesn't. I am using a GoURL as I've have to pass other values via parameters. The presentation variable is just not passing. Hence the question.

2) Did not knw about this. Thanks heaps.

[Deleted User]

Are you using a formula to construct the URL? If yes what's your syntax? If no how are you constructing the GoURL?

airwolf_86

I am using the syntax/URL formed by BI itself. I went to the destination page and then clicked on "Create prompted link". This created the URL for me to use. But it doesn't pick the presentation variable in the district column. Was trying to figure out how to pass it but nothing worked.

The parameters come up something like this. But not all of them get used per value passed.

&psa1=

&var1=

&val1=

&col1=

airwolf_86

This is the formula syntax

<Content Path>, Action=Navigate, Column1 (col1), Operator1 (op1), Values1(val1), Column2 (col2), Operator2 (op2), Values2 (val2) ...

https://docs.oracle.com/cd/E10383_01/doc/bip.1013/e10416/dashbdlinks.htm

[Deleted User]

No I mean literally how do you construct it. I know the syntax

airwolf_86

Here is the Prompted URL created on the dashboard page 2 (the destination page)

https://xxx/analytics/saw.dll?Dashboard&PortalPath=%2Fshared%2FQAMT%2F_portal%2FQAMT&Page=QAMT&Action=Navigate&var1=dash…

The two presentation variables in the URL are prevalent in the page 2, so that's fine.

I need to pass the variable from page 1 to page 2, which is the district.

I tried passing the below parameters, but it didn't work. I left the value parameter blank as it's a variable value.

&var3=dashboard.variables%5B%27PV_SELECTED_CSC%27%5D

&val3=

&psa3=%22Child%20Profile%20Completion%22

&col3=%22Internal%20Organisation%22.%22Internal%20Organisation%20(Business%20Unit)%22

[Deleted User]

Ok english isn't my primary language so I must be doing something wrong in asking the question.

How are you building / putting together that URL? In a column formula? In the action framework action "Navigate to web page"?

airwolf_86

Sorry, misinterpreted it i guess. English is not my first language as well.  I use it in "Navigate to web page"

[Deleted User]

Are you following Boris' blog post there?

OBIEE in IL: OBIEE - GO URL, the old (Px) and the new (COLx) way

Because what you're doing here means you aren't passing any value at all: