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 Cloud and Server

how to switch data source at runtime in bi reports

Question

Views

Comments

user560751 Rank 1 - Community Starter

Feb 26, 2021 12:47AM edited Aug 13, 2024 7:10PM in Oracle Analytics Cloud and Server

Hi,

I have a query how to switch data source of Oracle Bi Publisher report at run time any suggestions.

I have a oracle database with multiple schemas. the data will split as per year in a separate schemas. I want to call a report from apex and pick data from selected schema. for example if i have login in 2019 data then it connect with 2019 schema and show me 2019 data in a report.

Thanks

MFA for Oracle Community

Oracle Analytics Cloud and Server

Categories

how to switch data source at runtime in bi reports