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 ?
ASCII data source file
-
- 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
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.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 ?
"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.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-
- 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
thanks for the reply. this information is helpful!