TM1Web Websheet Snapshot to Excel taking too long

Post Reply
tm123
Posts: 132
Joined: Thu Oct 23, 2014 10:15 pm
OLAP Product: tm1, cognos bi
Version: 10.2
Excel Version: 2010

TM1Web Websheet Snapshot to Excel taking too long

Post by tm123 »

Hi Guys,

We have a websheet with an Active Form ( which has a few thousand lines ). The websheet opens fine and refreshes quickly, but when user tries to Snapshot it to excel, it takes way too long, more than an hour.

We are using PA 2.0.5 so has anyone experienced this?

Thanks
User avatar
paulsimon
MVP
Posts: 808
Joined: Sat Sep 03, 2011 11:10 pm
OLAP Product: TM1
Version: PA 2.0.5
Excel Version: 2016
Contact:

Re: TM1Web Websheet Snapshot to Excel taking too long

Post by paulsimon »

Hi

Yes we have the same issue. We deploy Perspectives via Citrix and tell our users to export any big sheets using that. TM1 Web was built for small data capture sheets, not big exports.

You might want to make sure that they aren't ticking any boxes in TM1 Web and effectively generating a print report. However, a 1000 or so lines is probably the issue.

Regards

Paul Simon
jed
Posts: 62
Joined: Wed Sep 02, 2009 11:33 am
OLAP Product: TM1
Version: PA 2.0.9.4
Excel Version: 2016
Location: Australia

Re: TM1Web Websheet Snapshot to Excel taking too long

Post by jed »

We have this issue too in PA 2.07. It appears to be intermittent though and affects static reports too with not many rows.
Post Reply