Skip to content

Overview

Metric Definition covers the full lifecycle for metrics and dimensions, including definition, development, publishing, change management, and retirement. This section is organized into three main areas: datasets, dimensions, and metrics.

Datasets

The Datasets area includes the following capabilities:

  1. Create a dataset

  2. You can create a dataset by selecting source tables from a data source. Aloudata CAN supports both source-table datasets and custom SQL datasets.

  3. When creating a dataset, you can rename fields, update field descriptions, change field types, and add calculated fields.

  4. Create calculated fields

  5. You can create calculated fields based on an existing dataset. Calculated fields are generated by applying calculations or transformations to existing data.

  6. The system provides a rich set of calculation functions and operators, so you can define complex logic as needed.

  7. Configure dataset relationships

  8. You can create relationships between datasets to expand the dimensions available for analysis or to support shared-dimension analysis across multiple fact datasets.

  9. Relationship configuration supports one-to-one and one-to-many relationships, so you can model data according to your business needs.

  10. Manage datasets

  11. You can view, edit, and delete datasets, review lineage, and manage permissions.

Dimensions

The Dimensions area includes the following capabilities:

  1. Create dimensions

  2. You can define new dimensions based on your business requirements.

  3. Manage dimension values

  4. You can add, update, and delete dimension values.

  5. Manage dimensions

  6. You can view and edit existing dimensions.

  7. Dimensions support version management, so you can track historical versions and change records.

Metrics

The Metrics area includes the following capabilities:

  1. Create metrics

  2. Create a basic metric

    • You can select fields from a dataset and define a basic metric. A basic metric is the fundamental unit of measurement and is calculated directly from source data.

  3. Create a derived metric

    • You can create a derived metric from a basic metric by adding time constraints, business filters, and derivation methods.

  4. Create a composite metric

    • You can define a composite metric by combining multiple basic and derived metrics.

  5. Manage metrics

  6. You can view, edit, and delete metrics, as well as configure metric monitoring, view metric lineage, and manage access control.

  7. Metrics support version management, so you can track historical versions and change records.