OBIEE - The Business Model and Mapping (BMM)

Bi Server Architecture With Client


The Business Model and Mapping layer (known also as Business Model):

The logical schema defined in each business model must contain at least two logical tables. See OBIEE - Single table model.

The Business Model and Mapping layer organizes information by business model (sort of folder). Each business model contains logical tables. Logical tables are composed of logical columns. Logical tables have relationships to each other expressed by complex logical joins. The relationship between logical columns can be hierarchical, as defined in business model hierarchies. Logical tables map to the source data in the Physical layer. The mapping can include complex transformations and formulas.

The Business Model and Mapping layer defines the meaning and content of each physical source in business model terms.

The logical schema defined in each business model needs to contain at least two logical tables: OBIEE - Single table model.

During the design process of your logical model, you have to define:

Because they mirror the way people think about business information, dimensional model (star or snowflake model) can be understood by non-technical business analysts.

Its server-side capabilities, together with its data modeling capabilities, provide that bridge, which allows simple SQL to pose complex business questions, regardless of where the data is physically located and independent of the physical model in which the data is stored.

Logical Business Model


A business model need at least:

  • one logical fact table
  • and one logical dimension table

See OBIEE - Single table model. to understand how you can model a business model from a single table.


Discover More
Logical Business Model
OBIEE - Common Enterprise Information Model (CEIM) - The Logical Business Model (the three-layer metadata model)

The Logical Business Model is the three-layer metadata model of the repository and its aim is to build a known also as a model-centric view (as compared to report-centric view of information). Each layer...
Obiee New Complex Join
OBIEE - How to define a One to Many Relationship

How to model a One to Many Relationship in OBIEE ? Starsnowflake schemasdimensional schemaone-to-many relationshipsdimension tablesfact tables You must in the logical business model from OBIEE designed...
Bi Server Architecture With Client
OBIEE - Single table model.

For the greatest simplicity, you could construct a subject area that consists of a single table. To create a single table model, you first create a logical dimensional model in the business model layer,...
Obiee 11g Subject Area Bmm Create
OBIEE - Subject Area / Presentation catalog

A subject area in Presentation Service is equivalent to a presentation catalog in BI Server. In 10g, a difference was made between: a subject areas in the Presentation Service a presentation catalog...
Exp Builder Ago Td
OBIEE - Time Series Conversion Functions : AGO and TODATE

Time series functions in OBIEE. The implementation of the time serie function is based on the time dimension. ( See set up time dimensions) At query time, the Oracle BI Server then generates SQL that...
Obiee Foreign Key Complex Join
OBIEE 10G - Complex (Join|Operator) (Physical and Logical)

In 10g, A complex join is a metadata of sql join statement in the repository. In 11g, they doesn't exist anymore. In the business model, OBI recommends using complex logical joins instead of foreign...
Obiee Multiple Dimension Hierarchie
OBIEE 10G/11G - Dimension Hierarchy (logical dimensions)

(Dimension hierarchies|Logical Dimensions|Hierarchy) introduce formal hierarchies into a business model. They are created in the Business Model and Mapping layer. Before 11g, end users can't see them...
Obiee Bridge Schema
OBIEE 10G/11G - How to model a bridge table (Many-to-Many relationship) with the joins property of a Logical Table ?

Dimensional Schemas (Star and snowflake schemas) work well for modeling a particular part of a business where there are one-to-many relationships between the dimension tables and the fact tables. However,...
Obiee11g Time Dimension Property
OBIEE 10G/11G - How to set up the time dimension (for time series functions Ago, Todate, ) ?

Oracle BI Server ships Time Series Conversion Functions : AGO and TODATE. They are supported for all relational database and for use with Essbase. They are not support for flat files. To use them on...
Obiee Foreign Key Complex Join
OBIEE 10G/11G - Logical Join

A logical join is a join defined in the BMM layer. He is defined between a logical fact table and a logical dimension table. Two types of logical join exists: standard logical join logical foreign...

Share this page:
Follow us:
Task Runner