Oracle Analytics Named a Leader in the 2025 Gartner® Magic Quadrant™ Oracle Analytics whas been recognized as a Leader in the 2025 Gartner Magic Quadrant for Analytics and BI Platform
Oracle Analytics New Product Roadmap June 2025 Oracle Analytics June '25 roadmap: OAC & FDI updates, fresh look, enhanced features.
Poll: Oracle Analytics Community Website Satisfaction Tell us about your satisfaction with our newly redesigned Oracle Analytics Community Website.

Oracle Analytics Publisher

how to create Global Temporary Tables in fusion BIP report for for Tuning Queries

Question

Views

Comments

Anji Reddy Rank 1 - Community Starter

Oct 11, 2023 6:15AM in Oracle Analytics Publisher

Dears,

Am facing a big problem with long-running queries and running Job's end with an error.

can you please help to Tune the queries and how to use Global Temporary Tables in the BIP report of sub-queries?

we use many sub-queries