Skip to Content
avatar image
Former Member

Bad perfomance influence due to large BPC comments table

Hello. We'r facing problems with perfomance when using one of or infocubes which stores a greate number of comments (more than 50 000 000). Neither of them can be deleted, because business needs them and the amount is growing day by day.

What actions can we take to normalize perfomance with this amount of comments.

Thanks in advance.

BPC 10.0 NW

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Mar 30 at 12:16 PM

    Sorry, but how you managed to generate the mentioned amount of comments?

    Add comment
    10|10000 characters needed characters exceeded

    • "we have what we have" - next time a customer will ask you to develop a procedure to do all accounting in BPC without ERP :)

      In general for sure you can clear historical comments. But how do you want to do it?

  • Apr 03 at 11:48 PM

    There is a standard class you can use to archive comments: CL_UJC_CMTMANAGER > ARCHIVE_CMT. This will send the comments to *A table.

    Have you checked what value the users have in the default comment option in EPM? I had a problem where some users had this set with "...".This can grow significantly the comments table.

    Add comment
    10|10000 characters needed characters exceeded