Skip to end of metadata
Go to start of metadata

Purpose

The purpose of this page is to clarify the understanding of the system logic and requirements in relation to EPM BPC comment functions on EPM Add-in for Microsoft Office.

Overview

In this page, the EPM functions EPMSaveComment, EPMCommentPartialContext and EPMCommentFullContext will be explained as well the differences between partially qualified and fully qualified context comments and the methods to insert each type of comments.

Full and Partial Qualified Context Comment

Full Qualified Context Comment

The comment with full qualified context is the comment added using EPMSaveComment function, BPC Web UI or EPM Add-in Comments button on EPM tab. This comment has all the dimension members specified.


Partial Qualified Context Comment

The comment with partial qualified context is the comment added with some of the dimensions members as “None Specified”.

Saving and Retrieving Comments

Full Qualified Context Comment

EPMSaveComment will always save full qualified comments and if no member is specified, it will be taken from the current context. When using BPC Web UI or EPM Add-in, you must specify all the dimension members.

To retrieve full qualified context comments in an Excel sheet, you can use the function EPMCommentFullContext or EPMSaveComment but note that EPMCommentFullContext is specific for retrieving comments.

=EPMCommentFullContext()

=EPMCommentFullContext(,"BS212","CurrencyAdj","Budget","DZ","Appropriation","I_AR","LC","S_Africa","2006.01","YTD")

=EPMCommentPartialContext(,"BS212","CurrencyAdj","Budget","DZ","Appropriation","I_AR","LC","S_Africa","2006.01","YTD")

Partial Qualified Context Comment

This type of comments cannot be added using EPMSaveComment but only using BPC Web UI or EPM Add-in Comments button on EPM tab.

To retrieve the partial qualified context comments in an Excel sheet, the function EPMCommentPartialContext must be used and using BPC Web UI or EPM Add-in, you should select “All Members” in the respective dimension.

=EPMCommentPartialContext(,"CurrencyAdj","Budget","DZ","Appropriation","I_AR","LC","S_Africa","2006.01","YTD")

Related Content

Related Documents

SAP Help – Comments

SAP Help – Reporting on Comments

EPM Add-in User Guide


Related Notes

SAP Note 1647170: BPC: Bad Performance of EPMSaveComment function