Skip to main content

Modelling and queries

The Semantic Model Editor consists of:

  • Entity panel;
  • central diagram;
  • Properties panel;
  • action bar;
  • Refresh and diagnostics area for Imported models.

Changes can be undone or restored before saving.

Fields and dimensions​

Each field has a technical name, label, and data type. It can be visible or hidden from User Views.

A Calculated dimension derives its value from other fields via a formula. Use user-oriented labels and maintain stable meaning over time.

Measures​

A Measure represents a reusable calculation, such as total, average, or count.

To create one:

  1. select the entity;
  2. choose Measure;
  3. enter name and label;
  4. select the result type;
  5. compose the formula;
  6. apply the change to the draft.

The formula editor suggests available fields and measures and verifies references before saving.

Formulas​

Formulas display readable labels, while Sybot retains stable internal references.

You can insert:

  • fields;
  • measures;
  • arithmetic and logical operators;
  • functions available in the editor bar.

If a field or measure is deleted, check all formulas that use it.

Relationships​

A relationship connects two entities via one or more fields.

Configure:

  • name;
  • source and target entities;
  • linking predicates;
  • cardinality 1:1, 1:N, N:1, or N:N;
  • filter direction.

In the diagram, a relationship with a filter in one direction shows a single arrow. If the direction is Both directions, the link shows an arrow at each end.

The Detect cardinality command suggests a cardinality based on available data. The suggestion must be checked and confirmed by the user.

An N:N relationship requires particular attention: verify that results are not duplicated and that the filter direction matches the expected usage.

Hierarchies​

A hierarchy orders multiple fields of the same entity, for example year, quarter, month.

  1. Select Add… → Hierarchy.
  2. Enter name and label.
  3. Choose the entity.
  4. add and order levels.
  5. confirm.

User Views can use the hierarchy for drill-down in charts and filters.

Calendars​

The Add… → Calendar command creates a temporal entity with the interval and granularity configured in the editor.

Use a calendar to align date-based analysis and create consistent temporal hierarchies. Link it to affected entities via verified relationships.

Diagram​

In the diagram you can:

  • move and resize entities;
  • scroll fields;
  • select entities, fields, and relationships;
  • distinguish cardinalities via legend;
  • customise an entity header.

The layout is saved in the model version and does not modify the data structure.

Semantic query preview​

Select Actions… → Preview.

  1. select at least one field or measure;
  2. run the query;
  3. check columns, types, and values;
  4. repeat the check for the main combinations used by User Views.

Preview uses the definition configured in the editor even before publication.

Recommended checks​

  • clear and unambiguous labels;
  • correct data types;
  • technical fields hidden when not needed;
  • formulas without missing references;
  • consistent cardinalities;
  • ordered hierarchies;
  • queries without unexpected duplications.