企业绩效管理网

 找回密码
 立即注册

QQ登录

只需一步,快速开始

查看: 425|回复: 7

TM1 Web - Prevent entering values on C-Elements

[复制链接]

66

主题

382

帖子

540

积分

高级会员

Rank: 4

积分
540
发表于 2014-3-21 06:48:57 | 显示全部楼层 |阅读模式
Hi guys,

it there any possibility to prevent users to enter values on C-Elements in TM1 Web? Is there any parameter that can be set in webconfig?

What happens now is, that when user enters values (directly, without using right mouse click -> data spreading) on c-elements new value is just spread proportionally on the elements in the hierarchy. Also when zero is entered, it will be populated to the n-elements. Data is directly written to the database, so "review" button is not available and no coming back...

System is TM1 9.5.1 with HF13 64bit.
回复

使用道具 举报

79

主题

412

帖子

581

积分

高级会员

Rank: 4

积分
581
QQ
发表于 2014-3-21 08:08:49 | 显示全部楼层
Hi,

It was a tough day at work for me today, so maybe I'm overlooking something here. I thought this is just not possible... (except for String cells at C-level, but these are not spread obviously).

Wim
回复 支持 反对

使用道具 举报

57

主题

378

帖子

507

积分

高级会员

Rank: 4

积分
507
发表于 2014-3-21 08:52:11 | 显示全部楼层
You should be able use restrict 'input' to C level cells using element security.
Having said that, I'm rather concerned that TM1 is using Relative Proportional Spread without asking or giving you the options.
回复 支持 反对

使用道具 举报

72

主题

369

帖子

527

积分

高级会员

Rank: 4

积分
527
QQ
发表于 2014-3-21 09:52:59 | 显示全部楼层
This new feature is documented (although maybe not given the prominence it deserves). It is there in order for TM1 Contributor (and TM1 Web) to match functionality from EP Contributor, there are also new spreading sort-cuts for Contributor.

Fight new features with new features: Provided you are in personal workspace mode you always have the option not to commit and provided transaction logging is on you can also always undo the data entry.

It is a departure from previous spreading functionality (as is the "are you sure?" prompt on entering "c" which is a good addition) and means behaviour is now inconsistent between web and Excel.  A switch in web.config to have the "classic" behaviour would be nice but I don't think it exists unfortunately.
回复 支持 反对

使用道具 举报

81

主题

411

帖子

598

积分

高级会员

Rank: 4

积分
598
QQ
发表于 2014-3-21 10:07:21 | 显示全部楼层
lotsaram wrote:It is a departure from previous spreading functionality (as is the "are you sure?" prompt on entering "c" which is a good addition) and means behaviour is now inconsistent between web and Excel.

But when "C" is a valid data value which the user wants to enter and TM1 thinks that user is trying to spread/clear values. In that case its painful and one has to go through workarounds.
回复 支持 反对

使用道具 举报

83

主题

416

帖子

588

积分

高级会员

Rank: 4

积分
588
QQ
发表于 2014-3-21 10:56:55 | 显示全部楼层
rkaif wrote:[quote]lotsaram wrote:It is a departure from previous spreading functionality (as is the "are you sure?" prompt on entering "c" which is a good addition) and means behaviour is now inconsistent between web and Excel.

But when "C" is a valid data value which the user wants to enter and TM1 thinks that user is trying to spread/clear values. In that case its painful and one has to go through workarounds.
[/quote]

Agreed. The way I heard it from IBMers pre-9.5, Clear was going to be converted to a multi-key solution. (Hello IBM, the frappin' [Alt] key is there for a reason.) I can only assume that someone far more brilliant in the GUI design department decided on a confirmation dialog instead. I agree with Lotsa that it's an improvement over the original design which was like having a trigger on a thermonuclear bomb without a safety device, but it still leaves the problem that Rizwan referred to... in addition to which confirmation dialogs can get real old, real fast, if you're repeatedly performing an action.

(I have a rather large Atlantic Salmon in the freezer just waiting to be hurled at the head of the genius at Micro$loth who came up with the "If you change a file name extension, the file may become unusable" dialog without providing a checkbox which reads "Well duh, Thank you for telling me but I've been doing this for a while now and don't need to hear the obvious. Shut up and never, ever, bother me with this dialog ever again".)
回复 支持 反对

使用道具 举报

79

主题

430

帖子

606

积分

高级会员

Rank: 4

积分
606
QQ
发表于 2014-3-21 11:14:07 | 显示全部楼层
If the web sheet was created in Excel you can apply protection to the C level cells and users won't be able to enter. I use this all the time for input templates.
回复 支持 反对

使用道具 举报

79

主题

383

帖子

562

积分

高级会员

Rank: 4

积分
562
QQ
发表于 2014-3-21 11:29:57 | 显示全部楼层
Hi guys,

thanks a lot!

It is unfortunately a view - so the only way would be to set Element Security. But i think the users will have to live with undo button.
回复 支持 反对

使用道具 举报

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

本版积分规则

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

GMT+8, 2018-11-14 18:49 , Processed in 0.151917 second(s), 12 queries , Memcache On.

Powered by Discuz! X3.1 Licensed

© 2001-2013 Comsenz Inc.

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