OBIEE 11G - SELECT_PHYSICAL statements

> Reporting and Data Access Tools > Oracle Business Intelligence (OBIEE/Siebel Analytics) > OBIEE - BI Server (OBIS|nqsserver|nqs) > OBIEE - Logical Sql

1 - 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.

3 - 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.

Advertising

4 - Documentation / Reference