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.
Please let me know how can I achieve this requirement
Thank you in advance,