Glossary

Company - An organization that uses the product for data management. A company can include multiple projects and users.

Data mart - A pre-configured set of measures and dimensions, aggregated and structured for ease of analysis. A data mart is intended for use by business users and analysts.

Data model - A logical structure describing the relationships between all fact tables and dimension groups.

Dimension - An attribute or characteristic used to define slices when analyzing measures. For example, time, region, product category, etc.

Dimension group - A group of dimensions combined by meaning and stored within a single dimension table. For example, a product dimension group, a store dimension group, or a customer dimension group.

Fact - A field in a fact table containing a quantitative value subject to analysis. It is used as an argument in measure calculation formulas.

Fact table - A database table containing quantitative data representing business events or operations, such as sales, transactions, or other business metrics. It is typically linked to dimension tables via foreign keys.

Foreign key - A field in a fact table that references the primary key of a dimension table (dimension group). It is used to establish relationships between fact tables and dimension groups.

Measure - An aggregated value, calculated using a specific formula, used to measure the efficiency or state of business processes. For example, revenue, number of customers, etc.

Primary key - A field in a dimension table (dimension group) that contains unique identifiers for records in that table. It is used to establish relationships between fact tables and dimension groups.

Project - A logical container that combines the RMD, fact tables, data marts, and connections related to a specific data analytics initiative within a company.

Project version - A specific version of a project that reflects the current state of the project at a certain point in time. Versions allow for tracking changes and ensuring data consistency.

RMD (Register of measures and dimensions) - A structured catalog containing descriptions of measures, dimensions, and their interrelationships. It is used for metadata standardization and management within the system.

User - An individual who interacts with the system. A user can have various roles and access rights depending on their tasks.

User role - A set of rights and permissions defining what actions a user can perform within the system. Roles can be, for example, administrator, analyst, developer, etc.

View - A database object that provides access to data according to the configuration of the linked data mart.