CODEWITHSUNDEEP
oracle-databaseobiee
Rahul Patel
Rahul Patel

Reputation: 317

Do we have any way to get OBIEE server analysis physical query?

Do we have any way to get OBIEE server analysis physical query?

we can get OBIEE server analysis physical query from logs of Usage Tracking in which Session ID is embedded in the front.

I would like to compare Physical SQL statement(s) associated with the analysis/dashboard and i don't want to use logs of Usage Tracking. This task i am going to do pragmatically (Java).

I am using Oracle BI 12C server.

Upvotes: 0

Views: 2779

Answers (1)

Chris
Chris

Reputation: 2752

Physical SQL is in Usage Tracking. If you insist on doing it programmatically through he application abstraction layer then you are talking about LSQL - logical SQL - because you work with the RPD and NOT the sources themselves!

Have a look here: https://www.rittmanmead.com/blog/2014/01/automated-regression-testing-for-obiee/

Edit: If you just want to generate the physical SQL without actually executing it against the source you can do that by calling another request variable in your LSQL:

set variable SKIP_PHYSICAL_QUERY_EXEC=1;

https://www.rittmanmead.com/blog/2015/03/obiee-nqcmd-tidbits

Upvotes: 0

Related Questions