Show TOC

Function documentationResolve Unrecognized (Invalid) Dimension IDs in Spend Data Locate this document in the navigation structure

 

By default, an import action will stop automatically if an unrecognized ("invalid") dimension ID is found in the spend data. An invalid ID is one that is not in the dimension tables or in the set of synonym maps specified for the import. You can resolve such a reference by doing any of the following:

  • Map the ID to a valid dimension ID.

  • Treat the ID as unclassified (anonymous).

  • Treat the ID as unclassified, but make the new ID show up in a report drill-down under the Unclassified row.

  • Discard the spend for records with this new ID.

Each of these decisions can apply to the current import only or to all future imports. If you apply the decision to all future imports, it is added to the appropriate synonym maps. After this action, the import can be resumed with the new mapping decisions in place.