Shift-F9 <> "Calculate Sheet"

[seerwright]

I've been poking around in the forum for something on this. Either it's not here or I'm missing it. Hopefully it's the former. My issue: I'm using CX 10.1 and have installed my clients using the the Cognos dashboard link against my local TM1 server. We're using Excel 2010. What I'm seeing is that F9 is quite a bit faster (~4x) at refreshing than clicking Formulas > "Calculate Now" and, likewise, Shift-F9 is faster than clicking Formulas > "Calculate Sheet". I thought F9 and Shift-F9 were just shortcuts to the calculate buttons on the Formulas ribbon. What I'm seeing suggests otherwise. Is this a known issue? Any thoughts?

[tomok]

I've been poking around in the forum for something on this. Either it's not here or I'm missing it. Hopefully it's the former. My issue: I'm using CX 10.1 and have installed my clients using the the Cognos dashboard link against my local TM1 server. We're using Excel 2010. What I'm seeing is that F9 is quite a bit faster (~4x) at refreshing than clicking Formulas > "Calculate Now" and, likewise, Shift-F9 is faster than clicking Formulas > "Calculate Sheet". I thought F9 and Shift-F9 were just shortcuts to the calculate buttons on the Formulas ribbon. What I'm seeing suggests otherwise. Is this a known issue? Any thoughts?

Do a search on TM1 Ribbon. It can cause problems so you may want to disable it.

[seerwright]

I thought that issue was only Excel 2007, but I'll check it out. It's a good thought. I chased my tail for a couple of hours this morning before I figured this subtlety out.

[lotsaram]

I thought F9 and Shift-F9 were just shortcuts to the calculate buttons on the Formulas ribbon. What I'm seeing suggests otherwise. Is this a known issue? Any thoughts?

It is not so much a "known issue" as a known fact of running the TM1 add-in. Try for yourself and record a macro of F9 and shift+F9 with and without TM1 running and you will get Applicaton.Calculate and Activesheet.Calculate versus Application.Run "TM1RECALC" and Application.Run "TM1RECALC1"

Perspectives runs these macros on the calculation hotkeys and takes over control of calculation which enables more efficient ordering and batching of communication back and forth between client and TM1 server and therefore faster recalculation times, especially with proper use of VIEW and DBRW formulas. If you let normal Excel calculation sequence and priority manage the calculation of formulas Excel sees as volatile that TM1 sees as batch it stands to reason that performance won't be at the same level.

The issue of Ribbon re-drawing on cell context change is another issue. It is also not great for performance, especially with 2007 and 9.4/9.5.1 - vastly improved with 9.5.2/10.1 and 2010 but can still slow down especially over Citrix and poor networks. But I think the root of your question is as explained above.

[Tetsuo331]

I've been poking around in the forum for something on this. Either it's not here or I'm missing it. Hopefully it's the former. My issue: I'm using CX 10.1 and have installed my clients using the the Cognos dashboard link against my local TM1 server. We're using Excel 2010. What I'm seeing is that F9 is quite a bit faster (~4x) at refreshing than clicking Formulas > "Calculate Now" and, likewise, Shift-F9 is faster than clicking Formulas > "Calculate Sheet". I thought F9 and Shift-F9 were just shortcuts to the calculate buttons on the Formulas ribbon. What I'm seeing suggests otherwise. Is this a known issue? Any thoughts?

Do a search on TM1 Ribbon. It can cause problems so you may want to disable it.

Hi,
Do you mean to disable the TM1 Ribbon without unloading the Perspectives Macro? If so, how do you do this?
Omar

[lotsaram]

Do you mean to disable the TM1 Ribbon without unloading the Perspectives Macro? If so, how do you do this?

Elementary dear Watson, just rename or delete tm1pRibbonX.xlam from the client bin directory (no TM1 ribbon the next time you load Perspectives, you'll get TM1 toolbars in the Add-Ins ribbon tab instead).

[Tetsuo331]

Do you mean to disable the TM1 Ribbon without unloading the Perspectives Macro? If so, how do you do this?

Elementary dear Watson, just rename or delete tm1pRibbonX.xlam from the client bin directory (no TM1 ribbon the next time you load Perspectives, you'll get TM1 toolbars in the Add-Ins ribbon tab instead).

Of course! What was I thinking about? I'll try this as soon as possible!
Thank you !

[Tetsuo331]

Do you mean to disable the TM1 Ribbon without unloading the Perspectives Macro? If so, how do you do this?

Elementary dear Watson, just rename or delete tm1pRibbonX.xlam from the client bin directory (no TM1 ribbon the next time you load Perspectives, you'll get TM1 toolbars in the Add-Ins ribbon tab instead).

Of course! What was I thinking about? I'll try this as soon as possible!
Thank you !

Works for me! Thanks!

[seerwright]

lotsaram- Great answer. I've been using TM1 a while and never knew that. I guess I've never come across a user who uses the actual calculate buttons until recently, so the question hasn't come up.