Create and Update Data Sources - Step by Step

On this page we will be listing the steps to upload base data and check it's validity. Please note that your Excel file needs to follow the structural guidelines for Valsight data.


Step 1: Creating datasources

Open or Create a new Model and select 'Import Data' on the top right of the screen. This will open the Data upload wizard. Now select 'New Datasource' on the bottom to create a new data source.

If you want to modify an existing datasource you can click the 'Upload' button on the right and skip to step 2

 


Valsight will redirect you to a new page, on which you can select 'New Datasource' → 'XLXS'.


On the following page you can name the data source (please note the Naming Guidelines) and select an Excel file to upload. The file will only be a placeholder since we will upload a new one later on. Once this is finished you can hit 'Create Datasource'.


Now go back to your Model and select 'Import Data' once again.


Step 2: Upload data

Since we are back in the Data upload wizard, you can select 'Upload' next to the newly created data source. Now 'Browse' and select the excel file containing the desired data. Hit 'Check Content' once it's selected.


Step 3: Validate data

At this point the software will display an overview showing which columns and tables were recognised. If everything is ok, you can hit 'Validate Content'.


Now the data is getting validated. If everything worked correctly the data upload wizard will display 'No problems found'. In this case you can 'Upload' your new data source.


Possible Problems

Check if your dimension & hierarchies are configured correctly if the software is showing unknown columns.


If there is an error during the validation process, please check: Data Upload Errors, Warnings and Infos Explained
Alternatively, you can click on the error message to be redirected onto the corresponding entry on the Wiki.

Was this helpful?

Yes | Somewhat | No