Search This Blog

Wednesday 10 October 2018

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

14 comments:

  1. Thank you very much for your ideas to post comments. The content was really very interesting. I am really thankful to you for providing this unique information. Please keep sharing more and more information

    Java Training in Chennai

    Java Course in Chennai

    ReplyDelete
  2. Nice blog, Thank you for this blog is very informative.

    ReplyDelete
  3. Hi, I read your post and found it quite interesting. The post you shared is very unique and informative. Thanks for sharing such a useful post.

    Biobags suppliers in chennai

    ReplyDelete
  4. For a long time me & my friend were searching for informative blogs, but now I am on the right place guys, you have made a room in my heart! BA Finance

    ReplyDelete

What is Oracle Database Link and How to create database link (DB Link)

 https://www.oracletutorial.com/oracle-administration/oracle-create-database-link/

Recent Posts