Auto Recalculate

Post Reply
sreecharan
Posts: 9
Joined: Mon Apr 04, 2011 7:03 pm
OLAP Product: TM1
Version: 9.5.1
Excel Version: 2007

Auto Recalculate

Post by sreecharan »

How to set auto recalculate In TM1 after entering data instead selecting recalculate icon on the cube viewer, and the same to contributor?

thanks
TM1 9.5.1
excel 2007
User avatar
rkaif
Community Contributor
Posts: 328
Joined: Fri Sep 05, 2008 6:58 pm
OLAP Product: IBM Cognos TM1
Version: 9.1 or later
Excel Version: 2003 or later

Re: Auto Recalculate

Post by rkaif »

You can hit F9 key to refresh the view. By default the view does not get refreshed and I think there is a good reason for that - when you have large view with lots of calcs then you will face performance issues. Also when you will be recalculating the view after every single entry then you will using Server/Network resources repeatedly and once again this will effect the overall performance.
Cheers!
Rizwan Kaif
Post Reply