Skip to main content

New Features and Improvements

AtScale contains the following new features and improvements.

C2026.2.0​

Partition-based incremental aggregates​

Note

Partition-based incremental aggregates are a Public Preview feature.

AtScale now supports partition-based incremental aggregates, in addition to its original, view-based incremental aggregate functionality. Partition-based incremental aggregates enable you to leverage your data warehouse's native partition (or cluster block) pruning capabilities when building and querying incremental aggregates. This can help reduce run-time query overhead observed in the view-based implementation of incremental aggregates.

Note

Partition-based incremental aggregates are only supported for the following data warehouse platforms: Snowflake, Databricks, BigQuery.

For information on enabling partition-based incremental aggregates, see About Incremental Rebuilds and Setting Properties to Allow Incremental Rebuilds of Aggregates.

Note

As part of this change, the default value of the aggregate.incrementalUpdates.semiAdditive.enabled setting has been changed to true. Note that this only enables the capability to build incremental aggregates for semi-additive metrics in the engine. The engine will not build incremental aggregates unless you explicitly configure the datasets in the model to do so.

ATSCALE-41898

Virtual filter dimension for SCDs​

You can now configure a virtual filter dimension for slowly changing dimensions (SCDs), which collects user-specified filter constraints and applies them to all SCDs used in a query. This enables BI tool users to set their desired filters on a single SCD, rather than having to specify a consistent set of filters across all SCDs in the query.

Note

Slowly changing dimensions are a Public Preview feature.

You can configure the virtual filter dimension using the following settings, available at both the global and model levels:

  • query.scd.versionHistory.name: Controls the name of the SCD virtual filter dimension exposed to BI tools. By default, this is set to Version History.
  • query.scd.versionHistory.folder: The folder in which the virtual filter dimension and hierarchy appear in BI tools.

For more information on the SCD virtual filter dimension, see Working with Slowly Changing Dimensions. For more information on the new settings, see Query Settings (global level) and Query Settings (model level).

ATSCALE-43500

New date filtering option on Queries page​

You can now filter the Queries page by a specific date range. The Last Started filter field contains a new Between option, which allows you to select a specific date and time range to filter queries by.

For more information on the Queries page, see Using the Queries Page.

ATSCALE-43208

Update service tokens for Microsoft Power BI reports from the AtScale Connection Portal​

You can now update service tokens for published Power BI Service reports from the AtScale Connection Portal. This enables Power BI users to easily update their report tokens without having to navigate through Design Center. For more information, see Using Power BI Service with Token-Based Authentication.

ATSCALE-43553

Improved Canvas state preservation​

Design Center provides improved state preservation for the Canvas. If you refresh the page, or log in to Design Center using a different browser, the current arrangement of your Canvas will be preserved.

ATSCALE-42783

Monitor queries via API​

You can now monitor query activity in AtScale via API. For more information, refer to the AtScale Container API documentation.

ATSCALE-42735

Export catalogs as JSON via API​

You can now export your catalogs to JSON format via API. For more information, refer to the AtScale Container API documentation.

ATSCALE-42734