Saving bulk webi/crystal instances to excel/pdf formats

[usman1158]

Good Afternoon,

Is it possible to download in bulk all the scheduled instances, that are currently stored in CMS as webi/crystal ( webi/rpt format) , into excel or pdf format ?

Version: SAP BusinessObjects BI Platform 4.2 Support Pack 8 Patch 7

Also we have 4.1 version as well

I know there is a post on this on a blog, but there is no answer to that https://answers.sap.com/questions/13454506/downloading-bulk-webi-instances-to-excel-or-pdf.html

That's all i see in the answers to that blog

dell.stinnett-christy Aug 09, 2021 at 01:23 PM

This is actually not that difficult to do - and you could do it using either the Java or, depending on the version of BOBJ that you're using, the RESTful Web Services SDK. Are the instances already in Excel or PDF format or do you need to convert them prior to saving? And which version of BOBJ are you using?

[DellSC]

Basically, you have to write code using one of the SDKs to do this. If you only have Webi reports, you could probably use the RESTful web services SDK. However, if you have Crystal reports that you need to download, you'll need to use either the .NET or Java SDK - the RESTful SDK does not work with "Classic" Crystal reports, it only works with Crystal for Enterprise reports and doesn't include functionality for exporting. You could also use a combination of RESTful for Webi and .NET/Java for Crystal.

Basic logic:

1. Log in to CMC and instantiate an EnterpriseSession/IEnterpriseSession.

2. Instantiate an InfoStore/IInfoStore so that you can query the CMS.

3. Query for all report instances that have been run since the last time this application was run - SI_INSTANCE = 1 and SI_SCHEDULE_STATUS = 1 (successful instance).

4. If format is Excel or PDF, save it as is. Otherwise, open the report and save it to PDF or Excel.

-Dell