Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Experts - Any idea what is the work around for this? While adding the cumulative calculation field in an straight table, my dashboard performance is degrading (takes 5 to 10 Mins to refresh). Plz Help.. Let me know if any other info is required?
Thanks!
Bharani
How many dimensions you have in the table? . Also just for testing can you reduce the data to around 5L and use the same expression and check the result it could be either because of RAM or a poor data model
I assume that you want to calculate it on many rows within the straight-table and this will take some time because each single row will need a separate calculation on the virtual table within the background: Logical Inference and Aggregations.
Personally I don't remember any special performance-issues with this kind of object and calculation but I remember other discussions about poor performance on it. One way to improve the performance could be to limit your table-rows by removing/replacing some very granular dimensions and/or conditions within the object/dimensions to display max. n number of rows.
A more general approach would be to look if there are possible optimizations within the datamodel - snowflake models or link-table approaches will have a lower gui-performance than a star-scheme or a big flat-table.
- Marcus