Using multiple EPMSAVECOMMENT

[nicky_hays]

Hi,

I am trying to use EPMSAVECOMMENT two times in a worksheet. both are declared as EPM Local Member and as columns in the worksheet. One is for storing Student Class and other one is for storing student Grades.

The first EPMSAVECOMMENT for Student Class works perfectly but the second one Student Grades keeps on retrieving Student Class even though I have linked it to a different cell.

please help!!!

Sincerely,

Nicky

[former_member544285 · Accepted solution]

Hi Nicky,

Double check on the members you referenced in the formula. If you're missing dimension members, it will reference to selected context. You must make sure at least one dimension member referenced by student class and student grades are different.

Post your formulas and screenshots to get more help.

Hendry

[nicky_hays · Accepted solution]

Hi,

I tried to differentiate between the two save comments by keeping dimensions seperate but it still does not work.

Please see example below.

I am trying to add 2 comments:

1) True Void

2) Category Growth

The EPMSAVECOMMENT formula for True Void is as follows:

=EPMSaveComment(EPMPOSITION(4), "Planning", EPMDIM_CURRENT_MEMBER(MEMBER_VENDOR),EPMDIM_CURRENT_MEMBER(PROFIT_CENTER),EPMContextMember("Planning","ACCOUNT"))

The EPMSAVECOMMENT formula for Category Growth is as follows:

=EPMSaveComment(EPMPOSITION(6), "Planning", EPMDIM_CURRENT_MEMBER(PROFIT_CENTER),EPMContextMember("Planning","TIME"))

But when I save comments for "True Void", it automatically shows up for "Category Growth". The comments in Category Growth are overwritten.

Please help me with this issue.

Also can I add a third comment to this data structure?

Sincerely,

Nicky

[Former Member · Accepted solution]

Hi Nicky,

How many dimensions do you have in your model?

You need to specify all the dimensions or it will use the context.

It might be that your 2 comments are using the same intersection.

Andy

[nicky_hays · Accepted solution]

Hi Andy,

I have 12 dimensions. If I specify the same dimensions for both the models then they will intersect. Is there any other way I can do it?

Sincerely,

Nicky

[dinesh_veluru · Accepted solution]

Hi Nicky,

It is not possible to save the multiples comments on the same intersection as the latest comment will override the previous one . try using different dimension member combination in the epmsavefunction.

check if it is functionally ok to use category member "Budget" for True Void function and "Forecast" for category growth.

Thanks,

Dinesh.V

[Former Member · Accepted solution]

Hi Nicky,

How do you differentiate student class and student grade?

Only one comment is allowed per one intersection.

So you need to create a new dimension if you need to store both, or maybe use comma to separate them, and in your report you use excel formula to split them, when you save you need to concatenate them and use only one savecomment.

Andy

[former_member186338 · Accepted solution]

Hi Nicky,

The comment is written to the intersection of all dimensions. Single comment for single intersection. I do not understand your requirements...

Vadim

[former_member186338]

Hi Nicky,

Do you think it's possible to help you without screenshot and detailed description of formulas????

Vadim

[Shrikant_Jadhav]

Hi Nicky,

Kindly share the formula, and make sure that you are saving comments on different dimension member.

Shrikant