Use the BLANK keyword in Member Mappings

In certain cases, the file you are importing may contain blanks. For example, the source system may not have a cost center value in the file that it produces.

In the sample data import file, you need to be able to specify where the data should map to when blanks are met. 

For example, should it be mapped to a member, such as No Cost Center or should it be ignored? You can use the <BLANK> keyword to achieve this.

To map blank members in the import file:

1. Create a new Member Map for the dimension that may contain blank members.
2. Add the member mappings.
3. Use the <BLANK> keyword in the Source Value column to map blank members. 
4. Select the member to map to in the Mapped Value column.
   In this table, any rows with blank Cost Centers in the import file will be mapped to the [No CostCenter] member in.

5. Save the changes.
6. Refer to this Member Map in the appropriate Dimension Field Settings when configuring the corresponding Data Import Definition.

To skip a row with a blank member:

1. Create a new Member Map for the dimension that may contain blank members.
2. Add the member mappings.
3. Use the <BLANK> keyword in the Source Value column to skip blank members. 
4. Use the SKIP keyword in the Mapped Value column.
   Blank cost centers will be skipped.
5. Save the changes.
6. Refer to this Member Map in the appropriate Dimension Field Settings when configuring the corresponding Data Import Definition.