UI for Logical SQL

Gail Langendorf-Oracle

Description

Logical SQL is a powerful tool that we can use to help us join subject areas that might not otherwise return useful data using the standard cross join analysis. However it is not user friendly and many users can't create logical sql without a technical resource, even after reviewing samples and training videos. Having a business functional end user interface, to assist in creation of logical SQL, would really help customers and increase adoption of OTBI.

Use Case and Business Need

When joining Salary to Assignment or Performance, and many other use cases, it may be necessary to use Logical SQL.
Please see:
https://cloudcustomerconnect.oracle.com/posts/8e9a22fb6d
https://cloudcustomerconnect.oracle.com/posts/132e0068a8
https://cloudcustomerconnect.oracle.com/posts/fc68b59a3b
https://cloudcustomerconnect.oracle.com/posts/de43145427
https://cloudcustomerconnect.oracle.com/posts/c238315b66
https://cloudcustomerconnect.oracle.com/posts/e68146186f
https://cloudcustomerconnect.oracle.com/posts/5884ed4854
https://cloudcustomerconnect.oracle.com/posts/c02be4a127
https://cloudcustomerconnect.oracle.com/posts/d79ae98106
https://cloudcustomerconnect.oracle.com/posts/a0edcf37c1
https://cloudcustomerconnect.oracle.com/posts/5ee5e41623
https://cloudcustomerconnect.oracle.com/posts/5ee5e41623

Original Idea Number: 3dccb24a0e