Forum Discussion
Matrix exceeds available resources
Hello All, I am building a report (matrix) which is composed of about 50 calculated rows and about 20 calculated columns. the difference between columns is a first set of Actuals (dynamic actual...
HI ggmm17,
Currently I also not found any effective solution or workaround to handle with this scenario which caused by too many calculations.
What type of data source are you worked? If it supports 'live connection' mode, I'd like to suggest you consider create a standalone report and put these heavy calculations expression on the database side to use 'live connection' mode to link to the remote database.
For this scenario, these calculations are handled on the database side, and they should help you to reduce the resource spend and prevent the exceed to limitation issue.
Regards,
Xiaoxin Sheng