TM1 Forum

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

Have tried having an entry measure, then using rules convert this to upper case for the final measure?

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.

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.)

lotsaram wrote:

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.)

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.