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.
TI process maximum column limit
- gtonkin
- MVP
- Posts: 1199
- Joined: Thu May 06, 2010 3:03 pm
- OLAP Product: TM1
- Version: Latest and greatest
- Excel Version: Office 365 64-bit
- Location: JHB, South Africa
- Contact:
Re: TI process maximum column limit
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.
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.
-
- 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
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.