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.
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 ifdegenerate_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 thedegenerate_dimensions
property (see below). -
degenerate_dimensions
: Array, required ifrelationships
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 therelationships
property (see above).
Required properties:name
: String, required. The unique name of the degenerate dimension.level
: String, required. The specific level within the dimension.
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
.
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