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 Cloud September 2025 update Empower your team with advanced AI insights, enhanced visualizations, deep customization, and seamless collaboration
Join the Oracle Analytics & AI Community Happy Hour at Oracle AI World! Secure your spot for a limited-seating, private happy hour at Oracle AI World to network with peers and Oracle experts!

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