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?

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!