Skip to main content

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.

Attention

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.

Note

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.

Note

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.

Note

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.

Note

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.

Note

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.

Note

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 following changes have been made to the AtScale images:

  • AtScale now includes the mcp-server image.
  • The pgpool, postgres-exporter, and postgresql-repmgr images were replaced with the postgresql image.

For more information, see List of AtScale Images.