time requirement for F9/ALT-F9/SHIFT-F9 for slice versus active form of cube view

Post Reply
Schatrandsch
Posts: 3
Joined: Tue Jun 12, 2012 8:29 pm
OLAP Product: Planning Analytics/TM1
Version: 2.0.6
Excel Version: 2016

time requirement for F9/ALT-F9/SHIFT-F9 for slice versus active form of cube view

Post by Schatrandsch » 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

Post Reply