Introduction
While importing data to partitions is often straightforward, you might encounter unforeseen errors. This article explains different data import errors and their possible solutions:
Missing columns in imported table
This error occurs when the imported table does not have one or more of the columns in the data partitions. When importing data, you will see the following error message:
"One or more columns are missing."
The data partition's columns are determined by the model's dimensions, so ensure the imported table has a column for each model dimension. You can go to the Mapping tab to identify the columns you need to include in the imported table.
Member missing from member list
This error occurs when the missing member is in the dimension but not on the member list used in the model. When importing data, you will see the following error message:
"X - Member Label missing from the Y member list.
Row A, Column B"
For example, Argentina is on the All_Entity member list:
However, it's not on the Entity member list.
If the member was removed from the member list but data for the member still exists in the model, you will see the yellow warning icon in the partition.
Tip: Narrow down the list to the records with data errors by selecting Show data errors.
You can either resolve the errors and keep the data or delete the data with errors.
Resolve errors
If you want to keep the data, you can add this member back to the member list.
1. Go to the target model and verify the member lists being used.
2. Go to the target member list and, from the ribbon, select Add Existing.
3. From the Member List dropdown, select the member list that currently holds the dimension member you want to add.
4. Select the checkbox(es) of the member(s) you want to add to the target member list.
5. Select Add and deploy the application.
Delete data with errors
Attention: Deleting data cannot be undone. Check the Total and Displayed record counts at the bottom of the page to know the impact of the deletion.
1. Select Show data errors and disable all filters.
2. Select Delete.
3. Select Start.
The records should be deleted from the partition.
Member not in dimension
This error occurs when the member does not exist in the dimension or Excel has automatically reformatted data. When importing data, you will see the following error message:
"X - Member Label not in Y dimension
Row A, Column B"
Member does not exist in dimension
This error occurs when the missing member does not exist in the dimension at all. Below you can see that Argentina, for example, is not in the All_Entity member list.
If the member was deleted from the dimension, but data for the member still exists in the model, you will see the red error icon in the partition.
Tip: Narrow down the list to the records with data errors by selecting Show data errors.
Three possible resolutions to this problem are:
- Fixing spelling discrepancies between the records in the imported tables and the Kepion dimension members.
- Adding a new member to the dimension.
- Deleting the data with errors.
Fix spelling discrepancies
Review the table in Excel and the relevant dimension members. If there is a spelling discrepancy, decide on one spelling and edit the records in Excel and/or the member label values of the dimension members in Kepion.
To change a member label:
1. Locate the dimension member and double-click its value in the Member Label column.
2. Enter a value with the correct spelling.
3. Deploy the application and import the data again.
Add new member
1. Go to the target member list and select Add New.
2. Double-click the member label of the added dimension member and enter a value.
Note: Ensure that the new value matches the member label of the deleted member.
3. Deploy the application and import the data again.
Delete data with errors
Attention: Deleting data cannot be undone. Check the Total and Displayed record counts at the bottom of the page to know the impact of the deletion.
1. Select Show data errors and disable all filters.
2. Select Delete.
3. Select Start.
The records should be deleted from the partition.
Excel reformatting
This error will occur when the dimension member exists in the dimension but Excel has changed the formatting of data.
The Time dimension's data, in particular, is prone to Excel's formatting changes.
Before you import data, double-check the table to ensure the members (especially, Time's members) are written correctly.
You can also verify whether Excel has automatically changed your data by checking the Number section in the ribbon's Home tab. The drop-down should be set to General.
Tip: We recommend opening exported .csv files in a plain text editor, so Excel does not impose any formatting on your data.