on 01-26-2011 3:33 PM
Hi All,
There must be a way to get the list of all the universes and reports out on WEBI. I am working on some kind of a reporting catalog and would like to know the report name, folder name (where the report is published), universe name (the report is based on) and may be some optional fields if possible like owner name, designer name, date of published etc.
I would appreciate if someone can guide me to get this data out. We are using Business Objects WEBI XI 3.1 with SAP BW. Our Universes are based on BEx queries.
Thanks.
Asim
Hello,
An alternate to using Query Builder would be to use Auditing via the Activity Universe. This of course presume that Auditing is enabled. Also, this would only work for reports that have been accessed / run.
Best,
Srinivas
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks pumpactionshotgun and Srinivas. We do not have the auditing feature enable yet so I will be more dependent on the query builder.
I tried the query builder but what I see if I don't see the folder names the report is published to and also the universe it is based on. Am I missing any object name for the folder?
Let me know. Thanks.
fire the query:
select si_name,si_owner,si_webi,si_parent_folder from ci_appobjects where si_kind='Universe'
This will give you the universe name, owner, the id's of the webi reports built over the universe, the id of the folder where the universe resides.
assuming the id of the folder containing the universe is 119, then fire the query below to find the name of that folder:
select si_name from ci_appobjects where si_id=119
assuming the id of the webi report is 900, fire the query below to find the name of the webi report:
select si_name from ci_infoobjects where si_id=900
If you want a report related information, fire the query:
select si_name,si_owner,si_universe,si_parent_folder from ci_infoobjects where si_kind='webi'
This will give you the name of the report, the id of the universe it is built on, the owner of the report, the folder id containing the report.
you can extract required information by firing similar queries.
Universe information is available on ci_appobjects and webi related information is available in ci_infoobjects
Hi Arijit,
I am using Query Builder to retrieve list of BO reports from repository.
Query SELECT * FROM CI_INFOOBJECTS WHERE SI_KIND='WEBI' returns metadata about Webi but I am not getting list of reports or count of WebI reports for that matter.
Kindly suggest how can I get the list of report names?
Appreciate your response.
Thanks,
Archana
you can use query builder to get the information.
to get list of all universes, fire the query:
select * from ci_appobjects where si_kind='Universe'
to get list of all Webi Reports, fire the query:
select * from ci_infoobjects where si_kind='Webi'
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.