Go URL with Parameters Example in OBIEE 12c (12.2.1.3.0)

This post will give the example on Go URL.

From OBIEE 12.2.1.3.0, Lightweight SSO is enabled. So we have to disable it first to work with Go URL. To Know and Disabling the Lightweight SSO, Refer Here

By default, you can add up to 100 parameters to the URL. However, you can adjust the number of parameters by modifying the Prompts/MaxPromptedURLParams setting in instanceconfig.xml.

&Action=Navigate

&P0=n  where n is the number of columns you wish to filter, currently 1 - 6.

&P1=op  where op is one of the following operators.

Operator	Meaning
eq	Equal to or in.
neq	Not equal to or not in.
lt	Less than.
gt	Greater than.
ge	Greater than or equal to.
le	Less than or equal to.
bwith	Begins with.
ewith	Ends with.
cany	Contains any (of the values in &P3).
call	Contains all (of the values in &P3).
like	You need to type %25 in place of the usual % wildcard. See the examples that follow.
top	&P3 contains 1+n, where n is the number of top items to display.
bottom	&P3 contains 1+n, where n is the number of bottom items to display.
bet	Between (&P3 must have two values).
null	Is null (&P3 must be 0 or omitted).
nnul	Is not null (&P3 must be 0 or omitted).
&P2=ttt.ccc	In this parameter, ttt is the table name and ccc is the column name. If the table or column contains spaces, it must be quoted with double-quotes. Spaces should be escaped as %20, for example, Measures."Dollar%20Sales".

Example:
http://localhost:9502/analytics/saw.dll?Go&Path=%2fshared%2fTest%2fAnalysis%2fSales&Options=rmf&Action=Navigate&P0=2&P1=eq&P2=%22Operating%20Unit%22.%22Operating%20Unit%20Name%22&P3=CAL&P4=eq&P5=Time.Year&P6=2+2016+2017

Decoding the above example:
It has Action=Navigate
P0=2 which means has 2 columns for parameters
p1=eq means Equal operator applied
P2=Opearting Unit Name column from Operating Unit Table
P3=Value of the P2. (example here is CAL)
P4=eq is another equal operator for another columns
P5=Year column from Time Table
P6=2+2016+2017 means Year has two values which 2016 and 2017

SQL Issued By BI is like:

WHERE ( ("Time"."Year" IN ('2016', '2017')) AND  ("Operating Unit"."Operating Unit Name" = 'CAL')) FETCH FIRST 65001 ROWS ONLY

Complete Oracle Reference Guide - Click Here

Cheers!
Bose

Go URL in OBIEE 12c

Problem:

When we are trying to use Go URL functionality, It always comes to login page.

Why is it happening?

With 12c, 12.2.1.2+ A new feature called Light Weight SSO has been introduced. 

When this feature is enabled, using "NQUser"/"NQPassword" in the URL is not possible or supported.
 
Lightweight SSO is implemented by default in new installations of Oracle BI EE release 12.2.1.3.0

Solution:

Disabling the Lightweight SSO will help us to overcome this issue and Report/Dashboard with Go URL will just fine without going to login page.

Steps to Disable Lightweight SSO:

Step1:

Stop all the BI Services. Go to the link to know Stop and Start BI 12c Services

Step2: 

After stopping the BI Services, Go to the following path and execute WLST offline

[ORACLE_BI_HOME]/oracle_common/common/bin/wlst.sh

execute the 'disableBISingleSignOn' command to disable.

wls:/offline> disableBISingleSignOn('/path to your domain')

e.g: 

wls:/offline> disableBISingleSignOn('$ORACLE_BI_HOME/user_projects/domains/bi')

Step3:

Now Start all the BI Services using ./start.sh (Linux) or Start.cmd (Windows) and check with the Go URL. 

Cheers!

Bose