Skip to main content

What's New

The following sections describe new features and other changes available in each version of the AtScale add-in for Microsoft Excel.

v2.3.0​

New features​

Filter configuration enhancements​

The following enhancements have been made to the Filter by Values feature:

  • You can now press Enter in the Values text box to add a new line and continue adding filter values. Previously, pressing Enter closed the Filter by Values window without allowing you to add more values.
  • Secondary attributes are now listed under their display names, rather than their query names.
  • When searching for values in the Filter on field, matching values now display dynamically as you type. You no longer need to enter the full value name for it to appear in the results.
  • Filter values are no longer restricted by the query.language.mdx.dimquery.result.limit setting. For example, if query.language.mdx.dimquery.result.limit is set to 10, you can now filter by a valid value outside of the first 10 results.

ATSCALE-49745, ATSCALE-49951, ATSCALE-50349, ATSCALE-50478

Resolved issues​

Perspectives were listed under the model name during connection configuration​

During connection configuration, perspectives were listed under the name of the underlying model, rather than their own names. This issue has been resolved.

ATSCALE-50025

Exclude filter generated a separate query for each retained hierarchy member​

When filtering a hierarchy using the Exclude option, the AtScale add-in generated a separate query for each retained hierarchy member. For high-cardinality levels, this produced a large number of long-running queries, resulting in high data warehouse costs and unresponsiveness in the UI. This issue has been resolved.

Note

As a result of this change, Exclude filters are restricted to a single value per field. Additionally, Exclude filters can only be applied to fields currently in the pivot table. Note that this is standard Excel behavior.

ATSCALE-49856

Switching a pivot table's .odc file caused the AtScale add-in to fail​

Switching a pivot table's connection from one .odc file to another caused authentication to fail and the AtScale add-in to become unresponsive. This issue has been resolved.

ATSCALE-50231

Passwords were exposed in connection strings after re-applying the current .odc file or clicking Refresh All​

Passwords were exposed in connection strings after browsing to and re-applying the current .odc file, or clicking the Refresh All button in the ribbon. This issue has been resolved.

ATSCALE-49754

AtScale add-in executed queries before filters were applied​

When using the Filter by Values feature, the AtScale add-in executed a query when the user selected a column to filter on, before they actually applied the filter. For high-cardinality attributes, this resulted in long-running, costly queries, which could fail in the data warehouse. This issue has been resolved.

ATSCALE-49647

v2.2.2​

New features​

New behavior when "Require authentication on workbook open" is disabled​

When the AtScale add-in is installed with the Require authentication on workbook open option disabled, users can now authenticate with AtScale by either double-clicking within a pivot table, or by double-clicking the filter or page field area of the table. Previously, double-clicking the filter above the pivot table refreshed the table data.

For more information, see Connecting to Excel via the AtScale Add-In.

ATSCALE-48322

v2.2.1​

Resolved issues​

Could not rename worksheets​

In version 2.1.0, when trying to rename a worksheet, focus did not stay on the rename textbox and the worksheet could not be renamed. This issue has been resolved.

ATSCALE-49129

Row filter controls did not appear after authenticating with AtScale​

In version 2.1.0, the row filter controls in column headers did not appear, even after successfully authenticating with Atscale. This issue has been resolved.

ATSCALE-49131