UnicodeUpperLowerCase

This configuration parameter instructs the Planning Analytics database to identify and handle Unicode object names, preventing the creation of identical Unicode object names that vary only in case.

Parameter type:https://ibmid.acrolinx.cloud/

  • Optional
  • Static

    If you change this parameter value, restart the Planning Analytics database to apply the new value.

TM1 treats ASCII object names as case-insensitive; the element name SALES is equivalent to sales. A reference to either SALES, sales, or even SaLeS is considered to be a reference to a single element. Similarly, the cube name Projections is equivalent to PROJECTIONS.

However, Unicode object names are not treated as case-insensitive. Consequently, a server can contain two identically named objects that varied only in case. For example, the elements NEMÈIJA and nemèija can exist in a single dimension, and each is considered a unique element.

Include the parameter UnicodeUpperLowerCase=T in your Planning Analytics database configuration if you have developed applications that rely on Unicode object names that vary only in case, and want to maintain such functionality.

Include the parameter UnicodeUpperLowerCase=F in your Planning Analytics database configuration to prevent the creation of identically named Unicode object names that vary only in case. When UnicodeUpperLowerCase=F, Unicode object names are handled just as ASCII object names, and are case-insensitive.

If this parameter is not present in Planning Analytics database configuration, it is set to T by default and Planning Analytics treats Unicode object names as case-sensitive