COGNOiSe.com - The IBM Cognos Community

Planning & Consolidation => TM1 => Topic started by: soulghard on 01 Jun 2011 10:21:01 AM

Title: Constant or environment variable for data path in TI
Post by: soulghard on 01 Jun 2011 10:21:01 AM
Hi everyone,

I'm using TM1 9.5 and I wanted to find a way to use a kind of constant or environment variable in Turbo Integrator.

The basic idea is to define one itme in one place a path to a floder wich contains all my Excel data files which will be used in turbo integrator to load dimensions or cubes.

For now if my folder change, I have to modify the data source name in all IT processes : data source name : c:/mydatafolder/excel.xls
I would like to have something like :  data source name : FOLDER/excel.xls where FOLDER is a configurable value. So change the value once when the folder is changed.

Thanks in advance for your help !
Title: Re: Constant or environment variable for data path in TI
Post by: dusherwo on 02 Jun 2011 08:04:32 AM
Update DataSourceNameForServer in the prolog. You can hold the folder name in a TM1 cube, or pass it in as a parameter. See the Reference Guide files for a fuller explanation.
Title: Re: Constant or environment variable for data path in TI
Post by: soulghard on 07 Jun 2011 03:02:19 AM
Hi,

Thanks for your answer.

Like I saw in the reference guide http://publib.boulder.ibm.com/infocenter/ctm1/v9r4m1/index.jsp?lang=en-EN
I added that to my tm1s.cfg file.
DatasourceNameForServer='C:\DIR\'

But I can't see how to use it in my TI process. The guide is not very well detailed on that part.

Could you help me on this please ?

Title: Re: Constant or environment variable for data path in TI
Post by: soulghard on 07 Jun 2011 04:15:56 AM
I think I got you.
You mean that you have to configure for each TI process the variable in prolog tab ? How you use this variable ?
So it's not generic... for every process you have to change it for each process when the folder is changed.
Title: Re: Constant or environment variable for data path in TI
Post by: dusherwo on 08 Jun 2011 02:05:30 AM
Why did you think TM1 forced you to put all your files in one place?
Suggest you follow up my suggestion of putting the path into a cube and using it in the prolog (via a CellGetS).