Question Re: SAP Analytics Cloud limitations in story tables in Technology Q&A

SAP Analytics Cloud limitations in story tables

wolfgang_runge — Wed, 10 Feb 2021 18:16:15 GMT

Dear Community,

we have created a story table which should show around 4,000 rows. But obviously the table is limited to 500 or so as after 500 the table is empty. Interestingly enough the total sum is right and shows the sum of all 4.000 rows.

Is there a limitation in story tables? Or is there a way to overcome that? Thanks!

BR Wolfgang

Re: SAP Analytics Cloud limitations in story tables

TuncayKaraca — Wed, 10 Feb 2021 18:32:56 GMT

Hi Wolfgang,

I remember that limitation. Though you can increase this limit. There should be warning message on the top left corner of the table. Hover over the warning symbol and click on “Edit Drill Limitation” to increase the row limit.

Though you need to be concerned about performance; test and validate!

References:

Re: SAP Analytics Cloud limitations in story tables

wolfgang_runge — Wed, 10 Feb 2021 18:38:30 GMT

Debjit, Tuncay,

thanks a lot for this hint. I just tried but for me it doesn't work as I have around 30 columns. So the limitation is always the maximum number of 30.000 cells.

Or am I wrong?

BR Wolfgang

Re: SAP Analytics Cloud limitations in story tables

DebjitSingha — Wed, 10 Feb 2021 18:44:54 GMT

You can change row limit for individual tables by changing "Drill limit option". This works for both story as well as apps/ designer. Option is not readily available under styling or designer. Instead you need to first get to a warning message like below, before you can get into drill limit option window.

Once you are inside the option window you are free to choose custom and unlimited .

Again this option only appears if your selected dataset in table try to show more than 500 rows or more than 60 columns or both.

If you change this setting during edit more and then save the changes, updated stays and if end user perform this change during run time change becomes temporary for this instance.

There are couple of enhancement available for voting. These enhancements will help support this feature better. Feel free to vote on them.

Admin to decide and set limit globally - https://influence.sap.com/sap/ino/#/idea/281341

Enable this option even if there are less than 500 rows or 60 columns in dataset - https://influence.sap.com/sap/ino/#/idea/283365 & https://influence.sap.com/sap/ino/#/idea/245725

Viewers/ readers - If you find above information helpful, feel free to up-vote (arrows on left side).

-Debjit

Re: SAP Analytics Cloud limitations in story tables

TuncayKaraca — Wed, 10 Feb 2021 18:51:39 GMT

You are right, it's about total number of cells (row X columns).

Re: SAP Analytics Cloud limitations in story tables

wolfgang_runge — Wed, 10 Feb 2021 18:53:07 GMT

Ah, yes, you are right! You guys are awesome!

thanks a lot!

BR Wolfgang

Re: SAP Analytics Cloud limitations in story tables

TuncayKaraca — Wed, 10 Feb 2021 19:04:22 GMT

Thanks Wolfgang, It's pleasure to be helpful!

Re: SAP Analytics Cloud limitations in story tables

DebjitSingha — Wed, 10 Feb 2021 19:05:33 GMT

FYI this limit can be removed (thouhg not recomended) by unchecking "Preservered recomeneded cell limit"

Re: SAP Analytics Cloud limitations in story tables

wolfgang_runge — Wed, 10 Feb 2021 19:08:24 GMT

Thanks a lot, this was very helpful.

Wolfgang

Re: SAP Analytics Cloud limitations in story tables

wolfgang_runge — Wed, 10 Feb 2021 19:24:39 GMT

Debjit,

since a couple of minutes I get a lot of mails from you regarding my acceptance. Please don't bombard me with that.

I appreciate what all you are doing here and is very helpful. But it is also very confusing when to accept an answer and what rules do apply. I don't know any rule!!!

I do my best to satisfy your expectations regarding acceptance. But this system here is also no very userfriendly.

Wolfgang

Re: SAP Analytics Cloud limitations in story tables

DebjitSingha — Wed, 10 Feb 2021 19:29:28 GMT

something going on with my profile today. Comments are getting converted into answers, reason why you may be getting multiple notifications. Beside I updated the solution with additional info. That may have triggered one notification.

-Debjit

Re: SAP Analytics Cloud limitations in story tables

Ranendra — Thu, 15 Sep 2022 11:17:36 GMT

Hello debjit.singha ,

Is there a limitation w.r.t mobile devices in the "edit drill limitation". Kindly check the below screen shot. How can we address this issue.

Re: SAP Analytics Cloud limitations in story tables

rpuranik — Thu, 17 Nov 2022 20:55:50 GMT

Hi, I have set the drill limitation to 500 but the alert on the table shows that it requested 24k rows. It's slow when loading the table even when the drill limitation is set to 500 or even 100.

Is there any way to set a Rank on the table chart for faster loading of the table chart?

Thank you