Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 212 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Need sample SQL to extract all reports in Fusion BI/OTBI reports along with permissions.
User_VFHNI
Rank 1 - Community Starter
We would like to get help in sample sql to create a report in non-prod environment that extracts all the existing reports including Custom and Seeded ones and permissions associated to those reports.
0
Answers
-
Please refer :
As suggested in above discussion, You can try this query :
0 -
Hi VFHNI,
The list of analytics and reports in your catalog in OTBI is available for each application on your documents pages as a sheet to download. For example Financials then . This is not stored in a database table.
You can get the list of things that were run (but not the list of things that were not run)
- To get the list of dashboard prompts and analytics in OTBI executed by users you can select from usage tracking.
2. To get the list of reports executed in OTBI executed by users then you need to enable AudtViewDB.
0
