Location of the file accessible from the Cognos TM1 server

Post Reply
DanielSosa
Posts: 2
Joined: Thu Feb 07, 2019 3:15 pm
OLAP Product: TM1
Version: 2.0.6
Excel Version: Excel 2013

Location of the file accessible from the Cognos TM1 server

Post by DanielSosa » Mon Feb 11, 2019 11:54 pm

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.

User avatar
Steve Rowe
Site Admin
Posts: 1933
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: 10.2.2., PAW
Excel Version: Nearly all of them

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

Post by Steve Rowe » Tue Feb 12, 2019 5:09 pm

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

lotsaram
MVP
Posts: 3276
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

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

Post by lotsaram » Tue Feb 12, 2019 10:05 pm

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.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.

DanielSosa
Posts: 2
Joined: Thu Feb 07, 2019 3:15 pm
OLAP Product: TM1
Version: 2.0.6
Excel Version: Excel 2013

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

Post by DanielSosa » Thu Feb 14, 2019 9:15 pm

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

Post Reply