Skip to main content

New Features and Improvements

AtScale contains the following new features and improvements.

Environment variables in SML​

You can now define environment variables to use as values within your SML object files. This functionality makes it easier to deploy models across different data warehouses and environments, such as development, staging, and production.

note

Currently, environment variables can only be used in connection files.

For more information on working with environment variables in SML, see Working with Environment Variables.

ATSCALE-22161

New properties for semi-additive metrics​

You can now configure semi-additive metrics to execute their non-additive behavior when evaluated against several specific hierarchies, rather than being triggered by a single attribute. This functionality increases the generalizability of LVNE/FVNE metrics, and saves you from having to author calculated metrics with CASE statements wrapping individually created LVNE/FVNE metrics.

To support this functionality, the semi_additive property in SML metric files now supports the following properties:

  • relationships: Array, required if degenerate_dimensions is undefined; otherwise, optional. A list of the relationships connecting to the dimensional attributes whose values should not be summarized. You can define as many as needed in the list.
    Relationships to nested dimensions must be defined as indented lists, whose subitems construct the path to the nested dimension.
    Note that this list should not include relationships to degenerate dimensions; those must be defined via the degenerate_dimensions property (see below).

  • degenerate_dimensions: Array, required if relationships is undefined; otherwise, optional. A list of degenerate dimensions whose values should not be summarized. Note that this list must only include degenerate dimensions; non-degenerate dimensions must be defined via the relationships property (see above).
    Required properties:

    • name: String, required. The unique name of the degenerate dimension.
    • level: String, required. The specific level within the dimension.
note

After upgrading to C2024.9.0, you need to update any existing semi-additive metrics in your models to use these new properties. For more information, see Upgrade Requirements.

For more information on the new semi_additive properties, refer to the SML Object Documentation on GitHub.

ATSCALE-22054

atscale.yml renamed to catalog.yml​

The atscale.yml file has been renamed to catalog.yml. Additionally, the as_version property within the catalog file is now named version.

note

After upgrading to C2024.9.0, AtScale recommends updating the atscale.yml files in any existing models you have to reflect these changes. For more information, see Upgrade Requirements.

ATSCALE-22432