Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

Can you use temporary tables in cloud fusion otbi?

in Reporting and Analytics for ERP 2 comments

Summary:

Can we use temporary tables in cloud OTBI as a replacement for multiple union select statements

Content (please ensure you mask any confidential information):

We have a GL report that uses approximately 10 select statements that are unioned together in order to provide one comprehensive report. The resulting query is extremely long running and often runs into snapshot currency errors. I am looking for an alternate approach to deliver the report that will allow it to complete more efficiently and more reliably.

I am used to using temporary tables and loading them sequentially prior to executing a final query as a way of managing performance when I have an on-premise database to work with. I do not know if I can do the same in the cloud-hosted OTBI that comes along with the Fusion AaaS product.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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