OTBI reporting is based on pre-configured subject areas. Oracle provide multiple SAs for respective area which can be used to create an OTBI analysis by drag drop and calculations.
Based on selected SA and columns system generates a logical query, which can be viewed from Advanced => SQL.
Physical query is SQL used to fetch logical query from Oracle DB. Physical query can be view in nqquery.log [Doc ID 1469168.1 - How to generate nqquery.log]
Steps to view physical query
1) Get the logical query
2) Go to Administraton >> SQL Issues >> Paste following line followed by logical query
SET VARIABLE DISABLE_CACHE_HIT=1,DISABLE_PLAN_CACHE_HIT=1;
<<logicalQuery>>
3) Click on view log
Based on selected SA and columns system generates a logical query, which can be viewed from Advanced => SQL.
Physical query is SQL used to fetch logical query from Oracle DB. Physical query can be view in nqquery.log [Doc ID 1469168.1 - How to generate nqquery.log]
Steps to view physical query
1) Get the logical query
2) Go to Administraton >> SQL Issues >> Paste following line followed by logical query
SET VARIABLE DISABLE_CACHE_HIT=1,DISABLE_PLAN_CACHE_HIT=1;
<<logicalQuery>>
3) Click on view log
No comments:
Post a Comment