Page 1 of 1
Auto Calculation on Active Form is Taking Huge Time to Recal
Posted: Fri Nov 25, 2011 8:49 am
by Acc_Moonwalk
Hi Team,
I am facing a performance issue in TM1 with the Active Forms , It is taking lot of time For Recalculating 1 Cell.
Can anybody has any suggesitions.
Regards
Ashok
Re: Auto Calculation on Active Form is Taking Huge Time to R
Posted: Mon Nov 28, 2011 10:09 am
by Christopher Kernahan
One cell? Why use an active form then? Also, using auto-calc isn't the best idea with TM1.
If it is only one cell, why not build the active form again in a cube and export it, then test if it is still very slow.
In the active form, check that your TM1RPTVIEW statement is accurate - if you have made a lot of modifications to the Active Form you need to check that these have been reflected in this formula.
If it is not the Active Form then the calculation itself may be slow - check this by building the same view in the cube, and slicing it to Excel. If this is faster then it is probably the Active Form.