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 dimensions on by clicking them. The selected columns are highlighted in black.

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

    image

    The Bulk Create Measures 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.

    • 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, Percentile
    • 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 to the dataset in the model. You can view them in the Measures section of the dataset.