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
time requirement for F9/ALT-F9/SHIFT-F9 for slice versus active form of cube view
-
- Posts: 3
- Joined: Tue Jun 12, 2012 8:29 pm
- OLAP Product: Planning Analytics/TM1
- Version: 2.0.6
- Excel Version: 2016