New Features and Improvements
AtScale contains the following new features and improvements.
2022.4.1
In-memory dimensional aggregates is now GA
The in-memory dimensional aggregates functionality is now GA. For more information, see In-Memory Dimensional Aggregates.
Deactivating active aggregate instances
Using the new aggregates.demandDefined.disabled.deactivate
setting you
can choose whether to deactivate active aggregate instances if
demand-defined aggregates are disabled. For details, see Aggregate
Creation
Settings.
ATSCALE-13425
BigQuery Project Id for query execution
When editing the connection for a Google BigQuery data warehouse, you could use the new Project Id for query execution option to enter the BigQuery project in which queries are executed. For details, see Adding Google BigQuery Data Warehouses.
ATSCALE-12954
2022.4.0
Dimension Calculation Groups
Dimension Calculation Groups offer Data Architects a simplifying alternative to Calculated Measures by enabling the expression of boiler-plate calculations across multiple Measures. This feature defines calculations as dimension members, and removes static references to individual Measures. At run-time, workbook authors evaluate the dimension calculations over an arbitrary set of measures. Using this feature the number of Calculated Measures in a model can be reduced by a factor equal to the number of measures in the model. For details, see Using Dimension Calculation Groups.
ATSCALE-6108
Support for XMLA compression
When using BI clients that use XMLA, you can improve the communication
by enabling Xpress compression. You can do this using the new
soap.xpress.enabled
engine setting.
ATSCALE-10022
ADC-based impersonation for Google BigQuery
When using Google BigQuery as a data warehouse, you can now configure AtScale to use Application Default Credentials (ADC) impersonated with Service Account. For details, see Adding Google BigQuery Data Warehouses.
ATSCALE-12433
Support for Unity Catalog
When using Databricks as a data warehouse you can now use Unity Catalog. For details, see Adding Databricks Data Warehouses.
ATSCALE-9274
Using the %NOJOURN parameter for IRIS
InterSystems IRIS 2022.2 introduces the new %NOJOURN parameter for the
create table command. If you use this or newer version of IRIS as a data
warehouse, you can enable the new AtScale engine setting
aggregates.create.iris.nojourn.enabled
to set aggregates to be created
with the %NOJOURN keyword. For details, see Settings specific for
data
warehouses.
ATSCALE-11392
Enabling compression of AtScale aggregates on DB2
When using DB2 as a data warehouse, you can now enable value and row compression, and specify the type of row compression to be used. Enabling compression of AtScale aggregates could lead to improvements in disk space usage. For details, see Settings specific for data warehouses.
ATSCALE-1729
Cube-level settings for aggregates
Many of the aggregate configuration settings can now be set at cube level. For details, see Cube Level Configuration Settings.
ATSCALE-1856
Limiting Dimension-only queries
When using very large dimensions, you can use the new
query.language.mdx.dimquery.result.limit
setting to set the number of
data rows to be returned for Dimension-only queries. For details, see
Query
Settings.
ATSCALE-13161
Value Column label unified
In previous releases, the dialogs for creating or editing dimensions, levels, and secondary attributes contained a field labeled either Value Column or Name Column. Now this field is labeled Value Column in all of these dialogs.
ATSCALE-4186
Measure filtering for SuperDAX MD
Measure filtering is now supported for SuperDAX MD queries.
ATSCALE-11544
Displaying Query-based datasets
Query-based datasets are now displayed on the canvas with a different color, which differentiates them from the other datasets included in the cube.
ATSCALE-7231
Enhanced message for unsupported aggregation function
The "Unsupported aggregation function used within Aggregate function" message that appeared in the Queries screen is enhanced. It now contains information about the names of the Measure and the Calculation that triggered the error.
ATSCALE-13161
Beta features
AtScale offers Beta support for the following features:
-
Using external secret storage
Support for external secret managers (SM) will give you an opportunity to store all data warehouse passwords in one place (SM), and point AtScale to use this SM instead of typing the credentials manually. In I2022.4.1, AtScale will support this functionality in beta stage, and only Vault and AWS Secret Manager will be the options to use. (ATSCALE-11825)
In Settings > Organization Settings > Engine there are options for enabling and configuring the SM, like
secret.aws.enabled
andsecret.vault.enabled
. -
Starburst
You can use the Starburst data warehouse. (ATSCALE-12629)
Official support for these features is planned for future releases. If interested in beta testing, please contact your Customer Success Manager.