Hi guys,
I've been googling but so far have only found this link describing the limit of the size of the clipboard that is used to paste large blocks of data into Tm1web:
http://www-01.ibm.com/support/docview.w ... wg1PM68338
I'm trying to find out what the limits are regarding how much data can be pasted into a websheet. Our users typically take snapshots of websheets, fill these in offline (however their processes dictate this collection of info through the various depts.) and then certain accountants feed this info back into Tm1web. We've found limitations in the size of a block of data (number of rows and columns) that can be pasted into the web - does anyone have any useful links or info regarding the actual specifics of this limit?
I've stumbled upon the following:
Cant paste more than 1350 rows of elements (single column of text)
can't paste more than around 1800 cells (68 rows and 27 columns) of data
I don't see any config in web.config to indicate that this is a parameter that can be changed.
Many thanks guys.
Websheet paste limitation
-
- Posts: 141
- Joined: Wed Nov 14, 2012 10:37 am
- OLAP Product: TM1
- Version: 2.0
- Excel Version: Office 365
-
- MVP
- Posts: 600
- Joined: Wed Aug 17, 2011 1:19 pm
- OLAP Product: TM1
- Version: 9.5.2 10.1 10.2
- Excel Version: 2003 2007
- Location: York, UK
Re: Websheet paste limitation
Have a look at this ASP.NET configuration page and in particular at the Configuring JSON serialization section.