Distribute BPC Reports in BPC 10.0 NW

[former_member254616]

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

[former_member186338 · Accepted solution]

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...

[former_member254616]

Hi Vadim,

Thanks again for your Inputs. sure, I will try options suggested above.

Have a good day. Thank you.

[former_member254616]

Hi Vadim,

Thank you for your Reply. I tried the options as suggested by you. Please find my test results below.

1. Option 1: When I try to open the Report from my desktop and login to one Environment and refresh, Default report which is on Server 1 and Report 001 which is on Server 2 is fine.

2. Option 2: When I save the same report on Server 1 for e.g and when i login to server 1 for e.g and open the report from the server, it gives me an error message for server 2 as "Invalid Environment" as shown in screen shot below

I have seen some links in the same forum that the Report can be "Distributed Offline" from our Desktop as well instead from Server. Can you please let me know if we have a Link/Document which I can refer to do the same?

In case of any questions, please let me know.

Thank you in advance,

Best Regards

[former_member186338]

Please check that connection and environment is stored in the report: