Skip to Content
Comments in BPC (Business Planning and Consolidation) 10.0 is widely used to describe transaction data for communication and collaboration in planning and consolidation activities. However, comment has its length limitation and can only carry text. In some cases, you might want to attach rich information to a particular data cell or a data slice so that people can get more insight about the data they are looking at. Here are some scenarios where attachment as comment is useful.
  • In headcount planning, you might want to attach the new hire’s resume for a reserved headcount
  • In cost or travel planning, you might want to attach purchase order or quotation for a particular expense
  • In sales planning, you might want to attach third party market forecast of different region for incoming years
You might wonder whether it is supported and how it is supported by BPC 10.0. Well, first I assure you that it’s supported ever since the initial release of BPC 10.0 for both NetWeaver and Microsoft platform. And now I will introduce how to design a report to allow user to attach and view document as comment with a simple example.
Let’s assume you have a report like below, add two columns on the right side of the report and use EPM formula EPMCellContextDocument() in these two columns. In below example, the first column is for user to upload attachment. You can see three parameters are passed in the formula. The first parameter “1” means “upload document”, the second parameter is the data cell you want to comment on, and the third one is the text you want to display in the formula cell.
/wp-content/uploads/2013/04/upload_208695.png
If you double click cell C2, it goes to BPC Web and opens Add Document dialog.
/wp-content/uploads/2013/04/upload_doc_208696.png
Notice the context is automatically filled with the dimension intersection of the data cell B2 from EPM Add-in.
/wp-content/uploads/2013/04/context_208778.png
Once uploaded, to view the documents from the report, double click cell D2, which contains another EPMCellContextDocument formula, with first parameter as “2”, meaning “view document”.
/wp-content/uploads/2013/04/view_208780.png
It then goes to BPC Web Documents (Content Library) page. All documents under the passed-in context will be listed and user can click to read each of the document.
/wp-content/uploads/2013/04/filter_208785.png
As you can see, it’s very easy to utilize the EPMCellConextDocument formula to attach and view documents as comments. Hope now you can design your own report according to your (or your customer’s) business need.
Note:
  • For more information about EPMCellConextDocument, please refer to EPM Add-in user guide.
  • BPC Web Documents supports some file types by default, such as “.ppt” and “.pdf”. If it’s not enough for you, you can add new file types as instructed by note 1641922.
To report this post you need to login first.

4 Comments

You must be Logged on to comment or reply to a post.

  1. Carlos Diniz

    Hello Gavin,

    Thank you for this post and examples mentioned.

    Although it is pretty straight forward, it seems I am missing something. Is it necessary to configure any additional parameter through Web Admin or transaction SPRO on BW side? What is the minimum SP level on BPC component and Add-In to use this function?

    On my report, the “Enable Double-Click” is set to true and it does not open the pop-ups…

    Regards,

    C.

    (0) 
    1. John Leggio

      Hi Carlos,

      The EPMCellContextDocument function has been around for a while if not since the original release of the EPM Add-In.

      I would recommend you download the latest EPM Add-In version (Note that SP14 due out tomorrow) for performance, stability and enhancements.

      Thanks,

      John

      (0) 
      1. Carlos Diniz

        Hi John,

        A colleague found the solution for this issue. In order to make it work it is necessary to configure two parameters through the transaction RZ10, as follows:

        login/create_sso2_ticket = 2

        login/accept_sso2_ticket = 1

        You’ll find the details in SAP Note 1846913 “Logon ticket creation has been disabled” when using “Find Comments” function – BPC 10NW.

        Regards,

        C.

        (0) 
  2. Jef Baeyens

    Hi Gavin,

    Is there a way to check in the EPM-addin schedule if a document was already uploaded or not? That would allow us to build more rich schedules…

    (0) 

Leave a Reply