OBIEE Connection Pool Change Utility for 11.1.1.6.0/.1/.2

Thanks to Robin Moffatt for tweeting this little tidbit which would be very useful for changing OBIEE 111.1.6.0/.2g Connection Pool passwords:

http://docs.oracle.com/html/E14770_36/biee.htm#CHDEEFFA

OBIEE 11g Table View Limts

Issue today were in OBIEE 11g the number of rows brought back initially in a table view were low (25) and the user wanted the 10g (view all rows) functionality "unlike the OOTB 11g settings where it only showed up to 500" . So off to Oracle docs I was to find the solution.I have found the following setting that need to be made depending on what you are wanting to set the behavior to (be careful of some of these setting and do not set them too high or it could cause issues on BI server as well as Data Warehouse. Cahnges made to your instanceconfig.xml file located at:

<YourMiddlewarehome>\instances\instance1\config\OracleBIPresentationServicesComponent\coreapplication_obips1

<Views>
<Pivot>
<!--This Configuration setting is managed by Oracle Business Intelligence Enterprise Manager-->
<DefaultRowsDisplayedInDelivery>75</DefaultRowsDisplayedInDelivery>
<!--This Configuration setting is managed by Oracle Business Intelligence Enterprise Manager-->
<DefaultRowsDisplayedInDownload>5000</DefaultRowsDisplayedInDownload>
<!--This Configuration setting is managed by Oracle Business Intelligence Enterprise Manager-->
<DisableAutoPreview>false</DisableAutoPreview>
<MaxVisibleColumns>5000</MaxVisibleColumns>
<MaxVisiblePages>2000</MaxVisiblePages>
<MaxVisibleRows>100000</MaxVisibleRows>
<MaxVisibleSections>2500</MaxVisibleSections>
</Pivot>
<Table>
<!--This Configuration setting is managed by Oracle Business Intelligence Enterprise Manager-->
<DefaultRowsDisplayedInDelivery>75</DefaultRowsDisplayedInDelivery>
<!--This Configuration setting is managed by Oracle Business Intelligence Enterprise Manager-->
<DefaultRowsDisplayedInDownload>2500</DefaultRowsDisplayedInDownload>
<MaxVisiblePages>2500</MaxVisiblePages>
<MaxVisibleRows>500000</MaxVisibleRows>
<MaxVisibleSections>5000</MaxVisibleSections>
</Table>
</Views>
Restart Presentation Server within EM, verify via export and table run on dashboard.

*Any setting preceded with  "<!--This Configuration setting is managed by Oracle Business Intelligence Enterprise Manager-->" will need to be set in EM as if you change it in the instanceconfig.xml will get overridden as soon as the presentation server is restarted.


**Note the new elements added are the following to both <Pivot> and <Table>; depending on which you want to modify.

OBIEE 11g on IIS 7.0+

I have compiled a list of the helpful post from Oracle that will aid you in deploying OBIEE 11g WLS plugin to IIS 6/7 as well as some helpful posts on setting up Compression and Caching of static files.

http://docs.oracle.com/cd/E23943_01/web.1111/e16435/isapi.htm#BGBBCFID

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

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

OBIEE 11.1.1.6..1 Patch Released

Oracle has release 11.1.1.6.1 patch set; just login to support and search for: 13742915.

Logout Timer on OBIEE BIP 10.1.3.4.1

Needed to set the log off timer on OBIEE 10.1.3.4.1 BIP so our developers could work longer without being asked to login so often. All credit goes to Tim Dexter the author of the post.

https://blogs.oracle.com/xmlpublisher/entry/session_timeouts