OBIEE 11.1.1 - How to use OBIEE Impersonate

If you quickly need to check a user permission issue, you can use the Impersonate parameter on the url. However, you have to issue two requests to get a report, you cannot do this in a single url:

Impersonation is "atomic" with authentication. It's not a "request" level parameter. You have to authenticate in "impersonated mode":

http://server:7001/analytics/saw.dll?Logon&NQUser=YourAdministrator&NQPassword=Admin123&Impersonate=TheUserToImpersonate

Then

http://server:7001/analytics/saw.dll?Go&Path=%2fshared%2ftests%2ftest1&Options=rmf&Action=print

Also, you need to make sure that the user "YourAdministrator" has the right permissions in 11g: oracle.bi.server.impersonateUser and possibly oracle.bi.server.queryUserPopulation

 

Refer Oracle link-

https://blogs.oracle.com/pa/entry/how_to_use_obiee_impersonate

OBIEE 11G- Javascript and CSS locations

In OBIEE 11g, the path for Javascript and Custom Style Sheet is located at-

OBIEE\user_projects\domains\bifoundation_domain\servers\bi_server1\tmp\_WL_user\analytics_11.1.1\7dezjl\war\res\

And for calling them-
<script type="text/javascript" src="res/test.js"></script>
<link href="res/test.css" type="text/css" rel="stylesheet">
Refer- https://forums.oracle.com/forums/thread.jspa?threadID=2453825&tstart=0



 

Possible Changes in Oracle BI Enterprise Edition Appearance and Behavior After Upgrade-10g to 11g

Beautifully documented by Oracle for the upgrade changes from 10g to 11g.

http://docs.oracle.com/cd/E21764_01/bi.1111/e16452/apndx_ui_chngs.htm

 

Gauge Sub-title removed in 11g

In OBIEE 11g Gauge view, Sub-Title is removed from Gauge Titles tab.
People who have migrated from OBIEE 10g to OBIEE 11g having the Sub-Title view in their reports would have to check it out.
May be this too would go into OBIEE 11g pitfalls :)

Comments are always welcome...

Date Format change based on Locale Setting

 

This piece of information is a very base to locale setting.

 

When a user requested to change the date format, as the user couldnt always make the changes after downloading to excel.

So the change was to be made for the users setting instead of going globally.

 

We can either ask the user to login with the Language which is expected to produce the date format.

 

 

 

 

 

 

Else we ask the user to go the Settings-->My Account and make the below changes and finish the task and check the results.

Below is the default setting found for the user with English Language.

 

And the result would be-

 

After the changes in the My Account Setting-

The result would be-

Comments are always welcome...