nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Generate physical SQL in OBIEE without running Analysis

Steve Boyce

Organization Name

Rakuten Advertising

Description

Often, we would like to view generated physical SQL for an Analysis before it is issued to the Database. It would be desirable to have a method to do so.

Use Case and Business Need

Being able to view physical SQL before it is sent to the database would prevent ill-formed or incomplete queries to be sent to the database. Also when trying to see the results to physical queries after making DB Feature changes, would allow for much more rapid trial and error attempts and would again avoid un-optimized SQL for being sent to the database, which in extreme cases needs to be killed.

Original Idea Number: f4e57dcbb0

Find more posts tagged with

Reporting

Analysis and Data Visualization

Developers

Needs Votes

Status: Needs Votes

Comments

Doug Ross

While not a perfect solution, I tried this as a test:

Add a SQL filter to the analysis by clicking on any column in the criteria, add filter, convert to SQL and then change the SQL to say "1 = 0"

It adds the 1=0 to the WHERE clause and in the test I ran, a query that took about 4 minutes to run initially, came back immediately with

the 1=0 and the SQL was the same except for that additional filter.

Again, this was just an idea I tried out quickly.

Steve Boyce

Ha! Brilliant! Thanks!