Oracle Analytics Cloud and Server Idea Lab

Home› Oracle Analytics› Oracle Analytics Idea Labs› Oracle Analytics Cloud and Server Idea Lab

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Generate physical SQL in OBIEE without running Analysis

Needs Votes
32
Views
2
Comments
Steve Boyce
Steve Boyce Rank 1 - Community Starter
in Oracle Analytics Cloud and Server Idea Lab

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

Tagged:
4
Up
4 votes

Needs Votes · Last Updated

Comments

  • Doug Ross
    Doug Ross Rank 6 - Analytics Lead

    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
    Steve Boyce Rank 1 - Community Starter

    Ha!  Brilliant!  Thanks!