Oracle Analytics Cloud and Server

Products Banner

Data Flow Using Oracle Custom SQL instead of Analysis Subject Areas

Received Response
94
Views
4
Comments

Content

I am trying to build a data flow in Oracle Analytics Cloud. When I connect to our Salesforce for example, the Data Flow UI shows "Enter SQL" and allows for actual custom SQL queries referencing direct database tables. But when I connect with the "Oracle Applications" connector to our OTBI /analytics/ URL I use the only option in the UI is "Enter Logical SQL" or selecting Subject Areas which does not work for my needs, I need to enter direct physical SQL not Logical SQL.

How can I connect to Oracle Financials In The Cloud in OAC Data Flows to query using custom SQL not analyses? thanks!

Version

OAC 4, Financials In the Cloud R12

Answers