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.
Location of the file accessible from the Cognos TM1 server
-
- Posts: 2
- Joined: Thu Feb 07, 2019 3:15 pm
- OLAP Product: TM1
- Version: 2.0.6
- Excel Version: Excel 2013
- Steve Rowe
- Site Admin
- Posts: 2417
- Joined: Wed May 14, 2008 4:25 pm
- OLAP Product: TM1
- Version: TM1 v6,v7,v8,v9,v10,v11+PAW
- Excel Version: Nearly all of them
Re: Location of the file accessible from the Cognos TM1 server
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
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
Technical Director
www.infocat.co.uk
www.infocat.co.uk
-
- MVP
- Posts: 3654
- 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
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.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.
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.
-
- 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
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
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