ASCII data source file

Post Reply
winsonlee
Regular Participant
Posts: 180
Joined: Thu Jul 01, 2010 3:06 am
OLAP Product: Cognos Express
Version: 9.5
Excel Version: 2007
Location: Melbourne, Australia

ASCII data source file

Post by winsonlee »

I would like to find out if this is TM1 limitation or there is any other way i can do this ?

when i use data file as my datasource type, the preview only shows the first 10 rows of the file. I am using * as my delimiter and the maximum column it can go is 15.

for the first 10 rows, the maximum column i have is only 10 and starting row 12, the total column number will be 15.

so how can i make it in a way to define 15 columns instead of default it define as 10 ?
Alan Kirk
Site Admin
Posts: 6667
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: ASCII data source file

Post by Alan Kirk »

winsonlee wrote:I would like to find out if this is TM1 limitation or there is any other way i can do this ?

when i use data file as my datasource type, the preview only shows the first 10 rows of the file. I am using * as my delimiter and the maximum column it can go is 15.

for the first 10 rows, the maximum column i have is only 10 and starting row 12, the total column number will be 15.

so how can i make it in a way to define 15 columns instead of default it define as 10 ?
You don't have to use the live data source when you're defining your TI process. Just make a copy of the file, cut out the first 11 rows so that the new first row is what was row 12 of your original file, and point to that as your data source. That way you will get the 15 variables defined for your columns. Set them to whatever data types you need them to be. When you're finished you can change the data source back to your original file. As long as you leave the Variables tab alone when you're editing the TI process you won't lose the 15 columns.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
winsonlee
Regular Participant
Posts: 180
Joined: Thu Jul 01, 2010 3:06 am
OLAP Product: Cognos Express
Version: 9.5
Excel Version: 2007
Location: Melbourne, Australia

Re: ASCII data source file

Post by winsonlee »

thanks for the reply. this information is helpful!
Post Reply