EPM Save Comment

[Former Member]

Hello,

I am having an issue with the EPM Save comment function.  I want the values for blank comments to be brought back as either 0's or blanks.  I have changed the the value in the Empty comment selection to be 0 via user options--> Others but when I refresh the report nothing changes I still get ... as the value.  The reason this is an issue is because we use excel formulas that reference those cells and as a result of the ...'s I am getting #VALUE errors.  Any guidance or next steps is appreciated.

Regards,

Jared

[former_member527115]

Priate Sub Workbook_SheetActivate(ByVal Sh As Object)         Dim EPMObj As Object     Set EPMObj = Application.COMAddIns("FPMXLClient.connect").Object     Dim EPM As New FPMXLClient.EPMAddInAutomation     EPM.SetUserOption "DefaultForEmptyComment", ""       End Sub

[Former Member]

Hi Jared ,

I am agree with Cecilia's comment , if you select set default value in empty cell such as 0 then your epm save comment function do not work.Another think is if you set your default comment from user option then this comment shown in bpc admin area.You can use EPM comment partial context and EPMCommentfullcontext for retrieve comment from BPC admin to your excel report. 

Khokan

[cecilia_petersson2]

Hi Jared,

Please ensure you don't have anything selected in Sheet Options / Formatting / Set Default Value in Empty Cell.

/Cecilia