Question Re: BPC EPM report lost connection in Financial Management Q&A

BPC EPM report lost connection

Former Member — Mon, 23 Nov 2015 10:10:03 GMT

Hello,

Has anybody an idea how to deal with such issue ?

BPC reports are generated automatically and distributed to end-users.

We recently found out that some reports are wrong because connection to BPC was somehow "lost" and therefore data not refreshed properly.

Is there any EPMfunction that returns connection errors ? or how would you deal with such issue?

Thanks a lot

regards

Manu

Re: BPC EPM report lost connection

former_member186338 — Mon, 23 Nov 2015 10:14:02 GMT

Hi Manu,

Can you describe the issue in details? Are you able to reproduce the issue?

Vadim

Re: BPC EPM report lost connection

Former Member — Mon, 23 Nov 2015 10:17:20 GMT

Hi Vadim,

The issue is only that report have no figures or 0.

Manu

Re: BPC EPM report lost connection

former_member186338 — Mon, 23 Nov 2015 10:20:32 GMT

"The issue is only that report have no figures or 0." - what do you mean???

Re: BPC EPM report lost connection

Former Member — Mon, 23 Nov 2015 10:26:53 GMT

when the report is connected to BPC , it will returs figures after refreshed.

If no connection to BPC, no figures / 0

Re: BPC EPM report lost connection

former_member186338 — Mon, 23 Nov 2015 10:57:59 GMT

And what? Absolutely not clear...

Re: BPC EPM report lost connection

Former Member — Mon, 23 Nov 2015 23:31:30 GMT

Hi Manu,

use =EPMServer() formula to see if you are connected to the server or not.

you need to identify why it lose its connection, do you use VPN?

Do you work with different connections with different reports?

Andy

Re: BPC EPM report lost connection

rajkumar_kandula — Tue, 24 Nov 2015 17:24:26 GMT

Hi Emmanuel,

Alternatively, you can write a simple macro in workbook open to automatically refresh and connect the layout to the server. Let me know if you need further inputs.

Regards,

Raj