Skip to main content

New Features and Improvements

AtScale contains the following new features and improvements.

Support for shared degenerate dimensions​

You can now create shared degenerate dimensions in AtScale. Shared degenerate dimensions are degenerate dimensions that are composed of data from multiple fact datasets.

You can create shared degenerate dimensions via Design Center as well as SML. For more information, see Degenerate Dimensions, Add a Degenerate Dimension, and the SML Object Documentation on GitHub.

ATSCALE-22736

Configure incremental aggregate builds​

You can now configure incremental aggregate builds for specific datasets within Design Center. Previously, this could only be done via SML.

To support this functionality, the Dataset properties panel includes a new Aggregate Preferences section, where you can set the incremental indicator and grace period to use for incremental aggregate builds. For more information, see Setting Properties to Allow Incremental Rebuilds of Aggregates.

ATSCALE-23077

Aggregate maintenance jobs​

AtScale now runs aggregate maintenance jobs daily at 04:00 UTC. The aggregate maintenance job performs tasks like health checks on all active aggregate instances and cleanup of orphaned or unreliable aggregates. For more information, see Aggregate Maintenance.

ATSCALE-21787

Common table expressions​

The AtScale engine now uses common table expressions (CTEs) to reduce redundancy in queries, thereby reducing query size.

This functionality is controlled via the new QUERY.PLANNING.ALLOWCTES global setting, which is enabled by default. For more information, see Query Settings.

ATSCALE-15188

Distinct count aggregates at non-leaf levels​

AtScale now creates distinct count aggregates at the level specified in the query, rather than at the leaf level of the hierarchy. This ensures that distinct count aggregates are used by the query planner.

This functionality is enabled by default, and can be controlled via the new aggregates.create.withDistinctCounts.queryLevel.enabled model setting. For more information, see Aggregate Creation Settings.

ATSCALE-23344

Tableau: Improved tooltip performance​

AtScale now uses aggregates to accelerate queries related to Tableau tooltips, providing improved performance for tooltips in reports.

This functionality is enabled by default, and can be controlled via the following model-level configuration settings:

  • aggregates.systemGenerated.higherOrder.retentionPercentage: The maximum number of active higher order aggregates per model is calculated as this percentage of the value of aggregates.systemGenerated.activeInstance.retentionLimit for each model. This pool of system-defined aggregate tables is sized and counted separately from the regular system-defined aggregate table pool. The default value is 30.
  • aggregates.create.higherOrder.enabled: When set to true, allows the aggregate system to build aggregates on a higher level if the compression score at the lowest level is not met. The default value is true.
  • aggregates.create.higherOrder.dimensionalAttributes.size: The limit of dimensional attributes in the query in order to consider building a higher order aggregate. The default value is 10.

For more information, see Aggregate Creation Settings.

ATSCALE-21043