TI process maximum column limit

Post Reply
yingchai
Posts: 43
Joined: Wed Nov 19, 2014 6:36 am
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2013

TI process maximum column limit

Post by yingchai » Mon May 08, 2017 4:47 am

What is the maximum number of columns in a data file that the TI can process?
I did a test and was able to preview a 348 column file in the Data Source tab.

User avatar
gtonkin
MVP
Posts: 739
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: PAL 2.0.3
Excel Version: 2016 64-bit
Location: JHB, South Africa
Contact:

Re: TI process maximum column limit

Post by gtonkin » Mon May 08, 2017 10:14 am

I had a problem at around 140 columns where it started wrapping the variable names into the preview for variable 1,2,3 etc.
I don't think that I ever had an issue importing, just the preview and it seemed to be something to do with the cumulative length of the variable names more than anything else. Not sure that relying on the preview will actually give you any kind of clarity.

Unfortunately I know this does not help you particularly but you may need to test to see where you get unexpected results, unless someone else responds who has already spent the time. I eventually split my file purely because of timing on the source side.

AmbPin
Regular Participant
Posts: 173
Joined: Sat Mar 20, 2010 3:03 pm
OLAP Product: TM1
Version: 9.5.2
Excel Version: 2007-10

Re: TI process maximum column limit

Post by AmbPin » Tue May 09, 2017 10:13 am

I don't think it is the number of columns as such is a problem but more the total number of characters per line. If I recall correctly the cut off is somewhere just above 4000 chars.

Post Reply