The Data Model acts as the reporting database that Cosmos users utilize to build and run their reports against. Once additional tables and fields are brought into the Staging Area and that data is transformed, you are then ready to integrate the data into the Data Model. This article will cover how to add additional tables and fields to the Data Model.
When adding or removing tables and fields from the Data Model, you will first want to check out the relevant extension that the tables are going to be associated with. Once the extension is checked out, you can navigate to the Data Model section within Data Management.
Adding a Table to the Data Model
To add a new table to the Data Model, click the + at the top of the list of tables to the right of the Add New Table label.
You will then type the name of the table that you would like to create and click the Create button. If you would like to cancel without creating a new table you can click the "X" in the upper right corner of the window to cancel.
The empty table will be created in the table list and fields can then be added to it.
Adding a Field to a Data Model Table
To add a new field to a Data Model table, you can navigate to the table that you would like to add the field to and click the + to the right of the table name.
This will open the New Field window. To add the new field, type the name for the field in the Name field and then select the Type that the field should represent. Possible field types are:
Once the Name and Type field have been set you can click Create to create the field in the table. If you wish to cancel without creating the new field, you can click the "X" in the upper right corner of the window to cancel.
Removing Tables and Fields from the Data Model
If you need to remove tables or fields from the data model, you can go into the table and field list on the left and click the - button to the right of the tables or fields to be removed.