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
Auto Calculation on Active Form is Taking Huge Time to Recal
-
Acc_Moonwalk
- Posts: 32
- Joined: Fri May 27, 2011 9:06 am
- OLAP Product: TM1
- Version: 9.4
- Excel Version: 2003
-
Christopher Kernahan
- Community Contributor
- Posts: 147
- Joined: Mon Nov 29, 2010 6:30 pm
- OLAP Product: Cognos TM1
- Version: 10.1
- Excel Version: Office 2010
Re: Auto Calculation on Active Form is Taking Huge Time to R
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.
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.