Navigate to the Mart.

Download Model as Excel Template

Click on Model from the top menu.

To edit all of the existing Model, click on Download Mart Model.

To edit one or two tables, click the down arrow on the right-hand side of the Download Data Model and choose Select Particular Tables from the menu and then choose the tables.

To add a new table, click the down arrow on the right-hand side of the Download Data Model and choose Empty Template from the menu.

image-20210218125712345

For more information on how to edit the Excel file, go to the How to fill in this template tab on the spreadsheet.

Click here for a list of Field Data Types. (link is missing)

Once you have finished, upload the file back into the mart.

Upload Excel Template

Click on Model from the top menu and then Upload.

image-20210218010812345

Either drag the file from Explorer to the blue box marked Drag or Browse or click on it and browse to the file.

image-20210218010912345

A batch will start loading.

image-20210218011012345

After which, a summary screen will appear showing any errors etc.

image-20210218011112345

Any errors etc. can be seen by clicking on the relevant area on the left.

If you are happy with the results, click Commit otherwise click Cancel.

image-20210218011212345

If you commit, the screen will change back to the batch and the batch will complete.

image-20210218011312345