Aggregation functions for calculated measures

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

To support this functionality, the dialog boxes for creating and editing calculated measures now contain an MDX Aggregation Function field, where you can select the aggregation function to use.

Note: AtScale recommends setting MDX Aggregation Function to a value other than None for calculated measures that are referenced via calculation groups.

For more information on the new field, see Add Calculated Measures. For more information on the Aggregate MDX 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

Tableau with PostgresSQL

You can now connect to Tableau using the PostgresSQL JDBC driver. For instructions on configuring this, see Installing PostgresSQL JDBC Drivers.

ATSCALE-20346

Tableau: Improved tooltip performance

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

ATSCALE-20241

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

ATSCALE-20234