CANNOT ADD COMMENT SAP BPC 10.1 CLASSIC EPM SP 19 EXCEL 2010

[Former Member]

Hi ALL,

Im trying to save comment and the following error appears: "cannot add comment" there is no more information.

all the the dimension are in the formula.

all the members are base level

I write "test" in the cell: N21

=EPMSaveComment(N21;;$E$11;$E$13;$E$14;$E$15;G21;$E$10;H21;$E$16)

Could you help me.

Thank you.

Best regards,

[former_member186338 · Accepted solution]

Try to use some recent version of EPM - at least SP25+

Has to work properly!

[former_member186338]

Now I see an issue!

You have member in M_CDESTINO: Castos de viaje

Member ID with spaces inside - absolutely bad idea!

Also strange members in M_PARAMETRO

[Former Member]

Hi Vadim.

Thank you.

We have changed the members and the issue continue..

[former_member186338]

I see that $E$16 is still without EPMMemberID, not sure that it's an issue!

The message is not clear: [Gastos de -???

[former_member186338]

First - please, never use "Insert File" instead of correct "Insert Image" - hard to read.

Second: in the User Settings enable:

I see descriptions in the referenced cells!

Your formula for members will contain EPMMemberID(...)

=EPMSaveComment(N21;;EPMMemberID($E$11);EPMMemberID($E$13);EPMMemberID($E$14);EPMMemberID($E$15);EPMMemberID(G21);EPMMemberID($E$10);EPMMemberID(H21);EPMMemberID($E$16))

[Former Member]

Hi Vadim,

Thank you.

We click the option as you indicated me. And the issue continue, the same report in excel 2013 works fine, but we need to solve it for excel 2010.

Best regards,

J

[former_member186338]

Please provide clear report screenshot with all involved cells visible! Unable to comment:

=EPMSaveComment(N21;;$E$11;$E$13;$E$14;$E$15;G21;$E$10;H21;$E$16)

🙂

[Former Member]

Hi Vadim, Thank you. Attached you can find the screenshot