企业绩效管理网

 找回密码
 立即注册

QQ登录

只需一步,快速开始

查看: 419|回复: 4

Convert all data to UPPERcase

[复制链接]

83

主题

388

帖子

565

积分

高级会员

Rank: 4

积分
565
QQ
发表于 2014-3-15 04:37:30 | 显示全部楼层 |阅读模式
Hi,

Is there an easy way to convert all TM1Web active forms data to UPPER case when users enter data in lower-case?

I tried dimensional attribute formatting (cube displays value in uppercase however still it stores in lowercase and displays lowercase in TM1Web), TM1 Excel perspectives conditional formatting (Excel cell format) however i am unable to achieve, could anyone help me to convert strings to uppercase once user enter a value in the cell (TM1Web) - without using VBA macro.

Thanks & Regards,
Logan
回复

使用道具 举报

71

主题

397

帖子

558

积分

高级会员

Rank: 4

积分
558
QQ
发表于 2014-3-15 07:01:07 | 显示全部楼层
Have tried having an entry measure, then using rules convert this to upper case for the final measure?
回复 支持 反对

使用道具 举报

79

主题

430

帖子

606

积分

高级会员

Rank: 4

积分
606
QQ
发表于 2014-3-15 07:31:43 | 显示全部楼层
If the active form is based on an Excel sheet then you simply have the user input to a specified column, which has no formulas in it, and you send the UCASE of that column to TM1 via a DBSW. If you are talking about a cube view then no can do.
回复 支持 反对

使用道具 举报

70

主题

357

帖子

523

积分

高级会员

Rank: 4

积分
523
QQ
发表于 2014-3-15 07:33:03 | 显示全部楼层
LoganNSE wrote:Is there an easy way to convert all TM1Web active forms data to UPPER case when users enter data in lower-case?

I tried dimensional attribute formatting (cube displays value in uppercase however still it stores in lowercase and displays lowercase in TM1Web), TM1 Excel perspectives conditional formatting (Excel cell format) however i am unable to achieve, could anyone help me to convert strings to uppercase once user enter a value in the cell (TM1Web) - without using VBA macro.
Is the entry in TM1 web or in Excel?  If it's TM1 Web then obviously VBA is out of the question anyway since there is no VBA support for websheets.  TM1 doesn't have an event triggered on action model with "events" that can have code added to perform specific actions.  Therefore as others have said there is no immediate way to convert string entry to uppercase.  You could however quite easily set up a background process to convert and replace strings with the uppercase equivalent which could run periodically and so fix up any lowercase data entry.

(I think it would be great if TM1 could support cube or even measure specific data entry events that would allow programmatic checks, manipulation or to fire other processes but I don't get the feeling it is a development priority.)
回复 支持 反对

使用道具 举报

67

主题

416

帖子

566

积分

高级会员

Rank: 4

积分
566
发表于 2014-3-15 07:50:44 | 显示全部楼层
lotsaram wrote:[quote]LoganNSE wrote:Is there an easy way to convert all TM1Web active forms data to UPPER case when users enter data in lower-case?

I tried dimensional attribute formatting (cube displays value in uppercase however still it stores in lowercase and displays lowercase in TM1Web), TM1 Excel perspectives conditional formatting (Excel cell format) however i am unable to achieve, could anyone help me to convert strings to uppercase once user enter a value in the cell (TM1Web) - without using VBA macro.
Is the entry in TM1 web or in Excel?  If it's TM1 Web then obviously VBA is out of the question anyway since there is no VBA support for websheets.  TM1 doesn't have an event triggered on action model with "events" that can have code added to perform specific actions.  Therefore as others have said there is no immediate way to convert string entry to uppercase.  You could however quite easily set up a background process to convert and replace strings with the uppercase equivalent which could run periodically and so fix up any lowercase data entry.

(I think it would be great if TM1 could support cube or even measure specific data entry events that would allow programmatic checks, manipulation or to fire other processes but I don't get the feeling it is a development priority.)
[/quote]

I guess the viability of this would depend on turn around times. They may need to see the submissions straight away. Doing it by either rule or TI leaves an overhead. With TI your introducing an extra step were as with a rule you have to add extra elements which may seem confusing to users unless well managed. Either way you are right about entry events.
回复 支持 反对

使用道具 举报

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

本版积分规则

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

GMT+8, 2020-10-20 18:57 , Processed in 0.186276 second(s), 14 queries , Memcache On.

Powered by Discuz! X3.1 Licensed

© 2001-2013 Comsenz Inc.

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