Configure session timeout in obiee 11g

The connection between the OracleBI Presentation Server and OracleBI Services when idle(no requests running) will expire by default in 210 minutes,this can be manually configured using the following steps:

1. Find the file instanceconfig.xml in following location

         OracleInstance\Config\OracleBIPresentationServices\Coreappication\instanceconfig.xml

2. Add the following line in the security block add "ClientSessionExpireMinutes" block with no of minutes you want.

                 <clientsessionexpireminutes> 1440 </clientsessionexpireminutes>

3. Restart services OracleBI Presentation Services.

Display OutputLogicalSQL in Presentation Services for every Analysis

This is on of the most helpful options that helps a developer a lot.
We need to modify the instanceconfig.xml file to enable this feature.

Follow the below simple steps to enable it.

1.Find the instanceconfig.xml file take backup for safety.open the file.

2.Add the below XML code to the file and save it.

                     <TestAutomation>

                 <OutputLogicalSQL>true </OutputLogicalSQL>

                 </TestAutomation>

3.Restart the presentation services.


That's it,You are Done.