Search This Blog

Sunday 14 October 2018

Creating Impersonated User in OBIEE 12c

Here is the steps to create Impersonate Users:

Precheck:
Please create the user in console to which you want to apply impersonator 

Step1:
  • From the Weblogic Domain menu, select Security.
  • Click Application Policies.

Step2:
  • Click Application Policies.
  • Click Create to display the Create Application Grant page.

Step3:
  • In the Permissions section, click + Add .
  • Select Resource Types
  • Select oracle.bi.user from the Resource Type list.
  • Click Continue to display the Add Permission dialog.
  • Enter an asterisk (*) in the Resource Name field and click Next


Step4:
  • Select impersonate in the Permission Actions section.
  • Click Select.


Step5:
  • Now add a new grantee.
  • In the Grantee section click + Add to display the Add Principal dialog.

Step6:
  • We can choose to grant the newly created permission to either an application role or a user. In this example, we choose a user.
  • Select User from the drop-down list.

Step7:
   Here I have selected the user BIImpersonatorUser that I have created in console. 

Cheers!
Bose

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

Tuesday 2 October 2018

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

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