SAP Analytics Cloud limitations in story tables

[wolfgang_runge]

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

[wolfgang_runge]

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

[DebjitSingha]

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

[DebjitSingha]

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

[Ranendra]

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.

[rpuranik]

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

[wolfgang_runge]

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

thanks a lot!

BR Wolfgang

[TuncayKaraca]

Thanks Wolfgang, It's pleasure to be helpful!

[wolfgang_runge]

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

[TuncayKaraca]

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

[DebjitSingha]

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

[wolfgang_runge]

Thanks a lot, this was very helpful.

Wolfgang

[TuncayKaraca]

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:

• Column/row limitation in Table component – SAP Analytics Cloud
• Best Practices for Performance