Logical SQL more comparable to Oracle SQL

Karen Costakes

Description

Many times OTBI  logical sql is needed to pull the appropriate data from the subject areas and join multiple subject areas as needed into one subject area.

However, using logical sql can be tedious and daunting based on syntax requirements and the need to alias tables multiple times.  It would be incredibly helpful if logical sql more closely resembled Oracle SQL or if there was a very detailed document on certain 

Use Case and Business Need

Many times business users that know how to use OTBI, but can't get all of the data they need from one subject area (IE they need data from benefits and payroll).  They can create separate OTBI analysis to get the appropriate data, but when they combine them, the way they are joined is not what is needed.   They could use logical sql, but it is tricky because it has some idiosyncrasies in required syntax that make it even more challenging than a standard BI publisher report - making it inaccessible to most users.

Original Idea Number: 9c57822b2f