Load File

Post Reply
manu0521
Posts: 124
Joined: Wed Nov 26, 2014 8:32 pm
OLAP Product: IBM TM1, Planning Analytics
Version: PA 2.0.5
Excel Version: 2016

Load File

Post by manu0521 »

Hi ,

I have a flat file that is semicolon sepearated as a source .

The file has something like this .

ABC;bcd;12;
BCD;AAA;15;V;

There is a column that comes in few lines later in the source , so i hae an isue that my variales tab is picking up my ata base on line 1 I guess

so is there a any way to get aroun this to decie the columns based on the whole file .

Thanks,
ascheevel
Community Contributor
Posts: 287
Joined: Fri Feb 15, 2013 5:49 pm
OLAP Product: TM1
Version: PA 2.0.9.1
Excel Version: 365
Location: Minneapolis, USA

Re: Load File

Post by ascheevel »

You can use a template file that has as many columns as you want as the datasource when setting up the TI process and then point the DatasourceNameForServer variable to the actual file in the prolog tab of your TI process.
Post Reply