Skip to main content

New Features and Improvements

AtScale contains the following new features and improvements.

MDX code completion for calculation formulas​

AtScale now provides code completion for MDX formulas for calculations. When working on a calculation in the Formula window, you can press Ctrl+Space to open the code completion panel. This lists the MDX functions, operators, statements, and objects that you can add to your formula. Additionally, as you work, the panel automatically displays contextual information about the specific function you're adding.

For more information, see Add Calculations.

ATSCALE-21518

API overrides for grace periods on incremental aggregates​

You can now override grace periods for incremental aggregate builds via the AtScale API. This enables you to run ad hoc incremental builds for specific datasets, without having to modify their configured grace periods.

This functionality is disabled by default, but can be enabled via the following settings:

  • Global level: aggregate.batch.gracePeriodOverrides.enabled
  • Model level: aggregate.batch.cube.gracePeriodOverrides.enabled

For more information, see Rebuilding Aggregates Using the REST API.

ATSCALE-23000

cURL commands for creating aggregate build schedules​

AtScale now provides full cURL commands for creating aggregate build schedules via API. These can be copied directly from the Build tab for each of your deployed models.

The commands are prepopulated with the model and catalog IDs; all you need to do is provide your API token and define the schedule for the job. For more information, see Scheduling Aggregate Builds.

ATSCALE-23291

Support for rollback statements from Apache Superset​

AtScale now supports rollback statements in queries from Apache Superset, enabling Superset to successfully connect to AtScale.

ATSCALE-23267

Support for SELECT * SQL statements for BI tools connected via PostgreSQL​

AtScale now answers SELECT * queries from BI tools connected via the PostgreSQL interface with preconfigured constant values. This enables BI tools that rely on metadata from SELECT * queries to connect to AtScale.

note

If you find you need to modify the constant values returned by AtScale, contact AtScale Support.

ATSCALE-22814