cancel
Showing results for 
Search instead for 
Did you mean: 

Distribute BPC Reports in BPC 10.0 NW

former_member254616
Participant
0 Kudos
282

Hi Experts,

I have a requirement to Distribute BPC Reports to users. The requirement is to compare values in 2 different BPC Servers and then Distribute this Report. Currently, we have a Report created and the users can open the Report, Login and refresh to see if both values are reconciling. Now, they would need the same report to be distributed to their email so that, they can open the report from the email and see if any differences.

When i try to save the report on Server 1 and try to open the report, it gives me an error message that server 2 is not available. That is a valid error.

Please let me know how can I achieve this functionality?

Can I Distribute the same report from my desktop even if I am offline or do we have any other alternative to achieve this functionality?

Current Report on Server 1 is connected to 2 different servers shown below.

Server 1

Server 2

Please let me know how can I achieve this requirement

Thank you in advance,

Best Regards

View Entire Topic
former_member186338
Active Contributor
0 Kudos

1. You can use VBA to connect to the required server when report is opened.

Place this code in the event AFTER_WORKBOOK_OPEN - to be launched when report is opened from server folder.

2. You can create complex vba code to perform distribution of report from desktop. I have done it ones...