OBIEE 11.1.1.6.4 Patch Set Released

Oracle has released OBIEE Patch Set version 11.1.1..6.4 see link below:

https://support.oracle.com/epmos/faces/ui/km/DocumentDisplay.jspx?_afrLoop=475184249870602&id=1493687.1&_afrWindowMode=0&_adf.ctrl-state=7a125ti03_57

OBI 11g Agent Message:DEVICE (DASHBOARD) IS NOT SET IN (USER) DELIVERY PROFILE

After upgrading 10.1.3.4.1 environment to 11.1.1.6.1 when I was running any Agent I got this following warning when the Agent ran: DEVICE (DASHBOARD) IS NOT SET IN (USER) DELIVERY PROFILE

so after talking to support via a SR it was determined that this was fixed in 11.1.1.6.2. BP1; that is a big negatory Ghost Rider you have to get the following patch to fix the issue: Patch # 13972011. Only caveat is you have to have patch 13867143 before you can install it. And Patch 13867143 is the # 6 of 7 patches for 11.1.1.6.2 BP1. So update to 11.1.1.6.2 BP1 then apply this patch.

Charts and Graphs stop displaying after 11.1.6.2 BP1 Upgrade

I was very excited to see that Oracle released the 11.1.1.6.2. BP1 patch for OBIEE. And I had the opportunity to install the patches to fix some bugs I had seen in one of our environments. After the upgrade some of out charts and graphs stopped displaying. Man two steps forward one step back....Took a stroll through Oracle Support and found out that there is a extra step some user have to do if they are using custom styles/skins. More in on steps at Oracle support search for Doc ID 1474605.1. Below is a snapshot of the steps to fix the issues taken directly from the Oracle doc:

Section 6: Post-Installation Instructions

-----------------------------------------

Section 6.1: Copying BIChart.swf To Custom Directories

The Oracle white paper "Customizing Oracle Business Intelligence Enterprise Edition 11g" describes how to customize BI Presentation Services by storing custom skins, styles, and messages in a custom directory.

If the BI System has been customized as described in the white paper and custom skins are stored in one or more custom directories, follow the additional instructions below to complete the 11.1.1.6.2 BP1 patchset installation:

1. Go to the following directory:
   <Oracle BI Home>\bifoundation\web\app\res\sk_blafp\dvt
2. Verify that the BIChart.swf file in that directory:
      - has a size of 457KB (466,944 bytes)
      - has a date of 6/4/2012
3. Copy the BIChart.swf file to each custom directory in the BI System, replacing the existing file of that name:
   For example, on Windows, you might copy the BIChart.swf into the following custom directory:
      c:\prod_mwhome\Oracle_BI1\bifoundation\OracleBIPresentationServicesComponent\coreapplication_obips1\analyticsRes\sk_mylookandfeel\dvt
4. Stop and restart the BI Presentation Services system components.
   
   
5. Clear the browser cache.

Issues with "Hide Column" Feature in OBI 11.1.1.6.1

There a issue in OBIEE 11.1.1.6.1 release around using the "hide" column feature, issue was when you clicked to hide a column it hid the one beside it. As in lets say you have three columns A/B/C you click to hide column B and it hides column A. There was a Bug logged as BUG 13963768. Found that the fix for this was in 11.1.1.6.2 BP1; more precisely the patch folder 6 of 7 in the list of 7. I have verified it is fixed in the .2 BP1 release. Love it when a patch actually fixes a issue...

Freeze Frames in OBI 11.1.1.6.x

Finally we have the "freeze pane" option that many users have asked for for years.......Below is the changes needed in instanceconfig.xml:

<Views>

<GridViews>

<DefaultScrollingEnabled>true</DefaultScrollingEnabled>
<DefaultRowFetchSlicesCount>500</DefaultRowFetchSlicesCount>
<DefaultColumnFetchSlicesCount>50</DefaultColumnFetchSlicesCount>
<DefaultFreezeHeadersClientRowBlockSize>40</DefaultFreezeHeadersClientRowBlockSize>
<DefaultFreezeHeadersClientColumnBlockSize>30</DefaultFreezeHeadersClientColumnBlockSize>
</GridViews>
</Views>

Details on what each item means:


DefaultScrollingEnabled - Turns on or off scrolling for all pivot or table views.
DefaultRowFetchSlicesCount - Set the "up to" how many rows to fetch server side for determining the scrollbar height for freeze headers.
DefaultColumnFetchSlicesCount -  Set the "up to" how many columns to fetch server side for determining the scrollbar (across) width for freeze headers.
DefaultFreezeHeadersClientRowBlockSize - Sets how many rows to fetch in one block for freeze headers.
DefaultFreezeHeadersClientColumnBlockSize - Sets how many columns to fetch in one block for freeze headers.

There is a post on OTN with the same:

https://forums.oracle.com/forums/thread.jspa?threadID=2395998&tstart=165

Case Insensitivity in OBIEE 11g prompts

Had a request to turn on the case insensitive searching in OBIEE 11g today here is how you do it:

1. Add the following entry in instanceconfig.xml: located at

\<MW Home>\instances\<yourinstancename>\config\OracleBIPresentationServicesComponent\coreapplication_obips1
<QueryManager>
<CaseInsensitiveMode>true</CaseInsensitiveMode>
</QueryManager>

Save Instanceconfig.xml file.

2. Open the NQSConfig.ini located in \<MW Home>\instances\<yourinstancename>\config\OracleBIServerComponent\coreapplication_obis1 and search for CASE_SENSITIVE_CHARACTER_COMPARISON and change this values to OFF as shown below.
CASE_SENSITIVE_CHARACTER_COMPARISON = OFF;
Save NQSconfig.ini file.

3. Restart All OBIEE services.
4.Verify setting has taken affect.

NQSConfig.ini Error "EVALUATE_SUPPORT_LEVEL "

Working on OBIEE 11.1.1.6.1 today and got the following error on a dashboard "[nQSError: 43113] Message returned from OBIS. EVALUATE_SUPPORT_LEVEL inside NQSConfig.INI is not set to support EVALUATE. (HY000)" What in the world? So I go do a search in the NQSConfig.ini and Wow! Where did this config addition come from:


# EVALUATE_SUPPORT_LEVEL:
# 1: evaluate is supported for users with manageRepositories permssion
# 2: evaluate is supported for any user.
# other: evaluate is not supported if the value is anything else.

EVALUATE_SUPPORT_LEVEL = 0;

Changed setting to = "2" and all is fine, now off to figure out where that came from and what it is doing in the NQSConfig now..

* Just as a note this setting came in with 10.1.3.4.2....Guess I never had the issue with SampleApp...ugh.

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

OBIEE 11g: Error: "Your browser is not supported by Oracle BI Presentation Services"

When using Firefox 10 browser you may see the error: "Your browser is not supported by Oracle BI Presentation Services" There is now a patch from Oracle for this issue just login to Oracle Support and look for DocID: 1407163.1. The details of the patch in in this doc.