BPC Save comment makes value blank

[former_member590808]

Hi,

We are using save comment function to save the data being entered in column R. Problem that am facing is that post clicking on save data the text in R column goes blank and then data is available in column Q. Column Q has save remarks code. Am I missing out on any configuration? Does something else needs to be maintained. We are using AO 2.7 SP6. The code to written to save comment is:

=EPMSaveCommentOnly(R11,,"APL_CC:NOCC","APL_AUDITTRAIL:347","APL_TIMES:"&$H$6,"APL_CATEGORY:DUMMY","APL_ENTITY:"&$B$2,"APL_PLANYEAR:"&$H$4,"APL_KEYFIGURE:FACTOR","APL_ACCOUNTS:NOGL","APL_EMPLOYEE:"&H11,"APL_GRADE:"&G11,"APL_CURRENCY:INR","MEASURES:YTD")

[former_member186338]

"what can I do to avoid that ?" - don't use local member!

[former_member186338]

"I forgot to mention column R is also a local member formula." - for sure this local member will clear contents on refresh!

[Pawan_Mahto]

what can I do to avoid that ?

[former_member186338]

Sorry, but not clear...

Try to use simple test case with ENVIRONMENTSHELL copy:

Nothing goes blank!

[former_member590808]

What do you mean by environmentshell copy ?

[former_member186338]

nehayadav0911

"What do you mean by environmentshell copy ?"

You always have ENVIRONMENTSHELL in your system. It's not a good idea to play with it directly, better to copy it and play with copy of this environment.

[former_member590808]

Hi Vadim,

What i am trying to do is a simple epmsavecomment. It will be better if i avoid this environment shell copy method that you said. Is there any other way to do epm save comment ? My query is when am saving the comment by clicking save data, the cell where data entry happened becomes blank. how can i avoid this

[former_member186338]

nehayadav0911

Sorry, I have already told you that I am unable to reproduce your issue!

Nothing becomes blank in my test case.

I have no idea about your workbook and report setup. And I recommend you to create a simple test case like I have done. Then compare it with the actual report you have.

[Pawan_Mahto]

I forgot to mention column R is also a local member formula. Which doesn't have any formula written in it. Column Q which is save remarks is also local member which has save comments only formula written there. Does local member have any impact?