Comments aggregates on Hierchie level

[Former Member]

comments.jpg

Dear Experts

We implemnted comments on BPC11 Embedded according to the "how to paper"

https://blogs.sap.com/2016/10/24/enable-comments-section-sap-bpc-embedded/

In the row definition of the query there is a cost element hierarchie which we need for disagregation for the planning figures.

In a separate column (see highlighted on the picture) the user can comments on cost element level. In the definition of this column we said, "no display on results". In the definition of this rectricted keyfigure we defined "no disaggregation".

Nevertheless the comment will be shown in the node level but we want to hide this. Does anybody know a solution for this ?

Rgds

Thomas

[gregor_dieckmann · Accepted solution]

Hi Thomas,

you have to switch off aggregation along the hierarchy, i.e. you have to use formula exception aggregation:

• Create an input-ready (self-inverse) formula F:= Comment with inverse Comment := F
• On tab 'Aggregation' use the setting 'No Aggregation along Hierarchy' for F with 'Ref Characteristic' the base characteristic of the hierarchy

You can hide the original structure element: Comment and display only the formula F.

Regards,

Gregor

[gregor_dieckmann]

Hi Vikas,

this is a BW feature, it exists since BW 7.50 as far as I know.

Regards,

Gregor

[former_member394516]

Hi,

this functionality is possible in BPC 10.1 also ?

Thanks

[Former Member]

Great.

Worked as you described.

Thanks and Regards,

Thomas