APAR status
Closed as Permanent restriction.
Error description
It looks like the tab "Variables" is using the decimal separator set in the Windows Regional Settings of the Windows Client running the TI Editor and not the decimal separator set in the tab "Data Source" of a TI process. You created a new TI process. In the first tab "Data Source" of the TI Editor you explicitely set the decimal separator in the entry field "Decimal Separator". In the second tab "Variables" of the TI Editor you used the button "New Variable" to create a new variable. The formula you attached to the new variable performs a mathematical operation, for instance calculating a sum like V3=V1+V2. Thus you set the Variable Type of the formula's operands V1 and V2 to "Numeric". Later on you open your new TI process in a TI Editor running on a Windows Client whose decimal separator set in the Windows Regional Settings is different from the decimal separator set in the TI process. When this condition is meet, when you click on the second tab "Variables" a warning is returned: TM1 Warning Some problems occured while getting the sample values for the following variables. The use of these variables in a formula will cause a "variable is undefined" error. To correct this you can either ignore the variable or fix the specific problem for each one of them. <variable name>: Cannot convert string to a number. In the second tab "Variables", when you click on the button "Formula" to open the formula attached to the new variable in the Process Variable Formula Editor, a warning is returned: TM1 Warning Some problems occured while getting the sample values for the following variables. The use of these variables in a formula will cause a "variable is undefined" error. To correct this you can either ignore the variable or fix the specific problem for each one of them. <variable name>: Cannot convert string to a number. But the TI process itself can be successfully executed and will deliver the correct results.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * All Users * **************************************************************** * PROBLEM DESCRIPTION: * * See error description. * **************************************************************** * RECOMMENDATION: * * This is a known minor limitation of the TI Editor and an * * acceptable workaround exists. * * * * The workaround is to set the Variable Type of the formula's * * operands to "String" instead of "Numeric", then alter the * * formula to perform a type conversion of the operands from * * string to number using the TI function StringToNumberEx * * before performing the mathematical operation. The decimal * * separator and the thousand separator used as arguments of * * the TI function StringToNumberEx are identical to the ones * * set in the first tab "Data Source" of the TI Editor. * * * * For instance: * * The formula * * V3=V1+V2; * * has to be rewritten as * * V3=StringToNumberEx(V1, ',', '.')+StringToNumberEx(V2, * * ',', '.'); * ****************************************************************
Problem conclusion
No Intent to Fix
Temporary fix
Comments
APAR Information
APAR number
PM78147
Reported component name
TM1 TURBO INTEG
Reported component ID
5724W49TI
Reported release
A10
Status
CLOSED PRS
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2012-11-29
Closed date
2014-10-31
Last modified date
2014-10-31
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Applicable component levels
[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SS9RXT","label":"Cognos TM1"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1.0","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
21 September 2021