OBIEE 11g logon process: overview

When a user logs in via the analytics web app UI, the request containing the user credentials will be sent to the BI Presentation Server which in turn passes the request on to the BI Server. The BI Server is authoritative for user authentication. In the first instance the BI Server will attempt to authenticate the user credentials via a web service call to the BI Security Web Service, which is deployed in the WebLogic Managed Server and is protected by a WS-Security policy which requires the BI Server to itself authenticate itself to Oracle Web Services Manager before the call can be received by the BI Security Service. The BI Server uses credentials stored in the Credential Store (CSF) under the oracle.bi.system map and uses those to authenticate itself to the BI Security Service when attempting to authenticate the credentials specified by the user. If there is a problem with the BI System User credentials, or the Oracle Web Services Manager, then the call from the BI Server to the BI Security Service will fail and hence so will the overall logon process.

Hope This helps.

Sunil S Ranka

“Superior BI is the antidote to Business Failure”

Text and understanding was picked from — Oracle BI Enterprise Edition 11g – Troubleshooting — white paper released by Oracle.

Patch application and validation steps

To apply the patch to each Oracle Home:

• Display a command window and navigate to the location of the OPatch executable.The OPatch utility is located in the ORACLE_HOME/ORACLE_INSTANCE/OPatch directory (on UNIX operating systems) or ORACLE_HOME\ORACLE_INSTANCE\OPatch directory (on Windows operating systems).For example, the directory on Windows might be:

D:\OBI11g\Oracle_BI1\OPatch

• Run the OPatch utility using the following command syntax:

  D:\OBI11g\Oracle_BI1\OPatch apply -id <patch_id> -oh <oracle_home> 

• For example, you might use the following command:

  opatch apply -id 123456 -oh D:\OBI11g 

• Post Installation you can run following command for patch validation

  D:\OBIEE11g\Oracle_BI1\OPatch>opatch lsinventory 

Hope This Helps

Sunil S Ranka
“Superior BI is the antidote to Business Failure”

How to increase SAW (Presentation Server) logging

To increase the SAW/OBIPS logging level you need to make some changes to logconfig.xml.

• Open logconfig.xml file located in D:\OracleBIData\web\config folder

• Add the following lines in the <Filters> node of logconfig.xml:

<Filters>
 <FilterRecord writerClassGroup="Cout" path = "saw" information="100" warning="100" error="100" security="100"/>
 <FilterRecord writerClassGroup="File" path = "saw" information="100" warning="100" error="100" security="100"/>
 <FilterRecord writerClassGroup="File" path = "saw.httpserver.request" information="100" warning="100" error="100" security="100"/>
 <FilterRecord writerClassGroup="File" path = "saw.httpserver.response" information="100" warning="100" error="100" security="100"/>
 <FilterRecord writerClassGroup="File" path = "saw.mktgsqlsubsystem.joblog" information="100" warning="100" error="100" security="100"/>
</Filters>

• You will also need to increase the number of log files being produced. This is also controlled in logconfig.xml.

• In the <Writers> node, modify Writer implementation:

<Writer implementation="FileLogWriter" name="Global File Logger" writerClassId="1"
dir="{%SADATADIR%}/web/log" filePrefix="sawlog" maxFileSizeKb="10000" filesN="100" />

Set the filesN parameter to 100.

• Logging at this level produces a lot of data. You need to make sure you have an adequate amount of free space on the hard drive to accommodate the additional logs.

• For changes in logconfig.xml to take affect, presentation services (OBIPS) needs to be restarted.

Hope This Helps

Sunil S Ranka

The above details are been taken from Oracle Metalink3 Website (Document 740257.1). Document 740257.1 can be found at: https://metalink3.oracle.com/od/faces/secure/km/DocumentDisplay.jspx?id=740257.1

How To disable hyperlink for Value Interaction column

Hi All,

Recently at client place, came across very interesting requirement. The tone of requirement was very basic, but it was amazing to see the tremendous business value, for this requirement.

Following was the requirement :

If the data value in value interaction column is null, than there should be some “Custom Text” with out any hyperlink, but if column has value than functionality should be same as Out-Of-Box.

Steps to follow ::

• In the Column Formula, under — Edit  Column Formula window — put following code (change “TableName”.”ColumnName” appropriately)  :

case when "TableName"."ColumnName" is null then 'No Data' else "TableName"."ColumnName" end

• Create Static Text View and add following Java Script, make sure Static Text View is last in the compound laye out :

<script>
var aElm=document.getElementsByTagName('td');
for(var i=0; i<aElm.length; i++) {
	if((aElm[i].className.indexOf("OOLD") > -1)){
	//alert(aElm[i].innerHTML);
		if((aElm[i].innerHTML.indexOf("<span><span>No Data</span></span>") > -1)){
			aElm[i].innerHTML = '<span><span>No Data</span></span>';
		}// end of if
	}// end of if
}// end of for
</script>

• Below image shows the final out come and Compound Lay out view.

Compound Layout and Final View

I have tried explaining with an abstraction, I will be more than happy to answer any specific question.
Hope This Helps,

Sunil S Ranka