Skip to main content
Version: Next

Resolved Issues

The following issues have been resolved.

I2024.2.6

Query-based datasets failed to save after their SQL statements were edited

Query-based datasets failed to save after their SQL statements had been edited. This issue has been resolved.

ATSCALE-22650

Building system aggregates with semi-additive measures failed

Building system aggregates for semi-additive measures failed. This issue has been resolved.

ATSCALE-22822

Semi-additive measures with level aliases showed wrong grant totals

Semi-additive measures with level aliases showed wrong grand total values. This issue has been resolved.

ATSCALE-22686

Microsoft Excel: Values for CUBEMEMBER expressions did not display after reports were saved, closed, reopened, and then refreshed

In Excel, reports did not display values for expressions using the CUBEMEMBER MDX function after the report was saved, closed, reopened, and then refreshed. This issue has been resolved.

ATSCALE-22579

Excel: The Cubemember and CubeValue MDX functions sometimes displayed #N/A for valid responses

In Excel, Cubemember and CubeValue MDX functions sometimes displayed values of #N/A for valid responses. This occurred when a Cubemember or CubeValue function anywhere in the report returned a value that did not exist in the database. This issue has been resolved.

ATSCALE-22493

Excel: Pivot tables with grouped fields and multi-select filters did not show latest data when refreshed

In Excel, pivot tables with grouped fields and multi-select filters did not show the latest data after they were refreshed. This issue has been resolved.

ATSCALE-22524

Excel: Fields with multi-select filters could not be grouped

In Excel, fields in pivot tables could not be grouped when they had multi-select filters applied. This issue has been resolved.

ATSCALE-22505

Excel: Slicers only showed first values of hierarchies with default members defined

In Excel, when a slicer was used in a pivot table on a hierarchy that had a default member defined, the slicer only showed the hierarchy’s first value, rather than its default value. This issue has been resolved.

ATSCALE-22481

Excel: Moving the Values column below an attribute in the Columns area caused Grand Totals to disappear

In Excel, moving the Values column below an attribute column in the Columns area of the PivotTable Fields pane caused Grand Totals to disappear from pivot tables. This issue has been resolved.

ATSCALE-22375

Excel: Using filters with grouped fields caused errors

In Excel, applying filters to grouped fields in pivot tables caused errors. Errors also occurred when grouped fields were used as filters. This issue has been resolved.

ATSCALE-22364

NULLEXCEPT MDX function did not work with secondary attributes

The NULLEXCEPT MDX function did not work when used with secondary attributes. This issue has been resolved: NULLEXCEPT now works with both secondary attributes and level aliases.

ATSCALE-22109

Calculation groups showed the same Subtotal and Grand Total on partial selection of months on a time hierarchy

In reports that included calculation groups, on partial selection of months in a time hierarchy, the Subtotal at the year level and the Grand Total displayed the same values. This issue occurred when the year level had a Custom Empty Member defined. This issue has been resolved.

ATSCALE-21402

Excel: Creating groups on filtered rows worked but produced errors

In Excel reports, creating a group on a filtered row produced an error. After the error was dismissed, the group was successfully created. This issue has been resolved: groups can now be created on filtered rows without errors.

ATSCALE-23210

I2024.2.4

Microsoft Excel: Filter applied on unrelated dimension level did not show relevant values for non-admin users

In Excel, filters were not properly applied at the dimension level for non-admin users. This issue has been resolved.

ATSCALE-22072

Outbound query optimization for unrelated dimensions

AtScale now includes an optimization for outbound queries on base measures that use the Include empty cells in query results option for unrelated dimension handling. This optimization improves performance for sub-queries that generate SELECT statements for all columns assigned with NULL values.

ATSCALE-21802

Excel: Keep Only Selected Items filter was slow

In Excel, applying the Keep Only Selected Items filter to high cardinality secondary attributes and level aliases resulted in slow performance. This issue has been resolved: the filter’s performance for secondary attributes and level aliases is now optimized.

ATSCALE-21434

Microsoft Power BI: Visualizations failed when calculation group values were filtered out

In Power BI, matrix and table visuals failed when one or more values from a calculation group were filtered out via Filters on this visual > Time Calculation > Basic Filtering. This issue has been resolved.

ATSCALE-19841

Power BI: Matrix visualizations with degenerate levels resulted in error

In Power BI, expanding/collapsing results in matrix visualizations that included degenerate levels on rows resulted in an error. This issue has been resolved.

ATSCALE-17754

Excel: Using calculation groups as filter slicers resulted in error

In Excel, using calculation groups as filter slicers resulted in an error. This issue has been resolved.

ATSCALE-17319

Power BI, Excel: Single-level hierarchies displayed without hierarchy name

In Power BI and Excel, single-level hierarchies with no secondary attributes displayed without the hierarchy name. This issue has been resolved: hierarchies now always display with their dimension, hierarchy, and level names, whether or not they include secondary attributes.

ATSCALE-22501

PowerBI: Sort keys did not work on secondary attributes

In PowerBI, sort keys did not work on secondary attributes when there was only one in the hierarchy, resulting in values not being properly sorted. This issue has been resolved.

ATSCALE-22204

PowerBI: Reports did not render when they contained Decimal secondary attribute values of 20 or more digits

In PowerBI, reports did not render when they contained secondary attributes whose values were of type Decimal and were 20 or more digits in length. This issue has been resolved.

ATSCALE-22203

FluenceXL: Drill-down actions did not work properly in reports

In FluenceXL, drill-down actions did not work properly in reports. This issue has been resolved.

ATSCALE-22263

FluenceXL: Filtering measures by name in MDX did not work

Filtering measures by name in MDX did not work in FluenceXL. This issue has been resolved.

ATSCALE-22201

Multi-cube models accessed via the inbound PostgreSQL interface were not completely updated on publish

For AtScale installations that use the PostgreSQL interface, publishing projects with multiple cubes could create race conditions that resulted in only a subset of those models being created in the metadata database. This issue has been resolved.

ATSCALE-22199

Renaming UDAs caused aggregate build failures

When a user-defined aggregate was renamed, rebuilds of the aggregate failed. This issue has been resolved.

ATSCALE-20771

I2024.2.3

Nginx Updated to 1.26.2

Nginx was updated to 1.26.2 to address an Nginx EOL (1.22.0_1) in a previous release.

DEVOPS-5204

Excessive traffic over the Engine to Engine communication channel caused by XMLA sessions could lead to engine restarts and lookup query timeouts in clustered AtScale environments

In clustered AtScale environments (with or without Query Engine nodes), if requests containing the same XMLA sessionId occur against multiple hosts, the requests and responses for those sessions were transferred across the Engine to Engine communication channel back to the original host that registered the session. This could result in the Engine to Engine communication channel becoming overloaded, causing cube level and other session state lookups to time out. This, in turn, could lead to user query failures or restarts of the secondary Engine nodes, due to heartbeat keep alive timeouts.

This issue has been resolved. XMLA sessions are now managed so that the Engine or Query Engine node that receives a user request now processes the request and sends the response, directly avoiding the transmission of these requests over the Engine to Engine communication channel.

ATSCALE-22005

Duplicate aggregates created for some partitioned aggregates

A condition was found where AtScale could create duplicate aggregates of partitioned aggregates. The only difference between the duplicates and the originals was the ordering of their contents. This issue has been resolved.

ATSCALE-21951

Microsoft Power BI, Excel: Reports and queries failed when SOAP.SAFE.XML.PARSING was enabled

The AtScale Engine setting SOAP.SAFE.XML.PARSING can be enabled to prevent XXE attacks. Previously, when this setting was enabled, Power BI and Excel reports and queries would fail against AtScale. This issue has been resolved: when the setting is enabled, Power BI and Excel queries and reports should no longer fail.

note

SOAP.SAFE.XML.PARSING is disabled by default. To enable it, go to Engine > Settings and click Custom Settings. Enter the following values, then click Save.

  • Setting Name: SOAP.SAFE.XML.PARSING
  • Setting Value: true

You do not need to restart the engine after changing this setting.

ATSCALE-16773, ATSCALE-20815

I2024.2.2

Broken Access Control Vulnerability

Low privileged users were able to access details for private projects and cubes, such as names, descriptions, and cube/project IDs, via the API. This issue has been resolved. Authorization checks have been improved to ensure that only users with the appropriate permissions can access private project/cube details.

ATSCALE-19739

Insecure Direct Object References Vulnerability

Low privileged users were able to update private cubes that were in a draft state via the API. This issue has been resolved. Authorization checks have been improved to ensure that only users with the appropriate permissions can edit cube details.

ATSCALE-19742

Queries failed during planning stage

In AtScale I2024.2.1, queries occasionally failed during the planning stage. This issue has been resolved.

ATSCALE-21316

Queries were generated using unnecessary outer joins

When fact-connected security dimensions were enabled, queries on unconnected dimensions were generated using unnecessary outer joins, resulting in slowed performance. This issue has been resolved.

ATSCALE-21133

Security dimensions were incorrectly applied to unconnected dimensions

Security dimensions with Use Filter Key lookup rules were incorrectly applied to queries on unconnected dimensions. This resulted in multiple unnecessary lookup queries being generated for all queries. This issue has been resolved.

ATSCALE-21130

Microsoft Excel: Incorrect grand totals displayed for semi-additive measures

In Excel, grand totals for first/last non-empty semi-additive measures displayed the same values as additive measures with an aggregation function of SUM, rather than the respective first/last non-empty value for the first/last key value defined. This issue has been resolved.

ATSCALE-21528

Excel: Queries on unrelated dimensions and measures produced syntax errors

Queries on cubes that contained unrelated dimensions and measures produced syntax errors in Excel. This issue has been resolved.

ATSCALE-21169

Excel: Security dimensions caused failed queries

Security dimensions occasionally resulted in failed queries in Excel. This issue has been resolved.

ATSCALE-21026

Queries canceled in Excel or Tableau remained running in Snowflake

Queries that were canceled in either Excel or Tableau were subsequently canceled in Design Center, but continued running in Snowflake. This issue has been resolved.

ATSCALE-16832

I2024.2.1

Hadoop recertified for I2024.2.1

I2024.2.1 resolved query issues found with Cloudera CDP. Cloudera Hadoop and HP MapR are supported in I2024.2.1 and moving forward.

ATSCALE-21563

AtScale engine failed to start after upgrade

After upgrading, the engine failed to start with an error from pgwire. This issue has been resolved.

ATSCALE-21572

PostgreSQL was only listening to the localhost port

PostgreSQL was only listening to the localhost port, which caused the pgwire interface to fail on FQDN installs. This issue has been resolved.

ATSCALE-21601

Microsoft Excel: Reports containing Calculation Groups and Calculated Measures with Hidden Measures failed

In Microsoft Excel, reports failed when they contained both a calculation group and calculated measure that contained a hidden measure. This issue has been resolved.

ATSCALE-20788

Excel: Level hierarchies with key columns >16 digits did not display properly

Excel reports did not properly display hierarchy levels that used Long values longer than 16 digits as their key columns. When these levels were expanded, Excel created new rows, rather than displaying the full levels. This issue has been resolved.

ATSCALE-19778

Excel: ParallelPeriod Produced Incorrect MTD Values on and After Leap Years

In Excel, MDX expressions that included the ParallelPeriod function produced incorrect MTD values on and after leap years. This issue has been resolved.

ATSCALE-20780

Microsoft Power BI Online Service: The Export Data option failed with Matrix Visual Reports

In Microsoft Power BI Online Service, using the Export Data option from a matrix virtual report failed when both of the following conditions were true:

  • The AtScale model used in the report contained a security dimension with a lookup rule of Use Filter Key.
  • The Power BI report was created with a connection that included daxdialect=tabular or daxdialect=superdaxmd.

This scenario also caused queries to fail in AtScale. This issue has been resolved.

ATSCALE-20271

Power BI: Reports containing measures with UTCNOW() failed

In Power BI, reports containing measures that used the UTCNOW() DAX function failed. This issue has been resolved.

ATSCALE-19848

Power BI: Incorrect outbound queries generated when Filtering by NULL and using SuperDAXMD

When connected to Power BI using SuperDAXMD, filtering reports by NULL values incorrectly yielded no results. This was caused by incorrect outbound queries being generated in AtScale. This issue has been resolved.

ATSCALE-18260

Power BI: Calculation Group Totals Did Not Display in Some Situations

In Microsoft Power BI, calculation group totals did not display in visualizations that had multiple measures selected and were filtered by a subset of the calculations. This issue has been resolved.

ATSCALE-20030

Power BI: Applying Multiple Degenerate Dimension Level Slicers Reset Other Slicers

In Power BI, applying multiple slicers based on degenerate dimension levels reset other slicers in the report to All. This occurred when all slicers involved were based on degenerate dimension levels. This issue has been resolved.

ATSCALE-18032

Tableau: Date Offset Queries for MS SQL Server were not Supported with PostgreSQL Drivers

Previously, AtScale did not support Tableau-generated Date Offset queries (e.g. Now() - INTERVAL 30 DAYS) for MS SQL Server using AtScale's Postgres interface. This issue has been resolved.

ATSCALE-20484