Question Re: SAC Dimension Coment Performance in Technology Q&A

SAC Dimension Coment Performance

christian_st1 — Thu, 06 Jul 2023 16:06:35 GMT

Dear all

We use dimension comment with a relatively large planning model and have performance problems accordingly. Saving a new comment takes 28 seconds on average, deleting a new comment takes 26 seconds. It makes no difference whether we display all the data in the table or filter it for a single record.

The formula and model (the dimensions used are outlined in red):

And the statistics for all comments:

Does anyone have any tips on how to improve the performance? For example, to delete all data point comments that we no longer require. As an admin, however, you can’t do this centrally for all comments, and we can’t realy do it manually because there are to much.

Thanks for your help!

Kind regards, Christian

Re: SAC Dimension Coment Performance

N1kh1l — Thu, 06 Jul 2023 16:57:56 GMT

christian_st

Currently there is no feature which helps to manage central management of comments (mass delete, export, edit etc.) There is an influence request (current status: under review) which you should upvote.

Improvement Request Details - Customer Influence (sap.com)

Hope this helps !!

Nikhil

Re: SAC Dimension Coment Performance

William_Yu1 — Fri, 07 Jul 2023 02:06:02 GMT

would suggest you create a ticket to SAP for checking.

Re: SAC Dimension Coment Performance

JefB — Fri, 07 Jul 2023 07:11:01 GMT

If I were in your position: log an incident arguing the comment function is not performant enough. This is a cloud solution so it should be scalable. And you are not even using that many dimensions nor huge nr. of members

Re: SAC Dimension Coment Performance

christian_st1 — Mon, 10 Jul 2023 09:35:16 GMT

Did so, thank you.