When importing a Tree, user gets an error reading “Codes _____ are missing from the dimension Entity” The user gets this when exporting a tree already created in the portal. When the user makes any or even no changes to the csv file, then save and re-import, this is when the error occurs.
This can happen for a couple reasons but the general cause is that the code(s) on your tree import file do not exist in its respective dimension. This can be cause by
- The codes do not exist on the respective dimension
- The formatting of your import file has removed leading or trailing zeros; converting what intended to be 0100 to 100 (as an example)
- Make sure that all codes on your tree import file exist in its respective dimension. This includes all levels of the tree, including rollup levels, which may be non-operational codes.
- Open the CSV file used in the integration, change the format to General and try the import process again.