Save Comment in BPC, but returned an ellipsis

[Former Member]

Hi,

I used EPM function to save a comment ("Performance") in BPC through excel EPM add-in interface. I was told 1 comment is saved successfully when I clicked "Save Worksheet Data". However it returned three dots "..." in the cell, rather than "Performance". I have set the comment length 1000 for this connection model in BPC.

The function I used is below

EPMSaveComment(Comment cell < "Performance" was entered in this cell>, Connection Name, Member1, Member2, Member3, Member4)

Can anyone help?

Thanks in advance!

[former_member186338]

Sorry, but you are referencing cells with Member descriptions, not member ID's (A2,B2,C2,D2). Will not work correctly!

You have to use Member ID's or:

If you have EPMOlapMemberO formulas in cells A2,B2,C2,D2 then you have to use:

=EPMSaveComment(E2,,EPMMemberID(A2),EPMMemberID(B2),EPMMemberID(C2),EPMMemberID(D2))

Please accept the correct answer.

[former_member186338]

mindyding

Sorry, but do you really have member ID "P05 Forecast Plan" with spaces inside ID????

If it's the case then it's absolutely bad idea. Having spaces inside member ID results in a lot of issues!

Also check that you don't have identical member id's in different dimensions used in the same model.

[former_member186338]

Sorry, but looks like you are saving twice... May be you have VBA?

Create a new workbook, create simple input form with save comment. Test!

[Former Member]

Thanks again Vadim! I saved another comment for member 2-5 instead of member 1-4, that means at least 1 member is different. In addition, my file doesn't have VBA macros. I have also tried to disable Developer in my Excel Ribbon and saved anther comment again, still returned me nothing, but I did have comment there. I used another way by clicking "Add Comment" on EPM Ribbon, that worked. But I am not able to use EPMSaveComment function to save user comments. For me EPM function is a very practical way to save comment and I really want to figure out why I was not able to use this method to save comment.

[former_member186338]

mindyding

Sorry, but looks like you are doing something wrong!

Please post a screenshot of the test input form with everything visible and explain what you are doing!

[former_member186338]

In User Options->Others: Empty comment remove "..." and save comment again!

[Former Member]

Thanks Vadim! I followed your instruction and removed "...", however it returned nothing when I tried to save comment. Are there any other settings I should change in order to save the comments? My BPC is not connected to BW, but I have no trouble to save data in BPC.