Hello everyone,
Currently, I am creating stories (dashboards + tables) in SAP Analytics Cloud (SAC), I handle all the data preparation in SAP BW/4HANA. There, I have implemented calculation views, composite providers, and BEx queries that fetch data through replication connection via SLT from S/4HANA. Subsequently, using a live connection between BW and SAC, I create models in SAC and then build the stories. The stories simply display the data, and I haven’t implemented any additional calculations.
However, I am facing severe performance issues that I cannot justify, as my dataset is minimal. For instance, one model has only 3,271 rows and 47 columns.
The stories are slow to load, even those that only contain a simple table. This happens across different models that I’ve implemented.
Since I haven’t worked with this specific architecture before, I would greatly appreciate any guidance on where I should start investigating the root cause of these significant performance issues. Any advice would be highly appreciated!