Known Issues
Before installing or upgrading AtScale, please review this section to be aware of all known issues.
I2024.2.6
Iris JDBC does not support CTEs
The Iris JDBC driver does not support Common Table Expressions (CTEs), so the recent feature that enables the query planner to use CTEs is not supported for Iris. If you are using AtScale on Iris, you need to set the following engine setting:
QUERY.PLANNING.ALLOWCTES=False
By default, this setting is set to True
.
Some GBQ aggregate creation queries falsely display as Failed
Some Google BigQuery aggregate creation queries will display as Failed when they actually succeeded. This issue does not affect the display of the aggregate instance status, which is correctly displayed as Active.
ATSCALE-23272
For cubes with more than 1600 attributes, AtScale fails to answer all PostgreSQL metadata queries from BI tools
When connected to BI tools via the PostgreSQL interface, AtScale fails to answer all metadata queries on cubes that have more than 1600 attributes. This is due to a limitation of the PostgreSQL database used to answer these queries.
ATSCALE-22911
Limited data platform support
This release features support for the following data platforms:
- Databricks
- Snowflake
- Google BigQuery
- MSSQL
- Postgres
- Iris
Other supported data platforms will be reintroduced in a later release, including:
- Hadoop platforms: CDP, Hortonworks and MapR
- Synapse
- Redshift
- DB2
Cubes without a measure or dimension fail to publish
In I2024.2.4, cubes that do not contain a single measure and/or a single dimension cause projects to fail to publish. While the product allowed this in the past, a measureless and dimensionless cube is an illegitimate cube. It provides no function and utilizes server memory on publish. AtScale recommends cleaning up/modifying these cubes in projects intended for publish.
ATSCALE-22808
Simba Hive driver only supports ASCII character set
Non-ASCII character sets are not interpreted properly by the Simba Hive driver. For customers requiring broader character support, AtScale recommends using the PostgreSQL interface.
ATSCALE-13603
Aggregation Functions For Calculated Measures
The aggregation functions for calculated measures functionality is currently only supported on Snowflake and Google BigQuery. A future dot release is planned to extend support to other platforms.
ATSCALE-20465
Microsoft Power BI: Is-Not Filters Result in Incorrect Grand Totals for PeriodsToDate Calculated Measures in Some Situations
Microsoft Power BI visualizations display incorrect Grand Total values when Is-Not filters are applied to calculated measures that use the PeriodsToDate function. As a workaround, you can use the DatesPeriodsToDate function on calculated measures, for which Power BI displays correct Grand Total values.
ATSCALE-20118
Editing calculated measures fails after duplicating cubes
After duplicating a cube within a project, you cannot edit the calculated measures within the new cube. Because of this issue, the Duplicate feature is disabled at the cube level.
As a workaround, you can use the Duplicate feature at the project level.
ATSCALE-18622