Forum Discussion
Default item calculation groups
Hi burakg ,
Regarding your question, is your data volume very large? I think your initial solution is more intuitive and easier to implement.
Best Regards,
Wenbin Zhou
It depends, usually a project takes about 100-200k rows, but occasionally it also goes into the multiple millions of rows for the dataset.
Is there a known performance impact of using variables this way?
I did do a performance test of the old switch solution vs the new calculation group methodology with the variable, and it looks like the performance of refreshing reports is almost similar.
Hi bgc200 ,
I don't have experience with very large data sets. But when you use a variable, it will only evaluate the expression once and store the result in the corresponding variable. This is good for performance.
Best Regards,
Wenbin Zhou
