Hi ,
We are going for SAC tabular Story with hierarchies extending up to 9 levels and when extending the hierarchies further, there are around 1000000 rows and 20 columns
The SAC story is built on top of multiple CDS views and tables. Since this is a live connection with S4 HANA with data spread across multiple tables in S4 HANA, We would like to know if there will be any memory issues in S4 HANA or at the SAC level. I believe there will be no issues with SAC story.
1) Is there a number of rows limitation with SAC story when created in tabular format
2) When SAC story pulls the data using live connection, what are the chances of memory issues in S4 HANA since this will be a huge set of data.
Let us know your thoughts on the same.
Regards,
AK