This error appears when a newly uploaded Excel document does not contain worksheets that are currently being referenced in our model. To resolve this you can either add the required worksheets to the new Excel document or remove the reference to the old worksheets inside of the model.
To identify where a table is used, navigate to the Valsight settings > Projects > choose the Project > Show Data Sources > Usage report (> Details).
Example:
Our current document 'Base data.xlsx' contains the following worksheets:
All of these worksheets are being referenced in multiple places inside our model. For example in the base data submodel.
Our new data source only contains the following Worksheets:
If we try to upload this document the data upload wizard will show the error ‘table is still in use’. To fix this we can either copy the worksheets from the old into the new Excel document or remove all references to the old worksheets inside our model.
Make sure to also add the contents of a worksheet when you are adding missing worksheets to your new Excel document. Otherwise, the error will persist.
Duplicate table
There is more than one sheet (Excel) or table (database) with the same name. To resolve this rename the sheets or tables in question and reupload the file or reimport the database again.
Empty table
A sheet (Excel) or table (database) has column headers but is otherwise empty. Delete it from the document or add rows to resolve this error.
Column is still in use
Similar to “Table is still in use”, this error appears when a column that is referenced inside the model isn't part of the new Excel document. To resolve this you can either add the required columns to the new Excel document or remove the reference to the old columns inside of the model.
Example:
Our new file does not contain the column 'Volume' which is referenced in our submodel.
If we try to upload it the error 'column still in use' will appear. To resolve it, we can either add 'Volume' back to our file or remove the reference from the submodel.
Duplicate Column
You will receive this error if your Excel document contains a column two or more times. Remove the redundant columns to fix the error.
Example:
Our new data source contains the column "Billed Days" twice.
When we try to upload said data source, we'll receive the error "Duplicate column". The data upload wizard also shows which sheet and column are affected. Just delete the highlighted, redundant column and you are good to go.
Wrong parent or child
This error appears when the hierarchy of a level (Paris) and its parent (Germany) is not the same as specified in the dimension management. In this example, the parent of Paris is France and not Germany.
Try to sort out if you have to change your excel file or database to match with the dimension management or vice versa.
Conflicting linked attributes
Similar to Wrong parent or child, this error appears if the linked attributes that are used in the excel file or database are not the same as in the dimension management.
In the example below, "Auto2" has a linked Color "Blau" in the excel file, but "Rot is linked in the dimension management.
vs
Invalid value
This error appears when the dimensions or level values in Valsight don't match with the ones in the uploaded Excel document. Edit the dimension and hierarchy management to match your base data to fix the issue.
Example:
The Excel document containing our base data is referencing the level value 'Service 3' in lines 7 and 13.
When we try to upload our base data we get the error 'Invalid Value'. The data upload wizard also shows us which values are affected. Here we can see that lines 7 and 13 in the column 'Product' are affected.
If we check inside the dimension management we'll see that the level value 'Service 3' is missing. Once we add the value the upload will work as intended.
'Invalid values' also appear, when whole dimensions or hierarchies are missing. In addition to that, it appears when hierarchies aren't set up correctly (e.g. 'ProductGroup' containing the values for Products and vice versa).
Empty Cell
This error appears if the uploaded Excel documents contain cells without a value in them. Fill in all missing values in the document to fix the error.
Example:
Our Excel document is missing two values in the columns "TotalRevenue" and "BilledDays".
Once we upload the file we receive the error "Empty Cell" along with the position it is in. Fill in the missing values to resolve the error.
Duplicate Row
This warning appears if your Excel document contains a row multiple times. Discard the redundant rows to remove it.
Example:
Our Excel file contains the last row twice.
When we upload the file we'll get the warning "Duplicate Rows" as well as the information on which rows are the duplicated ones.
Even though you can still upload an Excel file with duplicate rows, we advise against it since it might lead to unintended consequences while building your model.
Added Rows
This message appears if new rows were added to your data source. It also shows you, which rows were added specifically.
Example:
We added a new row (row 5) to our Excel file.
Once we upload our new file the data upload wizard will show us which rows were added.
Deleted Rows
This message appears if rows were deleted from your data source. It also shows you, which rows were deleted specifically.
Example:
We now deleted the previously added row 5 from our Excel file.
Once we upload the file the data upload wizard will show us which rows were deleted.
Changed Values
This message appears when values in your newly uploaded Excel file change compared to the existing data source. It also shows you which values have changed specifically.
Example:
We changed the values in rows 27, 28, and 29 of our Excel file.
Once we upload the file, the data upload wizard will show us which rows were modified.
JavaScript errors detected
Please note, these errors can depend on your browser setup.
If this problem persists, please contact our support.
