Is there a way to produce a list of the reports from the catalogue that are using direct database request?
thanks
William
Did try by generating a report with Catalog Manager?
It probably tells you something special for analysis built on a direct database request.
As alternative, you can do a full search in the catalog for every analysis having the special XML attribute that exists only in DDR analysis: connectionPool="
Both ways should work, both are done by using Catalog Manager (the tool, not the web page)
Thanks!!! That worked. You can create a catalog report for Analysis to get a list Names, Path, and SQL. It's in the SQL column where you can filter for "Execute Physical Connection" for the reports with direct database requests.
On a slightly different note. I have gone through several of the reports for the Admin tool. Is there one that can show me the Physical Tables of Table Type "Select" where the SQL has been given? I want a list of all the SQL being used. We need to check for certain tables being used from time to time.
To be honest no idea, I really try to stay away from using a SELECT as table in the RPD because it hide the logic of things, it's "safer" to create a view in the database with the logic, a lot simpler to track the logic and audit.
If you can't get an RPD report giving you that, another way of getting there could be generate the XML version of the RPD (in a single file) and look there inside (the XML will specify everything your RPD has). You will find the tags <PhysicalTable> and there somewhere you will get the SQL query instead of the table name.
As the XML format is defined, you could easily script a parser returning you a list of physical tables in your RPD being a SELECT.
I don't have an example piece of code available, but it will not be difficult, the XML is fairly easy to read (for this need, other pieces are a bit more "exotic").
We tried to export the RPD as XML but it generated a bunch of files. How do you do it in a single file?
That's one I have handy:
biserverxmlgen.sh|.cmd -R <RPD file path> -P <RPD password> -O <destination XML file>
The script is next to all other scripts (runcat etc.).
When done via the GUI it does split every object into a file and type of objects in folders: you could still do the job, but it will need to go through a bunch of files and folders. With the single file it's just easier.
The Query Repository tool has this simply by choosing "Type"="Select".
If your target is to automate this, then you can follow MOS Doc ID 1574480.1, section "ExecuteQuery".
Hi Gianni Ceresa, i am trying to find the direct database request via the catalog manager, but unfortunately in the search criteria connectionPool=" did not result in any data. Also, checked the way wfortson mentioned, no luck there either. Could not find the sql column from the available column list at all. Please help/correct here.
@Sindhu -Oracle please open your own thread and handle incoming responses yourself. This one is 3 years old and belongs to a different user.
Description: Join our Product Management team to learn about new features that are part of 26.R3 Application release of Fusion Data Intelligence (ERP). The session will cover updates on Finance, Projects, and Procurement. Presented by: Ashlesh Bajpai - Vice President, Product Management, Fusion Data Intelligence Shobana…
Good day, please kindly assist. We are creating a graph to calculate the number of assets per milestones. However, the planners have only populated assets for only one milestone from the list of milestones the customer wants to track. Which gives an incorrect view as the project moves past different milestones that it has…
I scheduled the report in OTBI and the agent was run successfully. However, I do not receive the report after the run in my inbox. The addresses are properly recorded, and the report is in an excel format and saved as a pivot table in otbi. What can be the cause?
Anyone has any idea why the OAC documentation on custom viz is not available now? I was able to access till last week - https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsdv/build-package-extension.html. Does this mean OAC doesnt support custom viz or custom workbook extensions?
I made a parameter with letter range values… put it into a dashboard filter. Then I created an expression filter to bind it to my last name column in the table with the image I uploaded here. I am getting the following error??? Invalid Expression. Validation of parameter values failed. A general error has occurred. Message…
Does Oracle Analytics Server 2026 include AI features such as a built-in chatbot or AI Assistant? If not, are there any plans or indications that these AI capabilities will be introduced in a future OAS release?
