Skip to Content

With the latest AO and BPC 11 embedded model, you’ll now be able to enter comments at any of the data cell. Unfortunately so far as I know the feature will not be included in BPC Optimized version which is the major use case for BPC embedded model.

BPC Embedded Model has another short commenting feature available since BW 740. There are a lot of known shortage for short commenting, it’s only supported in Direct Update DSO or Direct Update ADSO. you can only enter 250 chars. If you enter a comment which is longer than 250, it’ll just be truncated without any warning( This has been fixed by Note 2546014 ). Another problem is the comment itself is a key figure. Meaning if you have multiple key figures already, you cannot comment on the key figures themselves.

This time the new comment feature has overcome the drawbacks form the short commenting. It’s cell based and across queries/workbooks. There is no length limitation any more. Further more, you can input comment on any type of cells – not only data cells, but also hierarchy nodes, sub totals, restricted key figures and so on.

Please also refer to this great blog by Frank:

https://blogs.sap.com/2018/03/15/improvements-of-bw4hana-analytical-engine-in-q1-2018-with-bw4hana-1.0-sp08/

Prerequisites

You’ll need to create a Document Store in BW.

You’ll just need to add the Composite Provider or InfoProvider into the Document Store.

After this, you can create Aggregation Level and Input Query on top of the object you saved in the store.

Input Comment

Now under the Analysis tab, you’ll see a new group of buttons. You can highlight a cell and input/edit comments.

 

 

Another option is to add or edit comments from the context menu.

When you click on save comments button, after saving, you’ll see a pop up message at the bottom left corner.

Backend

The Document Store is essentially a direct update type ADSO.

/1BW/DOAYD4I

The comment data is saved in the Active Table.

 

To report this post you need to login first.

3 Comments

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

  1. Václav Schreyer

    Hello Sibo Zhang,

    I wanted to kindly ask you for help.
    Your article is really cool and helpful, unfortunately I got to a problem, when Eclipse gives me an error while creating the Document Store object.
    The error message is: Creation of objects of type “DOCA” not supported

    I am connected to our SAP BW/4HANA…

    Would you have, please, any idea what the issue could be?

    Many Thanks in advance!

    Kind regards,
    Vaclav

    (0) 

Leave a Reply