-
Notifications
You must be signed in to change notification settings - Fork 2
2. Transformation
This step allows to start the transformation of the CSV input data into a Cube.
The result is saved in the Cube Creator database, there is no publication yet to the public database.
After the mapping a first transformation is necessary. The "Transform" button does trigger a new transformation. The symbol indicates the progress of the transformation . A click on the double arrows shows the date of the last transformations and provides a link to see the logs of each job.
| Symbol | Transformation |
|---|---|
| grey | Pending |
| blue (blinking) | Running |
| red | Failed |
| green | Successful |
The transformation may take a few minutes depending on the size of the input files.
💡 Tip
With large CSV files, to avoid waiting a long while when preparing the Cube (up to 20 minutes or more for instance), you can import a sample CSV file with the same structure (columns and header titles) to perform the first tests for the transformation and the Cube Designer, and then replace the uploaded sample CSV later with the full version and re-run a full transformation.
It is possible to update a cube with new values, normally after a new data update period has passed. Any CSV can be replaced by a new one, if the following conditions are met:
- The separator character remains the same.
- The same column names are used (case sensitive).
- All columns from the former CSV are still present.
In other words, the following changes are allowed
- Additional columns.
- Different order of columns.
- Different row content.
Once a transformation is started you see the current Job in the list. By clicking on it you see more detailed information and, in case of an error, a message.
Errors which can happen in this step are shown on the transformation run.
At least one input value is not conform to the datatype selected for an input dimension.
For instance a dimension was defined with an "integer" datatype, but on one line a string is found in that column.
Above you get a hint on the error line.