New Features in the Oracle Business Intelligence Suite Bundle Patch 11.1.1.7.1

New Features in the Oracle Business Intelligence Suite Bundle Patch 11.1.1.7.1

• Enforce Limits Per Logical SQL Query
• Support for TimesTen Parallel Insert

OBIEE 11g: How To Display The Difference Between Two TimeStamp Dates As HH:MM:SS?

You have cases where end users need to display the difference between two time stamp date columns in the format HH:MM:SS.
End-users may find it complex to use the TimeStampDiff function to get the desired output.

TimeStampDiff is the out of the box function that returns the total number of specified intervals between two timestamps.

To display the difference between two time stamp date columns in the format HH:MM:SS, use the following syntax:

How to display OBIEE content in iFrame?

On : 11.1.1.5 [1900] version, Analytics

When attempting to embed an Analytics Dashboard into a Siebel View the following error occurs:-

"OBIEE content can not be displayed in the iframe"

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Perform a Siebel CRM 8.1.1.3 Integration with OBIEE 11.1.1.5
2. Add an OBIEE Dashboard to the Siebel View
3. Navigate to the Siebel View/Screen and error is displayed
The issue was resolved by performing the following steps:-

How To Clear / Purge The OBIEE 11g Repository Cache Via An Automated Scripted Command-line?

This document describes a method to clear the OBIEE 11g repository cache via an automated command-line script.

This examples shows how to purge all the cache entries on Linux/Unix , for other options see the documentation. For Windows, modify the paths and use .bat files.

How to enable or disable the cache in OBIEE 11g?

FOR TURNING OFF SERVER CACHE IN OBIEE 11G
The following configuration setting of NQSConfig.INI file, is managed by Oracle Business Intelligence Enterprise Manager.

[Cache]
ENABLE = YES

If you change this entry directly in NQSConfig.INI file then it will revert to the original value whenever you restart the BI server.
The possible solution is given below:

How to Remove Recent and Most Popular dashboard links on the OBIEE home page?

In one of our application, we faced an issue raised by the users.

The OBIEE home page, shows the most recent and the most popular dashboards/reports. The users wanted to remove that part. After many hit and trial, we got the workaround from the Oracle.

[nQSError: 43113] EVALUATE_SUPPORT_LEVEL inside NQSConfig.INI is not set to support EVALUATE

EVALUATE_SUPPORT_LEVEL is missing in NQSConfig.INI

In one of our application in real time project, we faced the below error in our reports:
"OBIS. EVALUATE_SUPPORT_LEVEL inside NQSConfig.INI is not set to support EVALUATE"

We had upgraded our OBIEE version from 11.1.1.5 to 11.1.1.7. But in all the reports, where we had used evaluate function, we were facing the error.