New Features and Improvements
AtScale contains the following new features and improvements.
C2025.10.0
SML 1.5 now available
SML version 1.5 is now available. After upgrading to C2025.10.0, you may receive warning messages in the Model Validator about upgrading your SML files. Click Fix Error in the messages to update your files automatically.
For information on the latest version of SML, refer to the AtScale SML Object Documentation on GitHub.
Support for Microsoft Power BI field parameters
AtScale now supports Power BI field parameters.
Report users often need to analyze similar, but slightly different, metrics and dimensions. Historically, report designers met this need by duplicating tabs that only differ by one or two metrics or dimensions. By contrast, Power BI's field parameters offer a more dynamic reporting experience by reducing dashboard complexity and maintenance.
For instructions on enabling field parameters, see Using Power BI with Field Parameters.
ATSCALE-14665
Changes to XMLA token format
AtScale's XMLA tokens have a new, shorter format. This helps ensure that AtScale's model connection strings adhere to length requirements enforced by connected BI tools.
As part of this change, the Power BI tab on the Settings page contains a new Service Token field, where you can access your service token. For more information, see Using Power BI Service with Token-Based Authentication.
When you upgrade to C2025.10.0, all current XMLA tokens will be deleted. This includes both personal and service tokens. You must regenerate all XMLA tokens after upgrading. For instructions, see Upgrade Requirements.
ATSCALE-28871
Secondary attributes now configurable as user-defined member properties
You can now expose secondary attributes as user-defined member properties in Microsoft Excel. Member properties enable you to retrieve fine-grained property attributes (such as PII fields), without causing expensive and complex CROSSJOIN queries.
Currently, AtScale only supports use of user-defined member properties with Excel and MDX.
For information on working with user-defined member properties, see Using MDX User-Defined Member Properties and Edit a Secondary Dimensional Attribute.
ATSCALE-28477
Support for percentile metrics
AtScale now supports percentile metrics. Percentile metrics enable BI tool users to view data values at percentile ranks, insulate their analyses from outliers, and find the percentile rank for specific records.
Currently, percentile metrics can only be created with SML.
For more information on working with percentile metrics, see Non-Additive Metrics and the AtScale SML Object Documentation on GitHub.
ATSCALE-21809
View aggregate cost savings on the Queries page
You can now calculate your cost savings from using aggregates to process inbound queries. This enables you to quickly determine the effectiveness of your aggregates.
This functionality is not currently supported for PostgreSQL or InterSystems IRIS data warehouses.
For more information, see Using the Queries Page.
ATSCALE-27666
The Identity Broker's everyone group can no longer be deleted
The everyone group in the Identity Broker can no longer be deleted or renamed.
ATSCALE-41122
New Identity Broker client for the AtScale Connector Google Sheets add-on
The Identity Broker contains a new default client called gsheet-addon. This client enables the AtScale Connector Google Sheets add-on to authenticate with AtScale, without requiring additional configuration.
If you manually created a client for the AtScale Connector in a previous release, it will automatically be migrated to the new client when you upgrade to C2025.10.0. No further action is required.
For more information, see Using AtScale with Google Sheets.
ATSCALE-28699
New sorting options for the Aggregates page
You can now sort the Aggregates page by the Last Build Started and Last Build Duration columns. For more information on the Aggregates page, see Monitoring Aggregate Usage.
ATSCALE-25048
New settings to control strict aggregate widening
You can use the new aggregates.create.strict.widening.enabled setting to enable/disable strict aggregate widening in AtScale. When enabled, aggregates that include metrics can only be created using the default aggregation type for each metric. While aggregates can still be widened by adding new metrics from the fact table, they cannot include the same metric with a non-default aggregation type.
This setting is available at both the global and model levels, and is disabled by default. For more information, see Aggregate Settings (global level) and Aggregate Settings (model level).
ATSCALE-41220
Higher order aggregates now disabled by default
The aggregates.create.higherOrder.enabled global and model settings, which control higher order aggregates in AtScale, are now disabled by default. For more information, see Aggregate Settings (global level) and Aggregate Settings (model level).
ATSCALE-42014
Constraint translation now supports queries on embedded dimensions
AtScale's constraint translation functionality now applies to queries on embedded dimensions. For more information on constraint translation, see Using Constraint Translation for Fact Table Query Acceleration.
Constraint translation is a public preview feature.
ATSCALE-27942
DAX aggregation functions can now be used over dimensional attributes
DAX aggregation functions can now be used over dimensional attributes. For more information on working with DAX, see Using DAX Tabular.
As part of this change, the query.language.dax.allowDimensionalAggregates setting was removed.
ATSCALE-20960
AtScale now applies hierarchy filters to level aliases in outbound queries
When a filter is applied to any level of a hierarchy and a level alias from the same hierarchy is used in a query, AtScale now applies the hierarchy filter constraint to the outbound level alias query. This minimizes scanning on large dimension tables.
For more information on using level aliases in AtScale, see About Dimension Attributes.
ATSCALE-40880
Changes to AtScale images
The pgpool, postgres-exporter, and postgresql-repmgr images were replaced with the postgresql image.
For more information, see List of AtScale Images.