1.Use FIX instead of cross-dimensional operator
Compare the next 2 statements:
Fix(Jan)
Sales = Sales * 1.05;
EndFIX
Sales(Sales -> Jan = Sales -> Jan * 1.05);
The 2nd is not efficient, it will look through all of time dimension even if only the Jan is calculated. The 1st one only calculate the Jan for sales block which is more efficient.
2. The data block size setting
It should be 10k - 100k, if the data blick size is too big(>100k), the intelligent calculation will not work well. If the data block size is too small(nearby 10k), the index may become too huge, and this will affect the calculation speed.
