Hello, we are trying to get OBIEE report inventory, is there any way we can get a list of the OBIEE reports names? Thanks
You can use the Catalog Manager to get this information for you:
https://datacadamia.com/dat/obiee/obips/catalog_manager
Thanks a lot Christian, since each report pull the data from different database, is there any way we can find out what is the DB name for each report? Thanks
There are ways, there aren't simple ways.
The catalog (the analysis) isn't aware of that info because that's covered by the RPD. You can export lineage information from your RPD, you can get the info of what subject areas or columns are used by the analysis, you can connect all the dots and get the whole info.
It isn't something available out of the box with a single click in the tool. You can code it, or you can buy a solution coded by somebody else.
Thanks, we get the list reports for the Analytics reports and their data source, but it does not work for BIP, when export from catalog manager, it does not work as simple as Analytics report.
Do you know if there is a way we can find the information for BIP? thanks a lot!
BIP is a different product, it's totally different as it works with data models and it's a totally different thing. I suspect you will need to do manual parsing of things to get some info out BIP reports.
Apparently the Analytics Report names do not show up in the catalog somehow, after I export from catalog manager and can not find any report names there, does any one knows where we can find the Analytics report names? Thanks
What do you call an "Analytics report names"? What kind of "export" did you do in catalog manager?
Catalog Manager is perfectly able to read the OBIEE/OAS/OAC object names, therefore the names are accessible.
export "name, Subject Area,Table" from catalog manager with "Analysis" as "select type to report on" in "create catalog report screen below, but but of the value in the "Name" column match our report open from Analysis screen. thanks.
That kind of report will give you the business name of the analysis, the one you see in the web UI (and which is different than the files' name on disk).
If your report doesn't return the analysis' name, you will need to provide more details (no version is known at the moment, the history of the catalog could also help etc.)
thanks, The version is OBIEE 12.2.1.4.
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…
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?
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?
Here is my calculation CAST(COUNT(SAAR_ID) AS VARCHAR(50)) || ' SAARs pending as of: ' || CAST(CURRENT_TIMESTAMP(5) AS VARCHAR(50))
In OAC when I am creating a dataset, How can I pass a Filter from the "Dashboard filters to the SQL? I attached a image like it was don in BIP Publisher