OBIEE - Federated Query / Multi-Database or Cross-Database Join

Bi Server Architecture With Client


Data can exist in many different places. Instead of moving data to a single database, the BI Server can access multiple databases simultaneously to answer a single query, regardless of whether the databases are from different vendors or what version of database software each runs under.

When the BI Server accesses heterogeneous databases, it handles automatically

  • database operations such as
  • and required transformation, such as:
    • data type casting
    • or applying multiple complex functions.

The BI server can access a large of data sources included XML.

This capability is also called:

  • Federated Query
  • Federation
  • Multi-Database Access
  • Cross-Database Join


An example : OBIEE - Federated Query with Excel Sheet where you have two data source :

  • one Excel used to store the quota
  • an other Oracle where the datawarhouse is located

DWH and OLTP reconciled

A datawarehouse is never completely up-to-date because an extraction is performed periodically.

OBIEE is able to :

  • perform a query against your OLTP application system to retrieve the data from the last extraction
  • perform a query against the DWH system
  • and to merge the two query in on result

Discover More
Essbase Overview
Essbase - Suppression of interdimensional irrelevance by splitting the database

Interdimensional irrelevance occurs when many members of a dimension are irrelevant across other dimensions. Essbase defines irrelevant data as data that Essbase stores only at the summary (dimension)...
Bi Server Architecture With Client
OBIEE - BI Server (OBIS|nqsserver|nqs)

OBI Server is also known as: OBIS (Oracle Business Intelligence Server) or nqsserver (The process name) OBI Server is principally a query and analysis server software: that can integrate data...
Bi Server Architecture With Client
OBIEE - Join

This article talk the SQL joins in OBIEE. You have two ways to define a join in OBIEE: in the repository when you model : in a logical sql statement OBIEE can perform internal join in its...
Bi Server Architecture With Client
OBIEE - Repository Design

... .. A consideration to take when designing a subject area is to pay attention at the final user. Do you design for a user:OBIEE Analytics/Reporting...
Bi Server Architecture With Client
OBIEE 10G/11G - Driving Table

You can specify a Driving table parameter in a complex join. Driving tables are for use in optimizing the manner in which the Oracle BI Server processes cross-database joins when one table is very small...
Obiee Dimension Drill Down Parameters
OBIEE 10G/11G - Level-based Hierarchy

Level-based hierarchy is the first type of hierarchy in OBIEE. Dimension hierarchy levels allow : to perform aggregate navigation, to configure level-based measure calculations, users from Dashboard...
Obiee11g Bip Security Center Roles
OBIEE 11G - Installation Sample Application version 825

edit the “” Save the file. Login to the EM administration screen using the url Expand 'Business Intelligence' > Coreapplication > Deployment > Repository Click...

Share this page:
Follow us:
Task Runner