What Does “Import File Contains Key Values That Don’t Currently Exist
In Stratum” Message Mean?
If your import file
includes dimension key values that don’t currently exist in Stratum, you
will get the following message. It tells you “Your import file contains
key value(s) that don’t currently exist in Stratum”. Key values are unique
identifiers of the members belonging to your Stratum dimensions.
·If
you did not intend to add new key values for the dimension,
then you need to cancel this import, remove rows containing the values
from your import file, and try again. To cancel the import, click
OK in this message and then click Exit 
in the mapping window, which returns you to the
Master Data Import list window. Nothing will be saved or processed
for the import you were setting up
If you did
intend to add the new key value, then click OK and proceed with your
import. See also Using Master
Data Import To Add New Dimension Key Values. That topic shows
an example of an import where new key values were included to aid
in business planning activities.
Here’s an example
where a user didn’t intend to include a new key value. The dimension Product
Group has four members 10, 11, 12, and 13. The user set up some User Controlled
Attributes for the dimension and wants to import some data for them using
the following import file. The last row was intended to be for existing
key value 13, but there is a typo which makes the value there 133. Master
Data Import will treat that value as a new key value. The user needs to
correct the value to 13 and then try the import again.
Here’s the key value
message that showed when the import file with the typo displayed in the
mapping window and the user clicked Validate. The mapping window also
highlighted the applicable value in yellow.
Here’s the mapping window
after the typo was fixed in the import file and the user initiated a new
import using that file. The import is about to be submitted for processing.
