OBIEE - Physical SQL

Bi Server Architecture With Client

About

Obiee Query Log

The physical SQL is the SQL that send the BI Server to the data sources in order to retrieve data.

This SQL is most of the time generated by the query compiler during the query processing of the logical sql created by a client tool generally through an answer (Advanced Tab).

You can retrieve it in the nqquery.log file. And one common way to see this file on-line, is to use the session manager of Presentation Service : OBIEE 10G/11G - How to see the Physical SQL generated by a request in Presentation Service ?

Subqueries

Sub-queries may be generated by the BI Server when

Execute

It's possible to execute directly a Physical SQL written by hand with the EXECUTE PHYSICAL statement through a BI Server Client. 

EXECUTE PHYSICAL CONNECTION POOL "DatabaseName"."ConnectionPoolName" select count(*) from myTableName




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...
Bi Server Architecture With Client
OBIEE - BI Server Clients (ODBC, JDBC)

The Open interface of BI Server gives the possibilities to made a client connection throught ODBC and JDBC. Clients of the Oracle BI Server see a logical schema view independent of the source physical...
Obiee Baseline Column
OBIEE - Baseline column

in OBIEE. A baseline column is a column unlike the measure column that has no aggregation rule defined in the Aggregation tab of the Logical Column dialog in the repository. The BI Server don't see...
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...
Bi Server Architecture With Client
OBIEE - EXECUTE PHYSICAL CONNECTION POOL Statement

The EXECUTE PHYSICAL CONNECTION POOL Statement permit you to execute Physical SQL statement from a BI Server Client where: myConnectionPool is the fully qualified name of a connection pool (ie...
Bi Server Architecture With Client
OBIEE - Fact-based vertical partitioning/fragmentation

This technique allow you to : mix two facts table with two different grains (the level based partitioning) perform a densification (to preserve dimension value) : partition vertically your fact...
Obiee Fragmentation Content One Column
OBIEE - Grain - Level of (summarization|aggregation)

Grain definition in the context of OBIEE. The following list describes the different grains in navigating a query: Query grain. The grain of the request. Aggregation grain. The grain of the aggregate...
Bi Server Architecture With Client
OBIEE - How to control the use of the WITH CLAUSE and of STITCH Join ?

The physical sql issued when you have designed a vertical fragmentation depend of several database features parameters: PERF_PREFER_MINIMAL_WITH_USAGE: if checked, the WITH clause is not used PERF_PREFER_INTERNAL_STITCH_JOIN:...
Obiee Ceim
OBIEE - Logical Sql

The logical SQL is the SQL that understand BI Server. It's a full Ansi 92 SQL (including subqueries and derived tables), plus special functions (SQL extensions) like AGO, TODATE, EVALUATE, and others....
Obiee Pivot Measures
OBIEE - Pivot Measures (The Filter Function)

Indicator, description of Measures are generally the sign that you need to pivot your measure (i.e. to create a Pivot Measure) The revenue is booked. Revenue is the measure and booked is a description...



Share this page:
Follow us:
Task Runner