How to Export BPC Excel Reports by Tool or Scripts

[SAPSupport]

Dear Sir/Madam,

In a new Financial year, Management urgently want last 10 years' BPC Excel reports for making decision. However they will be thousands reports that cannot be manually exported and very time consuming. We want to know that How to Export BPC Excel Reports by Tool or Scripts? Pls advise.

Thanks.

------------------------------------------------------------------------------------------------------------------------------------------------
Learn more about the SAP Support user and program here.

[SAPSupport · Accepted solution]

Hello

I feel the question is a little confusing. Because BPC data are kept in the backend instead of front end reports. If you haven't archived the data of the last 10 years in your backend BW, your managers can login to EPM reports and select the previous years 'periods as the "Time" dimension to display any data and you don't need to export your EPM reports.

In addition, from BPC standard features, there is no such scripts or tools to export reports as a batch. There is no such need too.

[Amy_Zhou]

Hi,

Please check if the book publication is what you are looking for. https://help.sap.com/docs/EPM_ADDIN/ec68e48b18a44a49abb12b8ee8ae306f/f9b6c2976faf1014878bae8cb0e9107...

Best regards,
Amy