Creating a Data Model

A data model is a set of tables from different data sources connected to each other using links determined in the system. A data model uses visual elements: table circles and SQL queries with links on the working area, as well as a model preview table.

To create a data model:

In the object navigator:

Execute one of the operations:

Click the Create main menu button.
Select the Create item in the context menu of the list of objects.

Select the Data Model item on the New Object panel that opens.

In the Information Panel tool select the Add Model > Create New item in the drop-down menu of the Actions button in the upper part of the side panel.

NOTE. Click the Create Data Model button in the central part of the side panel if no data source was added.

After a data model is created, build it.

To open a ready data model:

In the object navigator:

Select the Edit item in the data model's context menu.
Select the Edit in a New Tab item in the data model's context menu.
Select the Edit in a New Window item in the data model's context menu.
Double-click the data model.
Select the data model and press the ENTER key.

In the Information Panel tool:

Select the data model in the Sources drop-down list in the upper part of the side panel.
Select the Edit Model item in the drop-down menu of the Actions button.

The selected data model opens in a new browser tab.

Main menu. It contains buttons and a list of commands used for working with data model.
Title bar. It contains the edit box for entering data model name ad data model saving settings.
Side panel. It contains a list of all dimensions, facts and table calculated fields added to data model, and visualizer field settings.
Settings panel. It contains settings for displaying and export if visualizers and slides for their placement.
Working area. It contains data analysis tools.

Tables on the source panel, objects on the working area and corresponding fields in the preview table are marked with the same colors.

Operations with Data Model

To edit a ready data model:

In the object navigator execute one of the operations:

Select the Edit item in the data model's context menu.
Select the Edit in a New Tab item in the data model's context menu.
Select the Edit in a New Window item in the data model's context menu.
Select the data model and press F4.

In the Information Panel tool select the Edit Model item in the drop-down menu of the Actions button for the selected data model.

After the setup is complete, save the data model. To do this:

Click the Save button on the title bar.
Press CTRL+S.

NOTE. After clicking the Back button in the main menu to save data model changes confirm your actions in the information dialog box.

To rename a data model, use the main menu.

To delete a ready data model in the object navigator execute one of the operations:

Select the Delete item in the data model's context menu.
Select the data model and press the DELETE key.

NOTE. The data model can be deleted if the model is not used in the project, otherwise the corresponding information dialog box is displayed.

When working with a data model one can add it to update to transfer between repositories. For details about features of data model update, see the Update Installation Features section.