Resolving workbook query errors in Oracle Analytics Cloud helps ensure users can access visualizations by providing access to the datasets those workbooks depend on. This tutorial shows how to identify inaccessible related items, move datasets to shared locations, and support reliable workbook access across teams. Explore additional training and benefits at the resources linked below.
This tutorial explains how to fix workbook query errors in Oracle Analytics Cloud that occur when users can access a workbook but do not have permission to access its underlying datasets. The walkthrough begins with creating a workbook that uses a dataset stored in My Folders, a private location that is not automatically available to other users. During the sharing process, Oracle Analytics Cloud displays a related items warning that highlights assets that workbook consumers cannot access. The tutorial demonstrates how to review these warnings, identify inaccessible datasets, and move those assets from My Folders into Shared Folders so authorized users can query the data successfully. It also explains that datasets do not need to reside in the same folder as the workbook, provided consumers have permission to access them. By organizing datasets in shared locations and understanding how related item permissions work, teams can reduce access issues, improve collaboration, and ensure visualizations load correctly for workbook consumers.
Find training paths for Oracle Analytics and AI from beginner to advanced and expert: https://social.ora.cl/6008B8XaPm
Explore self-paced short courses in the Oracle Analytics and AI Learning Hub: https://social.ora.cl/6009B8Xaul
How to share your content: https://social.ora.cl/6009B8XaRt
How to manage datasets: https://social.ora.cl/6003B8XapD
How to assign shared catalog folder and workbook permissions: https://social.ora.cl/6005BDGgQf
How to move catalog folders and contents: https://social.ora.cl/6009BDGgxZ
00:00 Introduction to Workbook Query Errors
00:30 Create a Workbook with Private Data
01:21 Move Dataset to Shared Folders
01:57 Validate Consumer Access
Like what you learned about Oracle Fusion AI Data Platform? Subscribe now https://social.ora.cl/60025k87j
Join us at Oracle AI World: https://social.ora.cl/60035eVvJ
Contact AIDP sales: https://social.ora.cl/6003FLUMT
Learn more about Oracle AIDP: https://social.ora.cl/60047h76Q
Join the Oracle AIDP Community: https://social.ora.cl/60087h7Bj
Follow us here:
LinkedIn: https://social.ora.cl/60035eXuF
X: https://social.ora.cl/6008abVgG
Instagram: https://social.ora.cl/60095eXDN
Facebook: https://social.ora.cl/60065enQp
