I have a chart with 36 expressions with some currency conversions and scaling. My memory usage on this chart per click is about < 30KB but the calculation time is > 205000.
The chart is a straight table with 6 columns, 4 text, 2 mini charts.
Any thoughts on how to improve my calc time? There are no ifs in the expression except for 1 column. Set Analysis is only using 2 flags per expression. Expressions themselves are simple SUM()/SUM() or SUM().
My fact table has only 4.2M rows with 12 different types of facts all concatenated under one another. The data is SUM'd and GROUP BY for compression. I would expect the calc time to be negligible but it is not that case. Any ideas?
