Web-sheet loading time drastically increased

Post Reply
manoj928
Posts: 60
Joined: Thu Mar 17, 2011 2:13 pm
OLAP Product: IBM Cognos TM1
Version: 10.2.1
Excel Version: 2010

Web-sheet loading time drastically increased

Post by manoj928 »

Hello ALL,

We had one web-sheet which was opened in TM1 in 20 secs, and now after adding one more column, it started taking around 2 mins of time. So not sure, what could be the possible reasons. we are on TM1 9.5.2 FP2. We saved the file in 97-2003 version in excel as it was and the after making changes, we updated it.

Any suggestion!!!!

Thanks,
Manoj
User avatar
George Regateiro
MVP
Posts: 326
Joined: Fri May 16, 2008 3:35 pm
OLAP Product: TM1
Version: 10.1.1
Excel Version: 2007 SP3
Location: Tampa FL USA

Re: Web-sheet loading time drastically increased

Post by George Regateiro »

Did this new column exceed the bounds of your view (or RPTVIEW if an active form) statement? If you are requesting items out of this range then you can easily bloat load and calc times .
Post Reply