Hi all,
i have a Ti process, in that we are taking data source as .Csv file
Recently we have moved into cloud and we have migrated everything into cloud and in here
the file in shared location which has user name and password
when i am trying to browse the file what i need to keep in
The processing is failing saying this, it is unable to pick the file from the source
I have even tried like
Data source name :- \\data\s\prod\Source files\Facilities \Facilities Allocation.US.csv
Data source name on server :- .\Facilities Allocation.US.csv
But no luck can you please help me out
import file from a specific network
-
- Posts: 18
- Joined: Fri Mar 06, 2020 4:48 pm
- OLAP Product: Cognos TM1
- Version: 10.2
- Excel Version: office 365
import file from a specific network
- Attachments
-
- data source names and path and error
- issue 2.PNG (160.42 KiB) Viewed 3181 times
-
- file where it is placed
- issue 1.PNG (42.18 KiB) Viewed 3181 times
-
- 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: import file from a specific network
try replacing "\\data\s\" with "s:\"
-
- Posts: 74
- Joined: Mon May 12, 2008 12:25 pm
- OLAP Product: TM1
- Version: PA 2.0.6 Local
- Excel Version: Excel 2016
Re: import file from a specific network
We've just been through this at our place.
So, for what it's worth, we ended up having to qualify the network names more completely.
For example, \\server\fileshare\folder needed to become \\server.some.domain.stuff\fileshare\folder
Not sure if it was unique to our setups but the reason explained to us was because the server was on a different domain we needed to give it a fully qualified name. Works fine now.
So, for what it's worth, we ended up having to qualify the network names more completely.
For example, \\server\fileshare\folder needed to become \\server.some.domain.stuff\fileshare\folder
Not sure if it was unique to our setups but the reason explained to us was because the server was on a different domain we needed to give it a fully qualified name. Works fine now.
-
- Posts: 18
- Joined: Fri Mar 06, 2020 4:48 pm
- OLAP Product: Cognos TM1
- Version: 10.2
- Excel Version: office 365
Re: import file from a specific network
Yes, when i enter the server name, it pops up for windows securities like user name and password
i have those with me but how can i implement it
for example :- when i am taking that server name and entering into file explorer it pops up for windows securities
user name and password
can you please let me know where can i pass those user id and password
i have those with me but how can i implement it
for example :- when i am taking that server name and entering into file explorer it pops up for windows securities
user name and password
can you please let me know where can i pass those user id and password
-
- 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: import file from a specific network
This seems just like the normal or classic case of making sure that the service account which runs the TM1 server instancekalyan846 wrote: ↑Fri May 22, 2020 9:59 am Yes, when i enter the server name, it pops up for windows securities like user name and password
i have those with me but how can i implement it
for example :- when i am taking that server name and entering into file explorer it pops up for windows securities
user name and password
can you please let me know where can i pass those user id and password
- is not the buiilt-in "local admin" account
- has network access
- specifically has read access to the folder containing the source file
The preview window is populated by DatasourceNameForClient which in turn depends on the access rights of the user openign the TI process editor. This is different from DatasourceNameForServer which is accessed at runtime by the service account.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
-
- MVP
- Posts: 2832
- Joined: Tue Feb 16, 2010 2:39 pm
- OLAP Product: TM1, Palo
- Version: Beginning of time thru 10.2
- Excel Version: 2003-2007-2010-2013
- Location: Atlanta, GA
- Contact:
Re: import file from a specific network
I assume you are talking about the IBM Cloud, correct? Based on your screen shot here are your settings:kalyan846 wrote: ↑Thu May 21, 2020 6:48 pm Hi all,
i have a Ti process, in that we are taking data source as .Csv file
Recently we have moved into cloud and we have migrated everything into cloud and in here
the file in shared location which has user name and password
when i am trying to browse the file what i need to keep in
The processing is failing saying this, it is unable to pick the file from the source
I have even tried like
Data source name :- \\data\s\prod\Source files\Facilities \Facilities Allocation.US.csv
Data source name on server :- .\Facilities Allocation.US.csv
But no luck can you please help me out
Data Source Name:
Code: Select all
\\data\s\prod\SourceFiles\Facilities\Facilities Allocation US.csv
Code: Select all
s:\prod\SourceFiles\Facilities\Facilities Allocation US.csv