Skip to main content

Semantic Models

A Semantic Model organises data from one or more entities into a structure that is understandable and reusable by User Views and Workflows.

The model defines:

  • entities and fields;
  • dimensions and measures;
  • formulas;
  • relationships;
  • hierarchies;
  • calendars;
  • access and update modes.

This feature must be enabled by the platform administrator.

Semantic Model Editor for Order Analysis with customers and orders entities

Model modes​

Import​

The Import mode acquires data via a model refresh. It is indicated when you want to control when a new generation of data becomes available.

It supports full or incremental updates and schedules.

Live​

The Live mode queries authorised sources when the model is used. It is indicated when current data needs to be read and the source is suitable for this type of usage.

A Live model can be converted to Import. After saving, it cannot revert to Live mode.

Create a model​

  1. Open Designer Workbench.
  2. Select Create and then Semantic Model.
  3. Enter the name and description.
  4. Choose Import or Live.
  5. Select at least one project.
  6. Select at least one role.
  7. Select Create and open Editor: the editor opens in an internal tab.

Lifecycle​

The model is created as a draft. The recommended path is:

  1. configure connections and entities;
  2. model fields, measures and relationships;
  3. run the previews;
  4. save;
  5. publish a version;
  6. for an Import model, run the first refresh;
  7. link it to authorised User Views.

A change to the draft does not automatically change the version used by the views.

Access and scope​

A Semantic Model requires at least one project and one role. Specific shares distinguish view, edit and properties.

Actual access depends simultaneously on:

  • projects;
  • roles;
  • shares;
  • permissions on the connections used.

Documentation path​

Expected outcome​

A ready-to-use model is published, passes the expected previews and makes available to User Views only fields, measures and hierarchies intentionally exposed.