企业绩效管理网

 找回密码
 立即注册

QQ登录

只需一步,快速开始

查看: 830|回复: 13

Running TI from TM1 web issue.

[复制链接]

77

主题

412

帖子

590

积分

高级会员

Rank: 4

积分
590
QQ
发表于 2014-3-15 09:04:37 | 显示全部楼层 |阅读模式
We have created a TM1 application which will be accessed by more than 500 users.
Volume data should be uploaded by these 500 users which are at different remote locations. We are providing access to TM1 Web & not TM1 Perspective.
The problem is how they can upload data by themselves as if we select any TI Process in TM1 web then we dont have option to select file from our local machine.
That path has to be fixed for all. We do not have any common location for all users where they can upload their files & run the TI process.
Is there any way to achieve this. Please suggest
Thanks & Regards
回复

使用道具 举报

58

主题

393

帖子

540

积分

高级会员

Rank: 4

积分
540
QQ
发表于 2014-3-15 10:10:31 | 显示全部楼层
You made two comments there:
swati_phadtare wrote:That path has to be fixed for all
and
swati_phadtare wrote:We do not have any common location for all users where they can upload their files
They seem to contradict one another - I suggest you resolve that in your application design.
回复 支持 反对

使用道具 举报

83

主题

388

帖子

565

积分

高级会员

Rank: 4

积分
565
QQ
发表于 2014-3-15 10:43:10 | 显示全部楼层
I suggest you resolve that in your application design.
Can you please suggest any idea for the same?
Thanks
回复 支持 反对

使用道具 举报

81

主题

424

帖子

616

积分

高级会员

Rank: 4

积分
616
QQ
发表于 2014-3-15 10:49:31 | 显示全部楼层
I suggest you resolve that in your application design.
Can you please suggest any idea for the same?
Thanks

I think rmackenzie means you should create a common location for users to place their files in, in order to run the TI.

Alternatively, explore using a VBA macro to copy the file using a system account's credentials with access to the folder, and set the TI to run as a Chore on that particular folder.
回复 支持 反对

使用道具 举报

85

主题

408

帖子

596

积分

高级会员

Rank: 4

积分
596
QQ
发表于 2014-3-15 10:57:11 | 显示全部楼层
You could also pass the full path and file name to the data file to the TI process as a parameter and update the data source of the TI process using the DataSourceNameForServer variable at run time. The only negative to this approach is that the process will bomb if the TM1 service does not have security access to the file that is passed.
回复 支持 反对

使用道具 举报

72

主题

369

帖子

527

积分

高级会员

Rank: 4

积分
527
QQ
发表于 2014-3-15 11:31:27 | 显示全部楼层
Is there any way to upload files in TM1 from TM1 Web? We have 500 users which use Web & not perspective. How should they upload files in TM1?
Thanks & Regards
回复 支持 反对

使用道具 举报

81

主题

389

帖子

575

积分

高级会员

Rank: 4

积分
575
QQ
发表于 2014-3-15 11:32:08 | 显示全部楼层
swati_phadtare wrote:Is there any way to upload files in TM1 from TM1 Web? We have 500 users which use Web & not perspective. How should they upload files in TM1?
Thanks & Regards
You've already been given a few pointers on how you could do this so asking more about a feature that doesn't exist isn't going to get you any further.  Out of the box you live with users specifying a UNC path and file name as a string and then clicking an action button to run a TI to load the file specified. (Note although this will certainly work validation of the file format and reporting of status of the load back to the end user is certainly going to be limited.)  If this isn't good a good enough solution then you could undertake a bit of custom development to add a button or menu to the standard TM1 Web toolbar to launch an external web application to ftp a nominated file, validate it, then use the api to load the data or launch a TI to do the load.  However, that's not a path I would recommend as the custom development will take time and money and make any future upgrade much more difficult.  What you could do is still have an external app do the ftp and validate the file format but just launch this via a hyperlink in a TM1 websheet.  That way you cut out the customization and have something that is almost as "integrated".   Or you simply have a 2 step process with some other interface of your choosing to handle the bulk file load requirement.
回复 支持 反对

使用道具 举报

71

主题

397

帖子

558

积分

高级会员

Rank: 4

积分
558
QQ
发表于 2014-3-15 11:33:16 | 显示全部楼层
lotsaram wrote: What you could do is still have an external app do the ftp and validate the file format but just launch this via a hyperlink in a TM1 websheet.  That way you cut out the customization and have something that is almost as "integrated".   Or you simply have a 2 step process with some other interface of your choosing to handle the bulk file load requirement.

lotsaram is right.  If you take a look at "Javascript File Browser" on google you will quickly find sample code that can be pasted into an html document that will allow an end user to browse for a file and then upload to a location you control.  We have tested this and works fine.
回复 支持 反对

使用道具 举报

93

主题

423

帖子

630

积分

高级会员

Rank: 4

积分
630
QQ
发表于 2014-3-15 12:27:01 | 显示全部楼层
lotsaram wrote: What you could do is still have an external app do the ftp and validate the file format but just launch this via a hyperlink in a TM1 websheet.
Good luck getting any IT department to OK that. You're effectively by-passing any Windows-based security when you do that. I don't know of a single IT department that's going to let you implement that. Why not just set up a share on the TM1 server, create an AD group that has READ and WRITE access to that share, and make the users a member of that group. Then they can just copy the file up with Windows Explorer.
回复 支持 反对

使用道具 举报

70

主题

437

帖子

587

积分

高级会员

Rank: 4

积分
587
QQ
发表于 2014-3-15 12:54:44 | 显示全部楼层
My guess would be that if you have 500 users, that doesn't mean 500 sites, so there is no need to store the files on their local machines. That would probably not be that secure, eg if someone loses their laptop. I would also guess that you don't have 500 individual files to upload. You mentioned high volume data. Presumably the low volume data, eg their plans are just being typed in?

I would guess that you probably only have a few sites. If so then assuming that there is a file server at each site, then set up an area where the large files must be placed, and map a network drive to each site's File Server on the TM1 Server.

If file access is not practical and validation etc is required, then the better approach would be to stage the data in your IT Depts preferred relational database, and then you only need one ODBC connection to that database from TM1.

I suggest that you have a word with your IT Dept to see what they would prefer. My guess would be that if you have high volumes of data, then it is either coming out of an IT system, or you have purchased it from outside? If the data files are extracts from IT Systems, then it might be easier to just go directly to that IT System.

Regards

Paul Simon
回复 支持 反对

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

QQ|手机版|小黑屋|企业绩效管理网 ( 京ICP备14007298号   

GMT+8, 2020-9-21 14:53 , Processed in 0.187992 second(s), 13 queries , Memcache On.

Powered by Discuz! X3.1 Licensed

© 2001-2013 Comsenz Inc.

快速回复 返回顶部 返回列表