on 2019 Sep 06 8:38 AM
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
Request clarification before answering.
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...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
8 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.