Export List of reports in Web Intelligence

[former_member1133383]

Hi,

I am looking for a way to download and export a list of reports created in SAP BO Web Intelligence 4.2.

Any suggestions how I could do this would be appreciated.

Thanks in advance.

[former_member184995]

You may be able to use the BIonBI cms driver:

https://wiki.scn.sap.com/wiki/display/BOBJ/Unlock+the+CMS+database+with+new+data+access+driver+for+B...

https://blogs.sap.com/2020/06/03/get-more-insights-with-bi-cms-data-access-driver-add-objects-or-vir...

[krisa24]

Hi,

as far as I know the Query builder doesn't support nested queries, therefore you would have to script it more times and put the information together

1. All Webi reports and their parent folders

SELECT TOP 10 SI_ID, SI_NAME, SI_PARENT_FOLDER FROM CI_INFOOBJECTS 
WHERE SI_KIND  ='Webi'

2. All folders and their parent folders

SELECT TOP 10 SI_ID, SI_NAME, SI_PARENT_FOLDER FROM CI_INFOOBJECTS 
WHERE SI_SPECIFIC_KIND = 'Folder'

You have to combine the info and do the nested search, where you look for parent folders until you reach the the main folder.

[krisa24]

Hi,

the tool you are looking for is QueryBuilder.

Accessible via URL http://[Server]:[Port]/AdminTools and you log in with your SAP BO credentials.

Query to be run:

SELECT * FROM CI_INFOOBJECTS WHERE SI_KIND=’WEBI’

Here is nice blog about it:

https://blogs.sap.com/2013/06/17/businessobjects-query-builder-basics/

[former_member1133383]

Thanks a lot for your quick response Kristina! I didn't know about this tool so I used it after your suggestion. I find out that this works good, but there is also some limitations regarding my requirements from maintenance perspective.

I am looking to select the entire list of BO reports, plus its location in Webi.

For example:

REPORTNAME			LOCATION
[ReportA]			[Root\FolderA\SubFolderB\SubFolderC]
[ReportB]			[Root\FolderA\SubFolderC\SubFolderD]

If you could help me to achive this, I would be very happy!