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.

OLAP Operations

OLAP Operations

Slice
Dice
Roll Up
Drill Down
Pivot

OLTP Vs. OLAP Databases

Most businesses use Online Transaction Processing (OLTP) databases to gather and store the records generated by their daily operations. Typically, OLTP databases execute transactions, meaning that they add, update, or delete groups of records at the same time.

 For example, the database for a grocery store inserts and updates information about prices, purchases, and costs of goods and freight, usually at lightning speed.

Database Type Setting in OBIEE 11G RPD

Dear All,


When we design the RPD, we always focus on implementing the business concepts but we forget to work on  the basic repository features.

One of the cases, is the  Database Setting.

The database type has not been correctly defined in the database object in the physical layer.

OBIEE 11G: Perfomance Tuning

Dear All,

Most of us, who is/are familiar with the Business Intelligence Reporting Tools , may be familiar with Oracle Business Intelligence Enterprise Edition (OBIEE) 11g version. OBIEE 11G is widely used in industry as the reporting tool. OBIEE 11g provides many new features compared to its previous versions.

But the important factor, when we develop the logic and build the analysis is to keep tracking of its performance. Building the report is not the big task, but to build good performing dashboards is the ultimate need of this dynamic industry. A well timed reports could help the users to take the decisions in time.

Please find below some of the steps which can comparatively reduce the execution timing, hence improving the dashboard performance.

• Turn off query logging in OBIEE
• PERF_PREFER_MINIMAL_WITH_USAGE Database Feature
• Setting number of elements for hierarchies in RPD
• Timeout and Max Connection Settings for Connection Pooling
• Foreign key joins by varchar fields to be replaced by surrogate keys
• Using aggregate tables for performance improvement
• Redundant views to be removed from reports
• Pivot Table vs. Table View