OBIEE 10G/11G - Presentation Layer

Bi Server Architecture With Client


This is the layer of the logical business model that is accessible for the clients through a structured query language (SQL) better known as the logical sql.

Presentation layer is often describe as the business model in the literature to include the complete logical business model.

The Presentation layer is the appropriate layer in which to set user permissions.

You can export logical keys to ODBC-based query and reporting tools.

You can exclude the key columns because they have no business meaning.

You can create multiple subject areas for a single business model.

It is a best practice to rename objects in the Business Model and Mapping layer rather than the Presentation layer, for better maintainability.

Be aware that members in a presentation hierarchy are not visible in the Presentation layer. Instead, you can see hierarchy members in Answers.


  • Detailed presentation catalogs should include measures from one fact table only as a general rule, as the detailed dimensions (e.g. degenerate facts) are non-conforming with other fact tables
  • You can rename Subject Area, Table and columns with the help of an alias.

Discover More
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...
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 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...
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...
Obiee Presentation Catalog Aliases
OBIEE 10G/11G - Alias (synonyms)

The BI Server offers two type of alias: presentation alias to rename a presentation table / Column physical alias to order and identify the sources When you rename in the presentation catalog...
Saw Object
OBIEE 10G/11G - Answer/Analytics

(Answers 10g|Analyses 11g) is the base component of BI Presentation Service to create Web report . It provides: ad-hoc query and analysis capabilities. The definition of an answer is principally...
Obiee Sa System Presentation Layer
OBIEE 10G/11G - SA System subject area

The users who have worked with Siebel Analytics 7.7 or above, are aware of a special subject area called SA System subject area that was necessary to set up Delivers. With the advent of: the releases...
Bi Server Architecture With Client

This page is how to use Oracle Bi Server as a data source via JBDC. It's possible to make a connection with the presentation layer of the repository through JDBC and to query it via the For a step...

Share this page:
Follow us:
Task Runner