IBM Support

PM78147: IN THE TI EDITOR THE TAB "VARIABLES" DOES NOT RESPECT THE DECIMAL SEPARATOR SET IN THE TAB "DATA SOURCE".

Subscribe

You can track all active APARs for this component.

 

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