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
I am not aware of any option for that specific type request, off-hand with Catalog query. You would likely need to search the XML
Perhaps 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.
]
@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.
@Gianni Ceresa
I have accessed the catalog manager offline and trying to check
Ok, that's the catalog manager version, but what product and version is your catalog from? Are you on some OBIEE version?
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.
Description: Join the OCI Enterprise AI Product Management team for a deep dive into the latest product roadmap updates and upcoming innovations. During this webinar, we’ll cover key roadmap highlights, showcase product demos, and share insights into what’s ahead for OCI Enterprise AI. The session will conclude with a live…
Hi! I am looking for audit logging for Analytics objects, such as users creating, modifying, or deleting datasets, dataflows, schedules, etc. The traditional Presentation Services component provides such logging in domains/oas/servers/obips1/logs/auditjson.log, which contains audit information for catalog objects,…
I'm trying to index a Local Subject Area so I can use it in my AI Agent, however, I keep receiving the generic error below. Request status(500) : error = {"prefix":"DSS","code":50000,"message":"There was an unexpected error while processing this request. Please try again."}
it is observed that in OAC while using case statements the output is not expected.For example if we have a case statment like case when table1.column1=table2.column1 then 'yes' else 'No' end as Attribute1 Now if i use this attribute with a fact-amount column attribute 1|| Amount on a report then we dont get the aggregation…
Once I select that value from the list box Region I created, I want to filter the table by my selection. See the images
