Page 1 of 1

Location of the file accessible from the Cognos TM1 server

Posted: Mon Feb 11, 2019 11:54 pm
by DanielSosa
Hi gurus,

I'm new in the forum so hello to everyone.

Sorry if my question is too basic. I need to load data from .txt files into tm1 cubes with TI processes. I have 6 proccesses, 5 to update dimensions and 1 to load data. I need a process to call the 6 processes and then create a chore to automate the data load everyday.

My tm1 server is linux (ubuntu). When I choose a file as datasource in the process I get this warning.

The "Location of the file accessible from the Cognos TM1 server" field is not specified properly or the specified file can not be accessed from the TM1 server. For a process to run when scheduled as part of a chore, the file location must be accessible from the TM1 server. If you do not specify a proper file location, it will not be possible to schedule a refresh of the data using a chore.

I can open and run a process but when I use the process that call all the processes it fails.

The .txt files are locate in the windows client. Where is the proper file location?

I've tried to create a process with the file in the linux server and I can't see those files from the windows client.

Please tell me how can I use files with linux tm1 server and the windows client and create a chore with the processes.

Thanks in advance.

Re: Location of the file accessible from the Cognos TM1 server

Posted: Tue Feb 12, 2019 5:09 pm
by Steve Rowe
Hi Daniel,

In the TI process there are two paths to set the first is the path from the point of view of the server, the other is from the point of view of the client, i.e. where you opened the TI editor screen.

So at runtime the first of these paths is used, if the TM1 server on the Ubuntu box can't see the path then the process will fail.

To get everything running error free you need a common location that is visible from both the client and the server, often the paths will be different.

HTH

Re: Location of the file accessible from the Cognos TM1 server

Posted: Tue Feb 12, 2019 10:05 pm
by lotsaram
Steve Rowe wrote: Tue Feb 12, 2019 5:09 pm To get everything running error free you need a common location that is visible from both the client and the server, often the paths will be different.
I find it easier to think of DatasourceNameForClient as what is used for the sole purpose of populating the preview window and setting the variables tab. Whereas DatasourceNameForServer is used at runtime. When the process executes the client path is irrelevant, only the server path matters. The server path must be accessible from the perspective of the user which the service is running under. If this isn't a local partition on the server then it should be entered as a UNC path.

Just remember, whatever user the server runs under must be able to access this directory. Whether your user can access the file is not relevant when the process runs.

Re: Location of the file accessible from the Cognos TM1 server

Posted: Thu Feb 14, 2019 9:15 pm
by DanielSosa
Hi guys,

Thanks for your help.

I created a share folder in my windows client and I'm gonna install cifs-utils on my linux server in order to see that folder. Then I will try with UNC path on my processes.

Regards,
Daniel