OLAP Operations
Slice
Popular Posts
-
By default, the report links (such as Refresh, Print, Export etc.) are displayed below the results at the bottom of the page when an analys...
-
Dear All, In this post, we are stating step by step procedure to start OBIEE 11G Services. Please follow the order as instructed:
-
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 dashboa...
-
This document describes a method to clear the OBIEE 11g repository cache via an automated command-line script. This examples shows how to...
-
Dear All, In this post, we are posting the set of questions, asked in the 1z0-146 exam.
Sunday 20 October 2013
Monday 14 October 2013
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.
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.
Saturday 12 October 2013
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.
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.
Friday 11 October 2013
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.
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
Subscribe to:
Posts (Atom)