Maximum length for a fields in MDM

[Former Member]

Hi Folks,

I am working on BI side and we are working on a design where BI will get data from MDM

Today in legacy system all the code fields and descriptions are freely defined. Some of the code and description fields are 100 characters.

In BI we have a limitation that the field length of code and text fields cannot be more than 60 characters. For better reporting performance SAP has this limitation in BI.

Question : Does MDM has any limitation ? We are planning to use MDM 5.5 .

Regards

Poonam

[Former Member]

Hi Poonam,

in MDM the maximum text length is 333.

The following things impact on the performance are key word=normal etc.

Reg,

BIs

[Former Member]

Hi,

As Suggested above MDM Text field is of 333 characters max.

In your case since the BI system(max Text width=60) is getting the data from MDM system you can limit the field width to 60in MDM while defining the field mention the width=60.

Apart from it various parameters such as Keyword search,Sort Index,Cache Qualifiers affect the performance.

Regards

Nisha

[Former Member]

Hi Poonam,

Upper limit for text fields is 333.

I guess these points about performance will be useful to you.

Field Keyword search definition (fields defined as Keyword = Normal)

If you define Keyword = Normal for your fields, you will have a big impact on the load repository process and on the virtual memory (VM) size used at runtime. It might cause an overhead when adding, deleting or updating records.

Set Keyword = None whenever there is no need for a keyword definition, and where the number of unique values in this field is not too high.

􁃀 Field Sort Index definition (fields defined as Sort Index = Yes)

Setting Sort Index = Yes for a field has a high impact on the repository loading time and main memory consumption. Set Sort Index = No when the sort index for a field is not

needed.

Please note that for all lookup tables (including qualified), the display field must have Sort Index set to Yes; also for searching on a qualifier, you need to set Sort Index to Yes.

􁃀 Key Mapping definition for tables (Tables defined as KeyMapping = Yes)

This may have serious impact on data Import. Set to KeyMapping = No when key mapping is unused.

Cautious usage of the MDM change tracking table

The Change Tracking table tells the Master Data Server (MDS) which data modifications to track. Each entry set to Yes will cause the MDS to write one or more rows to the History table in the DBMS depending on the operation. Set the entries to No when tracking is not needed.

For example, setting a field such as the Products->Name field to Yes will cause one row to be written when a record is added or deleted, or when that particular field is modified. Setting all n fields in a table to Yes will cause n rows to be written with a record when it is added or deleted.

You can also refer to this link for performance related information

[https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/oss_notes/sdn_oss_mdm/~form/handler%7b5f4150503d3030323030363832353030303030303031393732265f4556454e543d444953504c4159265f4e4e554d3d31303132373435%7d]

Regards,

Ravi Verma

[Former Member]

Hi Poonam,

In MDM the text field limitation is 333 characters.

Best Regards,

Silpa Chillakuru

[Former Member]

MDM have three type of text fields:

1)Normal text field length is 333 characters,

2)Text(normalithed) field whith length is 333 characters

"A Text Normalized field stores the actual text value, but

uses the normalized value for sorting and searching. The normalized

value is an upper-case version of the original with non-alphanumeric

characters removed (includes a-z, A-Z, and 0-9 from original value)"

3)Text(large) field where is field length up to 333 characters

When we use first or second type of fields, we can change fields length in MDM Console(as default field width= 50)