Data Flow Using Oracle Custom SQL instead of Analysis Subject Areas
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!