Perspectives recalculation problem - TM1 10.2

Post Reply
glittle
Posts: 5
Joined: Fri Apr 25, 2014 12:18 pm
OLAP Product: TM1
Version: 10.2
Excel Version: 2010

Perspectives recalculation problem - TM1 10.2

Post by glittle »

Hello all

We have recently upgraded from TM1 10.1 to 10.2 and now several users (myself included) are having problems with slow re-calculation in Excel 2010 - similar to what I'd expect to see if someone had a workbook in automatic calculation or if the Application.Calculate method was called in a macro. Worksheets that will take <1s to refresh take 20s etc. This is when they're pressing 'F9' or 'Shift+F9' to recalculate.

In all cases I've seen the workbook is definitely set to manual calculation and the only fix I've found is to re-add the add-in to Excel. This seems to work for a bit but the problem recurs later.

Has anyone come across something similar?

Thanks in advance.
Wim Gielis
MVP
Posts: 3241
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.1.5
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Perspectives recalculation problem - TM1 10.2

Post by Wim Gielis »

Hello

I haven't seen this one before.
Did you raise it with IBM?
Best regards,

Wim Gielis

IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
glittle
Posts: 5
Joined: Fri Apr 25, 2014 12:18 pm
OLAP Product: TM1
Version: 10.2
Excel Version: 2010

Re: Perspectives recalculation problem - TM1 10.2

Post by glittle »

Not yet but will do. The toolbar appears correctly, the buttons and all TM1 formulas 'work' and give the right answer. The only difference is that the splash screen has not been appearing.

If I go to addins, uncheck tm1p, and use the browse menu to add it again it will work correctly for that session but not when Excel is closed and re-opened.

We've got two workarounds for the moment. First is to load Perspectives manually - we don't want to do this because it's not what our users are used to. Second is adding tm1pRibbon.xlam as an addin as well. Don't ask me why this works but it seems to fix our problem.
Post Reply