Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 34 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 273 Oracle Analytics and AI News
- 48 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.3K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 100 Oracle Analytics and AI Trainings
- 16 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
list of the reports from the catalogue that are using direct database request
How can we get the list of the reports from the catalogue that are using direct database request? I have tried using the catalog manager tool for the same, but could not find the exact key word to get the report
Answers
-
I am not aware of any option for that specific type request, off-hand with Catalog query.
You would likely need to search the XMLPerhaps if you are trying track down who is using it, then check and see which users/roles are assigned the privileges required for direct database requests (I'm guessing at your end goal use case).
Other comments, welcomed.[EDIT:
I missed you have posted in an older thread. There are answers there that should answer your question.
]1 -
@Sindhu -Oracle , what product (name and version) are you using?
That could change a lot of things, mostly because in recent version catalog manager can't be run in offline mode, therefore you maybe don't have the rights to search for that everywhere but just in a limited place of the catalog.
0 -
0
-
Ok, that's the catalog manager version, but what product and version is your catalog from? Are you on some OBIEE version?
0 -
Direct database requests have their own xsi type.
You can simply search for xsi:type="saw:physicalCriteria". The XML will contian this string and it pulls out a list of all the DDR objects.
1
