Skip to main content

Bulk Create Metrics

You can create metrics in bulk from a fact dataset in a model.

Procedure​

  1. In Design Center, open a model and switch to the Canvas tab.

  2. Select the columns in the dataset you want to base your metrics on by clicking them. The selected columns are highlighted in black.

  3. Click the Create Metric icon in the menu that appears above the dataset.

    The bulk create menu above the factinternetsales dataset.

    The Bulk Create Metrics panel opens. The panel is prepopulated with values based on the dataset columns you selected.

  4. Edit the following fields as needed:

    • Label: The name of the metric, as it appears in AtScale and BI tools.

    • Unique Name: The unique name of the metric. This must be unique across all repositories and subrepositories.

    • Description: A description of the metric.

      Note

      If the metric doesn't have a manually entered description, but the target column the metric is based on has a description in the data warehouse, the description of the target column automatically appears in the Description field. This information is not added to the metric's SML, but is included when you deploy the model. From there, it becomes visible in BI tools (when supported), and is made available to AI tools.

      You can edit the prepopulated description as needed. Any changes you make will override the description from the data warehouse.

      If the description in the data warehouse changes, changes will be reflected in the metric when you refresh the dataset in Design Center.

    • Aggregation Type: The aggregate calculation to apply to the data. The value you select depends on the type of metric you want to create:

      • Additive metrics: Average, Distinct Count Estimate, Max, Min, Non-Distinct Count, Population Standard Deviation, Population Variance, Sample Standard Deviation, Sample Variance, Sum
      • Non-additive metrics: Distinct Count, Distinct Sum, Percentile, Count If

    • Override Default Handling: Enables/disables unrelated dimension handling for the metric.

    • Unrelated Dimensions Handling: Determines the unrelated dimension handling behavior.

    • Formatting: Defines the format for query results.

    • BI Folder: Defines the folder in which the metric appears in BI tools.

    • Visible in BI Tools: Determines whether the metric appears in BI tools.

  5. Click Create.

The new metrics are added. You can view them in the Metrics section of the Model properties panel.