Retreive comments through "EPMSaveComment" function

[former_member223345]

Hi,

I need to save and retreive comments from excel through EPM Add-in through the "EPMSaveComment". when I save there is no problem ( I even checked  in SAP BW tables and i found all the comments I saved ).

But when I want to retreive the comments I only Get the Last one that I saved. In fact, I need to retreive all the comments.

How can this be possible ?

Best regards,

[former_member186338 · Accepted solution]

Hi Mohamed,

The only way is "You can view a history of the comments in the web client of Planning and Consolidation." from BPC help.

Not on Excel sheet.

Vadim

[former_member223345 · Accepted solution]

Thank you Vadim

[Former Member · Accepted solution]

Hi Mohamad,

By using EPMCOMMENTFULLCONTEXT() along with EPMCOPYRANGE() functions one can display comments in worksheet as well.

For example, if you want to display comments at last column of the report/input form, you need to add a new column next to last column and write in cell K2 (for example) epmcommentfullcontext() ..in the dialog-box input the parameters as member1 = J5  [cell  reference] which holds a comment for the dimension member and member2 = B2 input the cell reference for example, which hold a row key expansion means  this value will be populated in epmcopyrange. Now write epmcopyrange() function row= TRUE and copyrange is B2:K2 means you need to take the total range of dimension members which hold the comments till the range/cell where epmcommentfullcontext() has been defined.Once you refresh the report it should display all the comments existed along with the row( the tricky part to understand is using member2 parameter in epmcommentfullcontext() which derives the row wise comments while range expands by epmcopyrange function). This feature had been implemented by me in one of my projects.

Hope this helps,

1

2                B                                           J          K

5                              2013.Jan  ----      2013.Dec Display Comments

              Acc-1                                                  Capex for upstream project

-

-              Acc-n                                                 Capex for Rentals-Middle East

15

Cheers,

Srikanth

[former_member186338 · Accepted solution]

Hi Srikanth,

But how EPMCOMMENTFULLCONTEXT is related to the history of comments for a single intersection?????

Vadim

[Former Member · Accepted solution]

Hi Vadim, its not for a single cell intersection as we were including this single cell formula in rowkeyexpansion dynamically when Epmcopyrange executes till the end of rows in the report.

Please use B2cell(just blank one) just above the rowkey(Ex Account in this case and copy the range from B2 to K2=Epmfullcontext defined for existing comment as a reference.Please check it at your end otherwise I could send the screen shots soon.

Please note below.

epmcommentfullcontext() ..in the dialog-box input the parameters as member1 = J5  [cell  reference] which holds a comment for the dimension member and member2 = B2 input the cell reference for example, which hold a row key expansion means  this value will be populated in epmcopyrange

Regards,

Srikanth

[former_member186338 · Accepted solution]

Hi Srikanth,

The topic initiator is asking question about history of comments for a single intersection - like Acc-1 and 2013.Jan. Users may change this particular comment number of times. And all versions of comment for this intersection is stored in the database. But to view the versions only Web interface is available, Excel functions show only the last version.

Is it clear?

Vadim

[Former Member · Accepted solution]

yes Vadim only last version could be retrieved by my approach, I overlooked the history of comments(versions). versions can be seen by explorer/web interface as you said.

Thanks for updating,

Srikanth

[bishwajit_das]

In EXCEL,you can only retrieve the last comment saved for the context, and not any historical comment.

But you have something to do with the historical comments then you can use BADI to read the comment table and publish it in excel format or .txt format.

Regards,

Bishwajit

[former_member223345]

I confirm the only way to retreive all comments is by visualizing tables in SAP BW or to navigate to the audit menu in the web platform of bpc. But in Excel you can only retrieve the last comment by member.

[former_member186338]

Then close the topic to stop not relevant answers...

Vadim

[former_member217278]

Hello Mohamed

Can you put a screenshot of the formula and input form , also if you specify all the dimesion values in epmsave comment formula ... I think it will work .

Thanks

Yashvi Maheshwari