Report to be sent to a shared location

Hi All,

BPC 10 NW

There is a report on BPC server which contains several tabs (say 10 sheets containing 10 different EPM reports). This report needs to be transferred to a shared location (which can be accessed from BPC server). Now before transferring this file, I need a mechanism by which the underlying data first gets refreshed on BPC server and after that report containing the latest data is copied over to the shared location. This entire process of opening report/refreshing it and then copying to shared location needs to be automated.

What are my options, any help is appreciated?

Regards,

Ashish