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.
Explore how to build agents using code in AI Data Platform. We'll create an agent that examines and analyzes the contents of a Github repository and reports its findings. The session demonstrates how to use different developer tools to create agents including the AIDP extension for VS Code and Codex. Using these tools we…
The user icon in the upper-right corner of OAC (DV) is displaying more menu options for our non-admin users than we wish to display. We would like to restrict these to only "Profile" and "Sign Out" for regular users. Is there a way to customize these menu items? Especially if we can control this via security, that would be…
What is wrong with this code
Am I missing something or is there no way to search through previous posts to make sure I don't duplicate a question? All I see on the filter options are tags or status… a general search for a word or phrase would be helpful.
We were under the impression that when exporting a visualization in DV to CSV format hidden columns would be include from the grammar panel. This is not happening. See below for a screenshot showing 3 hidden columns that do not appear when exporting the pivot table to CSV. This seems to have worked a month or so back but…
Migrated RPD from obiee12c to OAS 2024. post migration when we try to access dashboards on OAS we are getting below error: State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000) State: HY000. Code: 43275. [nQSError: 43275] Message returned from OBIS…
