OBIEE 11G - SELECT_PHYSICAL statements

Obiee Ceim

OBIEE 11G - SELECT_PHYSICAL statements

About

SELECT_PHYSICAL statements provide the functionality:

  • to directly query objects in the Physical layer of the metadata repository,
  • and to nest such a statement within a query against the Business Model and Mapping layer or the Presentation layer.

BI ODBC Driver

Oracle BI Server clients can create a dedicated physical connection to the Oracle BI Server over which all SELECT queries are treated as SELECT_PHYSICAL queries. SELECT_PHYSICAL queries directly query objects in the Physical layer of the metadata repository, bypassing the Presentation layer and the Business Model and Mapping layer. To enable this direct connection for your ODBC client, select Route Requests To Physical Layer in the DSN configuration of the Analytics ODBC driver

Note that you cannot have a single ODBC connection that sends queries to both the Presentation layer, and the Physical layer. Instead, you can create one regular connection that sends requests to the Presentation layer, and one connection that sends requests to the Physical layer.

Documentation / Reference





Discover More
Obiee11g Architecture Functional Component
OBIEE 11G - New Features and changes 11G

Oracle Business Intelligence Enterprise Edition (OBIEE) 11g is the most significant release of OBIEE since 2006. This article contains the significant changes and new features of OBIEE 11g. Oracle...



Share this page:
Follow us:
Task Runner