Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Updating non-logical OTBI to Logical SQL OTBI without rebuilding? — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Updating non-logical OTBI to Logical SQL OTBI without rebuilding?

Received Response
18
Views
3
Comments
edited Jan 17, 2021 9:29AM in Reporting and Analytics for ERP 3 comments

Summary

Updating non-logical OTBI to Logical SQL OTBI without rebuilding the original OTBI?

Content

I need to update an existing OTBI (non-Logical SQL) to use Logical SQL and finding out how to do this without rebuilding the whole OTBI from scratch is quite a challange.

My analysis to update just contains "Payables Invoices - Transactions Real Time" SA and my change is to include the {check date} from "Payables Payments - Disbursements Real Time". Using a join between the 2 subject areas would yield only paid invoices and I need to pick up Paid and Unpaid invoices and hence the need for an outer join between the subject areas and hence Logical SQL.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!