New Features and Improvements
AtScale contains the following new features and improvements.
Manage Git repositories within Design Center
AtScale admins can now manage the Git repositories linked to AtScale from the Workspace panel (formerly called the Repo Browser) in Design Center, rather than from the Control Center. For more information, see Managing Git Repositories in AtScale.
As part of this change, the Repo Browser has been renamed to the Workspace panel.
ATSCALE-23239
Manage global settings within Design Center
The Settings page is now available in Design Center, rather than the Control Center. Here, AtScale admins can link to global settings repositories and view all current overrides. For more information, see Settings Page and Configuring Global Settings.
ATSCALE-23239
Configure Databricks and Snowflake data warehouses from Design Center
You can now configure Databricks and Snowflake data warehouses from the Datasources panel within Design Center, rather than the Control Center. For more information, see Adding Databricks Data Warehouses and Adding Snowflake Data Warehouses.
AtScale will transition other supported data warehouses to the new configuration workflow in future releases.
ATSCALE-22213
New MDX function
AtScale now supports the XIRR MDX function, which calculates the rate of return (within .000001%) of investments that have irregular payment schedules. For more information, see XIRR.
XIRR is a public preview feature.
ATSCALE-24235
New Is Aggregatable property for levels, secondary attributes, and calculation groups
Levels, secondary attributes, and calculation groups support a new property called Is Aggregatable. This property specifies whether the object's member values can be aggregated.
When Is Aggregatable is enabled on an object, AtScale creates an All member whose value is the aggregation of all the object's member values. The All member sits at the top of the object's hierarchy, though it is not a part of the object itself. It often serves as the object's default member.
To support this functionality, the Level properties and Secondary attribute properties panels now contain an Is Aggregatable option. Additionally, the secondary_attributes, level_attributes, aliases, and metrics properties in SML dimension files now support is_aggregatable properties.
For more information on configuring the Is Aggregatable property in Design Center, see Edit a Level and Edit a Secondary Dimensional Attribute. For more information on configuring the is_aggregatable property in SML, see the AtScale SML Object Documentation on GitHub.
NULLEXCEPT MDX function now supports dereferencing aliases in queries
The NULLEXCEPT MDX function now accepts an optional argument that enables it to search queries for dereferenced level alias hierarchies, in addition to the explicit list of attributes in the specified hierarchy set. For more information, see NULLEXCEPT.
ATSCALE-24466
Aggregate MDX function now supports semi-additive metrics
The Aggregate MDX function can now be applied to semi-additive metrics in calculations like Year-to-Date, Quarter-to-Date, etc. Previously, this would cause errors on deploy. For more information, see Aggregate.
ATSCALE-23737
Metrics now apply their unrelated dimension handling to levels below the join level
Metrics that have their unrelated dimension handling set to Include empty cells in query results now apply that behavior to levels below the join level. Previously, these levels would display repeating values, regardless of the configured unrelated dimension handling behavior. For more information, see About Queries on Dimensions that are Unrelated to One or More Queried Metrics.
ATSCALE-24196
Configure SSO connections to Microsoft Excel via the AtScale add-in
You can now configure SSO connections to Excel using AtScale's branded add-in. This enables users to authenticate with AtScale from Excel using their SSO credentials.
For instructions on installing the add-in, see Connecting to Excel via the AtScale Add-In.
New Identity Broker realm role
The Identity Broker contains a new complex realm role called application_admin. Users with this role can do everything users with the admin role can do, except access the Identity Broker and manage users. For more information, see Identity Broker Default Roles.
ATSCALE-24534
SML support for custom parallel periods
You can now define custom parallel periods on levels in SML dimension files. This enables you to compare periods in different levels of a time hierarchy that aren't in the same relative child position; for example, the last week of a 53-week year to that of a 52-week year.
To support this functionality, the levels property in SML dimension files now support the parallel_periods property. For more information, see the AtScale SML Object Documentation on GitHub.
ATSCALE-24274
NonEmpty, Tail, and ExtractMember MDX functions now support calculation group generic level types
The NonEmpty, Tail, and ExtractMember MDX functions now support the calculation group generic level types (i.e., TimeDays, TimeQuarters, etc.). This enables you to use these functions in calculations that reference calculation groups.
For more information on referencing calculation groups in calculations, see Referencing Calculation Groups in Calculations.
ATSCALE-23878