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!

Welcome to the Oracle Analytics Community

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Comments

Hi @Mallikarjuna Kuppauru-Oracle , yes we defined the Variable in the Data Model level. And regarding the role, that is where we are facing the issue. If there are limited roles provisioned to the session user, then the query is working and returns results only if the session user has the role which is predefined in the…

in Bi Publisher Data model returning error when run, after using system variable in the sql query. Comment by Bishal Dutta Feb 27, 2024 5:40PM