AtScale Release C2024.2.0 Summary

Product GA Date:  July 16th, 2024

Going forward, the AtScale C2024.x product will be released monthly! The microservice architecture enables us to deliver more quickly, and we encourage our customers to schedule time with AtScale Product Management (through your account team) in order to discuss the product roadmap and migration best practices.

New Capabilities with C2024.2.0

Multi-Engine Support

Our microservice architected platform adds multi-engine support to ensure high availability, failover and distribution of query workload. 

API

OpenAPI is joining our microservice revolution! Through this new framework, we’ll expose the aggregate management APIs with this release — and more APIs will be supported in future releases.

Developer Edition is Generally Available

Download (or upgrade) the AtScale Developer Edition for a free and locally installed AtScale. For additional information, read more here.

Enhanced Performance for Excel High Cell Count Queries

AtScale has improved multi-dimensional result set assembly performance for Excel. This improvement automatically detects high cell count query results and auto-optimizes them. The performance improvement is observable with small and large result sets.

Support for the MDX Aggregate Function

It is now possible to use the MDX AGGREGATE function with AtScale Calculated Measures. This unlocks the use of Calculation Group Templates with Calculated Measures.

New DAX Function

AtScale now supports the UTCNOW DAX function. 

New MDX Functions

AtScale now supports the following MDX functions: NULLEXCEPTALLMEMBERALLMEMBEREXCEPT. 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).

Watch demonstrations here.

Support for Distinct Count Estimates with Databricks SQL 

Always looking to add native support to the data platforms that AtScale supports, we’ve now added distinct count estimates (DCE) support for Databricks SQL.

Support for Enhanced Postgres Query Interface

AtScale introduced a Postgres interface last quarter. With this release, we've added more metadata support including the Postgres max column length parameter.

In addition, AtScale now more efficiently supports MIN/MAX queries on dimension attributes, providing improved performance for tooltips in Tableau reports.

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 measures which use CASE statements to check hierarchy members, and that emit 1-of-n measures from a single fact table.

Upgrading to this Release

We highly recommend our customers keep their AtScale environments up-to-date with the latest version. 

When you are ready to upgrade, please submit a request through the Customer Support Portal, and AtScale Tech Support Services will contact you to assist with the upgrade. 

Before starting software upgrade activities, please read the user documentation carefully, which you can find easily in the AtScale Help Center/Documentation channel.

 

Was this article helpful?

0 out of 0 found this helpful