Categories
is there any way we can get a list of the OBIEE reports names?
Hello, we are trying to get OBIEE report inventory, is there any way we can get a list of the OBIEE reports names? Thanks
Answers
-
You can use the Catalog Manager to get this information for you:
0 -
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
0 -
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.
0 -
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!
0 -
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.
0 -
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
0 -
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.
0 -
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.
0 -
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.)
0 -
thanks, The version is OBIEE 12.2.1.4.
0
