OBIEE - Database Features Parameters

Bi Server Architecture With Client


When you create a database in the OBIEE physical layer some databases features parameters are automatically checked depending on the type of your database.

You can find the type in the database section of the database object.

This features are mostly parameters that control the generation of the physical query.

Obiee Database Features

When a feature is marked as supported (checked) in the Features tab of the Database dialog, the Oracle BI Server typically pushes the function or calculation down to the data source for improved performance. When a function or feature is not supported in the data source, the calculation or processing is performed in the Oracle BI Server.

The supported features list in the Features tab uses the feature defaults defined in the DBFeatures.INI file.


The syntax of the parameters is “the_feature_SUPPORTED”



Type of features

Database operations/functions

If the database is able to perform the database operations (Left outer join, Right outer join, …) or some functions (AVG, MIN, MAX, …) for the two first. If one feature is not supported (not checked), OBIEE will performed it and act then as a database engine.

Generation of the SQL issued

How to generate the Physical SQL issued:


Example: OBIEE - How to control the use of the WITH CLAUSE and of STITCH Join ?

Some features even enabled and pushed out to the underlying database may slow the query. For instance, ROWNUM is a supported feature of Teradata but significantly decrease the query performance.

Default values

The default value are defined in the file Oracle_Bi_Home\server\Config\DBFeatures.INI and you can change them:

Obiee Database Source Definition

Documentation / Reference

Discover More
Obi Edition
OBIEE - Calculation

A Pass-through calculation is not computed by the Oracle BI Server but is passed to another data source. Enables advanced users to leverage data source features and functions without the need to modify...
Obiee Connection Pool
OBIEE - Connection Pool

This articles regroups all the articles and talk the connection pool features of the BI Server such as: the connection script tab ... see below 10G 11G To automate connection pool changes...
Obiee Database Object
OBIEE - Database Object

The database object in the physical layer of the three-layer metadata model. Database define the default features of the database. The virtual Private Database check box identifies the physical...
Bi Server Architecture With Client
OBIEE - Fact-based vertical partitioning/fragmentation

This technique allow you to : mix two facts table with two different grains (the level based partitioning) perform a densification (to preserve dimension value) : partition vertically your fact...
Obiee Logical Join Bmm
OBIEE - Full outer Join

To perform a , you have two ways : in the repository by using the fact vertical partitioning capabilities or with the Obiee logical sql To know what sort of join is a full outer join, follow this...
Bi Server Architecture With Client
OBIEE - How to control the use of the WITH CLAUSE and of STITCH Join ?

The physical sql issued when you have designed a vertical fragmentation depend of several database features parameters: PERF_PREFER_MINIMAL_WITH_USAGE: if checked, the WITH clause is not used PERF_PREFER_INTERNAL_STITCH_JOIN:...
Obiee Opaque View
OBIEE - Opaque View

An opaque view is in the physical layer a physical table that consists of a Select statement . In the repository, opaque views appear as tables in the physical layer but the view does not actually exist....
Bi Server Architecture With Client

PERF_PREFER_INTERNAL_STITCH_JOIN is a database feature parameter. This parameter controls where a full outer join is performed. If it's checked, the full outer join is performed by BI Server (See stitch...
Obiee Query Log
OBIEE - Physical SQL

The physical SQL is the SQL that send the BI Server to the data sources in order to retrieve data. This SQL is most of the time generated by the query compiler during the query processing of the logical...
Obiee Pivot Measures
OBIEE - Pivot Measures (The Filter Function)

Indicator, description of Measures are generally the sign that you need to pivot your measure (i.e. to create a Pivot Measure) The revenue is booked. Revenue is the measure and booked is a description...

Share this page:
Follow us:
Task Runner