When I apply Naming Standard (NSM) file I see NSM listed under Model Explorer tree but abbreviations are not applied in the erwin model - why?
This is because the Naming Standard file may be in the model, but is not applied. You can apply it as follows:
1) Go to Tools | Standard | Naming Standard, and make sure that the checkbox 'IS ACTIVE' is checked for the NSM you'd like to apply (note that you can have more than one NSM file in a model).
2 Go to Actions | Model Naming Options | Name Mapping, and check the checkbox on mapping items, e.g., Table to Entity, Attribute to Column.
Another possibility that the NSM may not work is that the inheritance between the logical and physical side not be severed. This is the most likely scenario if NSM is working for some objects and not for others. Inheritance should be intact to make sure the names in the physical side are not overridden. You can also check it using ODBC Query and running the following query:
SELECT TRAN(E.PHYSICAL_NAME), IS_INHERITED(E.PHYSICAL_NAME) FROM ENTITY E ;
SELECT TRAN(A.PHYSICAL_NAME), IS_INHERITED(A.PHYSICAL_NAME) FROM ATTRIBUTE A ;
If the results show 'F', it means the inheritance is broken and NSM will not work for objects where it is broken.
To reset the inheritance, please see the steps in the article that can be accessed from the following URL:
You can also check the link below for more information on defining Naming Standards for Physical Model.