Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 17 Oracle Analytics Lounge
- 222 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.8K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 83 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations 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
