time requirement for F9/ALT-F9/SHIFT-F9 for slice versus active form of cube view
Posted: Tue May 05, 2020 7:18 am
Dear all,
we do
a) slice
b) "active form"
a cube view.
We do measure (several times but it is without fluctuations) afterwards the time needed to recalculate/rebuild the resulting Excel sheet.
a) F9 --> 1 sec.
a) ALT-F9 --> 1 sec.
b) F9 --> 52 sec.
b) ALT-F9 --> 39 sec.
IBM says this is a normal behaviour and states that the additional script that is underlying the active form causes the difference.
What are your experiences for the durations of recalc/refresh/rebuild in comparison for slices and active forms und what are the drivers we could use to lower the time requirement?
Thanks in advance.
Tilo
we do
a) slice
b) "active form"
a cube view.
We do measure (several times but it is without fluctuations) afterwards the time needed to recalculate/rebuild the resulting Excel sheet.
a) F9 --> 1 sec.
a) ALT-F9 --> 1 sec.
b) F9 --> 52 sec.
b) ALT-F9 --> 39 sec.
IBM says this is a normal behaviour and states that the additional script that is underlying the active form causes the difference.
What are your experiences for the durations of recalc/refresh/rebuild in comparison for slices and active forms und what are the drivers we could use to lower the time requirement?
Thanks in advance.
Tilo