How to bypass Presentation Server Cache in OBIEE 11G

During our development if we wanted to check the report level UI changes, sometimes we will not see the changes immidiately. This is due to Presentation Server Cache. Eventhough we disable the BI Server cache, It doesnt make any effect on presentation Server objects.

So in that situations we need to disable Presentation server cache permanently across OBI Application, To do this add the following parameters in instaceconfig.xml. (Make sure that you have taken a backup copy of instanceconfig.xml)

<ServerInstance>
———

<Cursors>
<ForceRefresh>true</ForceRefresh>
</Cursors>

——–

</ServerInstance>

Now restart the OBI Presentation server service and test the results.

Note: Keep in mind that this parameters cause Presentation Server to always bypass its cache. To be used only for testing – may have serious performance implications.

Keep smiling 🙂

Thanks,
Shiva

 

OBIEE 11G – Important Security Considerations (SSL) if using external LoadBalancer

In OBIEE enterprise topology, make sure the external load balancer used should be able to terminate SSL requests at the load balancer and forward traffic to the back-end real servers using the equivalent non-SSL protocol (for example, HTTPS to HTTP).

For security purposes, and because the load balancer terminates SSL requests (Oracle HTTP Server routes the requests as non-SSL to WebLogic Server), after SSL is configured for the load balancer, turn on the WebLogic Plugin Enabled flag for the domain. To do this, follow these steps:

1. Log in to the Administration Console.
2. Click the domain name in the navigation tree on the left.
3. Click the Web Applications tab.
4. In the Change Center, click Lock & Edit.
5. Select WebLogic Plugin Enabled.
6. Click Save, then click Activate Changes.
7. Restart the Administration Server and Managed Server.

Tip: WebLogic Plugin Enabled: Specifies whether or not the proprietary WL-Proxy-Client-IP header should be honored. (This is needed only when WebLogic plugins are configured.)

In additon to above, make sure Oracle HTTP Server (OHS) to add the following SSL directives in each <location> section to the ORACLE_BASE/admin/instance_name/config/OHS/component_name/mod_wl_ohs.conf file:

WLProxySSL ON

WLProxySSLPassThrough ON

Tips: Set WLProxySSL parameter to ON to maintain SSL communication between the plug-in and WebLogic Server when the following conditions exist:

An HTTP client request specifies the HTTPS protocol
The request is passed through one or more proxy servers (including the WebLogic Server proxy plug-ins)
The connection between the plug-in and WebLogic Server uses the HTTP protocol
When WLProxySSL is set to ON, the location header returned to the client from WebLogic Server specifies the HTTPS protocol.

Reference: https://blogs.oracle.com/pa/entry/obiee_11_1_1_important1

Thanks,
Shiva

 

List of Bug fixes in OBIEE 11.1.1.6.0

Here is the document provides a listing of Oracle Business Intelligence Enterprise Edition (OBIEE) bugs which have been fixed in the OBIEE 11.1.1.6.0 release. It also lists the bugs fixed in Oracle Business Intelligence Publisher (BIP) and Essbase

A copy of pdf can be download here: List of bug fixes in OBIEE 11_1_1_6_0

Reference: https://support.oracle.com/CSP/main/article?cmd=show&id=1412748.1

 

Thanks,

Shiva

 

OBIEE 11.1.1.6.0 is available now

The Oracle Business Intelligence Enterprise Edition (OBIEE) 11.1.1.6.0 has been made generally available.

The software is available for download from OTN.

@ http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/bus-intelligence-11g-165436.html

The related documentation is published and available from Oracle Business Intelligence Enterprise Edition Documentation library.
With this release of OBIEE 11.1.1.6.0, the entire Business Intelligence Foundation Suite has been made generally available, opening the door for “Oracle Exalytics Super-fast, Super-ready”.

For more information on exalytics: http://www.oracle.com/exalytics

Oracle Exalytics installation,configuration and deployment info: http://docs.oracle.com/cd/E23943_01/bi.1111/e24706/toc.htm

Happy Reporting….

 

Thanks,

Shiva