Skip to main content

New Features and Improvements

AtScale contains the following new features and improvements.

API Support

AtScale now exposes its aggregate management APIs. Among other things, you can use the APIs to do the following:

  • Create and manage aggregate creation schedules.
  • Import and export system-defined aggregate instances.

For information, see the AtScale Container API documentation.

ATSCALE-18897

New Git Workflows: Revert All And Revert Selected

The Source Control panel now contains options for reverting all changes in your workspace, and reverting multiple selected changes. For more information, see Git Workflows.

ATSCALE-20146

Alternative SQL Dialects For Datasets

You can now define multiple SQL dialects on your datasets via SML. This enables you to create single objects that are compatible with different types of data warehouses. For more information, see the AtScale SML Object Documentation on GitHub.

ATSCALE-20299

Number Of Deployed Objects On Licenses Page

The Licenses page now displays the number of objects deployed in your AtScale instance. This enables you to keep track of your deployed objects as they pertain to billing. For more information on the Licenses page, see Viewing and Updating Licenses.

ATSCALE-21138

Support For Public Git Repositories

You can now connect AtScale to public Git repositories. This enables you to work with AtScale's sample repository. Note that when connecting to a public repository, you do not need to enter any Git credentials.

For more information, see Managing Git Repositories in AtScale and Connecting to Git.

Aggregation Functions For Calculated Metrics

You can now set the specific aggregation function to use for a calculated metric when it is referenced by the Aggregate MDX function. This enables you to more easily reference calculated metrics from calculation groups.

To support this functionality, Edit Calculated Measure panel now contains an MDX Aggregation Function field, where you can select the aggregation function to use.

Additionally, SML calculation files now support the mdx_aggregate_function property, which you can use to specify the aggregation function to use for the calculation via SML.

note

AtScale recommends setting the aggregation function to a value other than None for calculated metrics that are referenced via calculation groups.

For more information on the new field, see Add Calculated Metrics. For more information on the new SML property, see the AtScale SML Object Documentation on GitHub. For more information on the Aggregate function, see Aggregate.

ATSCALE-20582

New MDX Functions

AtScale now supports the following MDX functions: NULLEXCEPT, ALLMEMBEREXCEPT, ALLMEMBER. These enable you to control how sensitive your server-side calculations are to the inbound query context (i.e., the dimensions used in a query's grouping and filtering directives).

For more information on the new functions, see MDX Reference.

ATSCALE-19554

Distinct Count Estimate Aggregates With Databricks SQL

AtScale can now create aggregates using the distinct count estimate function when connected to a Databricks SQL data warehouse.

ATSCALE-10988

New DAX Function

AtScale now supports the UTCNOW DAX function. For more information using DAX Tabular with AtScale, see Using DAX Tabular.

ATSCALE-19848

Microsoft Excel: Improved Performance For Multi-Dimensional Result Set Assembly

AtScale now has improved performance for multi-dimensional result set assembly in Microsoft Excel, resulting in faster processing times.

Previously, result set assembly in Excel took a long time for queries that returned high numbers of cells. This improvement results in a 75% reduction in processing time for queries in the range of 100 thousand cells, and a 90% reduction in time for queries in the range of 1 million cells.

ATSCALE-16696

Outbound Query Optimization For Multi-Fact Models

AtScale is now optimized to reduce the size of outbound queries for multi-fact models that contain calculated metrics that use CASE statements to check hierarchy members, and that emit 1-of-n metrics from a single fact table.

ATSCALE-20234