OBIEE - Physical Layer

Bi Server Architecture With Client


The physical layer is the layer of the Logical Business Model where you define the physical data model of your data source. It contains information about the physical data sources.

The most common way to create the schema in the Physical layer is by importing metadata (table, view, …) from databases and other data sources. If you import metadata, many of the properties are configured automatically based on the information gathered during the import process. You can also define other attributes of the physical data source, such as join relationships, that might not exist in the data source metadata.

From 11g, importing physical objects from an Oracle Database can be done through a Oracle Call Interface (OCI)

Best Practices

  • Always use Foreign Key joins and not a Complex Joins when you deal with a simple predicate in the expression field such as
table1.foreign_key_column = table2.primary_key_column
  • When modelling a star-schema data-model, create aliases for all your physical tables prefixed with:
    • a letter to indicate the database (data source)
    • a number to set the position
    • and either “Dim_”, “Fact_” or “Fact_Agg_”
  • When possible, configure your connection pools to use a “native driver” to connect to your physical databases. For example, use OCI for connecting to an Oracle database rather than ODBC.

Creating Physical Layer Catalogs and Schemas

Catalogs are optional ways to group different schemas. A catalog contains all the schema (metadata) for a database object. A schema contains only the metadata information for a particular user or application. Model the physical layer after the way your database is structured.

A database can have either catalogs or schemas but not both.

If your database has one or more schemas, you cannot create a catalog. If your database has one or more catalogs, you cannot create schemas.

You must create a database object before you create a catalog object or a schema object.

Documentation / Reference

Discover More
Obiee 11g Connection Pool Connection Script Timesten
OBIEE - Aggregate Persistence (Script)

The Aggregate Persistence functionality is the ability to: create and populate aggregate tables, and map them to the metadata repository in order to use the aggregate navigation capability of the...
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 Connexion Alter Nls Date Format
OBIEE - Connection Script

The connection pool of the physical layer gives the possibility in the Connection Script tab to execute a command script: on connect before query after query on disconnect You can call...
Obiee Database Features
OBIEE - Database Features Parameters

When you create a database in the OBIEE physical layer some databases features parameters are automatically checked depending on the type of your database. database section This features are mostly...
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...
Obiee Foreign Key Complex Join
OBIEE - Foreign Key or Physical Join

A foreign key repository join is used only to define a Primary Key-Foreign Key Relationships in the Physical Layer. It consist of a column or a set of columns and refers to the primary key column in...
Obiee Repository Qualified Name
OBIEE - Fully Qualified Name Object Identifier (Object Path)

The fully qualified is an object identifier within the repository. This identifier is the only reference you need to give when creating a new object. The others two object identifiers id and upgrade...
Bi Server Architecture With Client

ODBC ODBC is closer related to the BI Server. It uses it to: retrieve data from data source in the back-end through the physical layer but also to expose the presentation catalog of BI Server as...
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....
Logical Business Model
OBIEE - The Business Model and Mapping (BMM)

The Business Model and Mapping layer (known also as Business Model): is the layer in the middle of the logical business model. permit to model logical dimensional models which are a reorganization...

Share this page:
Follow us:
Task Runner