3292982 - Dimensions names are automatically modified in SAC model based on any import data connection if the source column's name is bypassing 21 characters

Dimensions names are cut off and appended with strange reference in SAC model based on any import data connection if the source column's name is bypassing 21 characters.

SAP ANALYTICS CLOUD 2023.1 

1. Login to SAC 
2. Create an import connection to a source data having a column name of 22 characters or more (E.g: excel)
3. Create an analytic model on the above connection
4. Notice that the dimension's name is cut off in the 11th character and appended with a reference

This issue is a product limitation, dimension's ID is limited to 30 characters.

This constrain of dimension ID length cannot be changed at the moment. However, an enhancement of the way the dimension ID is generated when creating model from file upload will be introduced in the quarterly release 2023.08 as follows:

1. When a file is uploaded, a column will only be truncated when it is longer than 30 characters, instead of when it is longer than 22 characters. This will be consistent with the check when the user creates a dimension manually in the modeler UI.
2. In case of column header truncation, the software will try to preserve as many characters from the original string as possible. Before this enhancement, the system-added suffix is the part that takes up space and reduce the number of readable characters from the original string. This suffix is also too long.
3. If there is no duplication of string after the truncation, a suffix will not be added.
4. Even when a suffix is added, it will be a much shorter (usually one or two characters) string instead of the current 10 characters suffix.

strange, wiered, renamed, change, edit, description, long , KBA , LOD-ANA-ML , SAC Modelling , Problem