New Features and Improvements
AtScale contains the following new features and improvements.
The query.planning.semiAdditive.forceIndividualMeasureCheck engine setting now defaults to FALSE
The default value of the query.planning.semiAdditive.forceIndividualMeasureCheck engine setting has been changed from true to false. The value of false produces more efficient outbound SQL; however, it has the following data engineering requirement.
When this setting is false (default), AtScale does not submit subqueries per individual semi-additive measure, resulting in fewer passes of the data. However, this approach requires that you engineer your fact data to ensure data is available at the same level throughout. Without this preliminary data engineering work, query results may be incorrect.
If you are unsure if your data meets this standard, or you do not have data engineering practices in place to ensure data integrity (such as eliminating null data for inventory use cases), this setting should be changed to true. When true, AtScale submits subqueries for individual measures, which ensures a correct response, but results in multiple passes of the data.
For more information on the query.planning.semiAdditive.forceIndividualMeasureCheck setting, see Query Settings.
ATSCALE-25823
Configure visibility for calculation groups and calculations in BI tools
You can now configure whether calculation groups and individual calculations appear in BI tools. To support this functionality, the dialogs for creating and editing calculation groups and calculations now contain Visible options, which can be enabled/disabled as needed.
For more information on working with calculation groups and calculations, see Adding Calculation Groups and Adding a Calculation.
ATSCALE-24797
Configure permissions checks for projects on the Design Center Welcome page and Projects page
You can now configure AtScale to perform permissions checks for projects that appear on the Welcome and Projects pages. This functionality can be enabled/disabled using the new Projects check permissions option under Settings > Organization Settings > Options. This option is disabled by default.
For organizations that contain a large number of projects, enabling this option may result in slow loading times for the Welcome and Projects pages.
For more information on configuring options, see Enable or Disable Features. For more information on the Projects page, see Managing Projects.
ATSCALE-25351