Error "The connection credentials are invalid" in EPMConnector BPC-Xcelsius

[Former Member]

Dear all,

I was following HOWTO guide "How to Use the EPM Connector to Visualize BPC Data via SAP Crystal Dashboard Design (Xcelsius Dashboards)" and encountered error "The connection credentials are invalid" when trying to write back data, but read data is working fine.

Would like to ask if there's any way to solve this issue?

Thanks alot.

regards,

arie

[RichHeilman]

Sounds like you have the readData connection configured correctly, but may have made a mistake with the writedata connection. Delete the writeData connection and reconfigure and try again.

Cheers,

Rich Heilman

[Former Member]

Thanks Rich for your quick reply. I have tried creating a new, simple Xcelsius using only editable BPC Data Grid, and save button which is linked to writeData connection, still encountered same error.

There are 2 points below that I suspect may cause this issue:

a. Is it perhaps because the system used to try out this is not under domain? it's still using workgroup

b. In connection config, for "Host Name" I didn't specify the port, only use: http://localhost

but strangely with the above 2 points, readData connection is working fine.

Is there a way we can troubleshoot this error further?

Thanks alot.

[RichHeilman]

I would definitley use the port as well. Did you try that?

Regards,

RichHeilman

[Former Member]

Thanks Rich for your quick reply. Sorry I didn't mention specifically that I'm using BPC MS.

I found out the solution for this issue from doc u201CSAP BusinessObjects EPM Connector User Guideu201D, this was because specific for BPC MS in web.config file in BPC Web Server Virtual Directory, I need to remove tag below:

<remove name="Documentation"/>

once I removed it and restart BPC server, it works fine.

Thanks Rich.

[Former Member]

Thanks Rich for your quick reply. Sorry I didn't mention specifically that I'm using BPC MS.

I found out the solution for this issue from doc u201CSAP BusinessObjects EPM Connector User Guideu201D, this was because specific for BPC MS in web.config file in BPC Web Server Virtual Directory, I need to remove tag below:

<remove name="Documentation"/>

once I removed it and restart BPC server, it works fine.

Thanks Rich.

[former_member1192543]

Hi Rich,

Will the same EPM Connector will work for BPC 7.5NW also??

Thanks,

Naresh.K