What's New
The following sections describe new features and other changes available in each version of the AtScale Connector add-on for Google Sheets.
2.17.0
New features
Redesigned tooltips
Tooltips in the AtScale Connector have been redesigned and enhanced. Changes include:
- Tooltips for dimensions, metrics, and other attributes now display the attribute's description.
- Long tooltips are now scrollable.
- All tooltips now use a dark theme.
ATSCALE-47529, ATSCALE-52010
New visibility options for the filter summary table
Visibility of the filter summary table is now controlled via the Filter Summary Visibility section of the Settings panel. This section includes new options for showing/hiding the table in all documents, or only the current document.
You must click Update <sheet> to apply changes to these options.
ATSCALE-50457
Filters on values now take precedence over filters on the result set
Filters on report values are now applied before filters on the result set. This helps ensure all report data displays correctly when filtered.
ATSCALE-52206
Optimization for queries on secondary attributes
When a level and one of its secondary attributes are both added to a report's rows, the secondary attribute is now returned as a property of the level's members, rather than being crossjoined with the level. This change helps reduce costs and improve the speed of queries on secondary attributes.
ATSCALE-52419
Resolved issues
Reports took a long time or failed to update when using complex formulas referring to multiple sheets
Reports that contain complex formulas referring to multiple sheets took a long time to update, or failed to update at all. This issue has been resolved.
ATSCALE-50322, ATSCALE-44782
2.16.0
New features
Localization support
The AtScale Connector has been localized for French, in addition to English. The Connector automatically detects the preferred language set in your Google Account and updates all labels accordingly, so no configuration is required.
If your Google Account is configured to use a language other than English or French, the AtScale Connector defaults to English.
ATSCALE-28011
New Top and Bottom operators for filter conditions
You can now create filter conditions that return the TopN and BottomN results for the selected metric. Top results are sorted in descending order, while bottom results are sorted in ascending order.
To use this functionality, when creating a filter condition, set the operator to either Top or Bottom, then enter the number of results to display.
ATSCALE-49518
Refresh <sheet> button renamed to Update <sheet>
The Refresh <sheet> button has been renamed to Update <sheet> for clarity.
ATSCALE-50759
Data response size optimization
Responses from the AtScale engine have been optimized to remove repeated data. This reduces the overall response size and helps prevent the AtScale Connector from crashing.
ATSCALE-50130
Conditions on dynamic date filters now retained after refreshing the browser
Conditions set on dynamic date filters are now retained after the browser is refreshed or the AtScale Connector is re-opened.
ATSCALE-51402
Resolved issues
Apply Selected button was not visible at high zoom levels
When selecting a filter range from a spreadsheet, the Apply Selection button was not visible if the user was zoomed in on their browser. This issue has been resolved: The Range section of the filter panel now becomes scrollable when the browser is zoomed in.
ATSCALE-51030
Filter panel buttons appeared inactive
The Cancel and Save Filter buttons at the bottom of the filter panel appeared to be inactive, even when they were clickable. This issue has been resolved.
ATSCALE-50756
Numeric attributes were rendered as text in pivot tables
The AtScale Connector rendered numeric attributes as text in pivot tables. This caused errors when the locale for a sheet was changed from one that uses periods as decimal separators to one that uses commas, as the separators were not properly converted. This issue has been resolved: Numeric attributes are now rendered as real numbers.
ATSCALE-49664
Issues with filter selection using spreadsheet ranges across multiple sheets
If the user selected a range of filter values from a secondary sheet and applied them to the pivot table in the main sheet, the AtScale Connector remained focused on the secondary sheet, rather than returning focus to the main sheet. Additionally, the Update <sheet> button sometimes displayed the name of the secondary sheet, rather than the main sheet. These issues have been resolved.
ATSCALE-51030
2.15.0
New features
Leading zeroes in dimensional data now display in reports
The AtScale Connector now allows reports to display leading zeroes in dimensional data. This ensures data such as postal codes and similar values display correctly.
ATSCALE-45215
Active filter values now display above pivot tables
All active filter values now display above pivot tables in a new Filters section, enabling you to easily see all filters currently applied to your data.
This functionality is disabled by default. To enable it, open Settings, enable the new Show active filters above the table option, then click Update Table.
ATSCALE-47526, ATSCALE-49750
Filter configuration enhancements
Filter configuration has been enhanced, featuring new styling and improved workflows when selecting and sorting filter values.
ATSCALE-48831, ATSCALE-49341
Metadata warnings when switching sheets
If you switch to a different sheet and attempt to update it without syncing the metadata in the AtScale Connector panel, a popup now appears, from which you can either sync the metadata to the new sheet, or return to the previous sheet.
ATSCALE-41561
Data parser optimization
The AtScale Connector's data parser has been optimized to better handle large responses from the AtScale engine and prevent the add-on from crashing.
ATSCALE-49748
Resolved issues
Dimension-only queries took a long time to process
Dimension-only queries took a long time (several minutes) to process. This issue has been resolved.
ATSCALE-45133
AtScale Connector displayed confusing error messages when users did not have access to models
When a user opened a sheet connected to a model they no longer had access to (or that had been renamed or deleted), the AtScale Connector displayed a confusing error message. This issue has been resolved: When a user tries to access a model they don't have access to, the AtScale Connector now displays an error clearly stating that they don't have access.
ATSCALE-45213
Changes to column order were not reflected in pivot table headers
When report columns were reordered in the Columns section of the AtScale Connector panel, the column data updated accordingly, but the table headers remained in their original positions. This issue has been resolved.
ATSCALE-45400
Combining Dynamic Date filters with Condition filters on metrics produced incorrect results
Combining a Dynamic Date filter with a Condition filter on a metric produced incorrect results. This issue has been resolved.
ATSCALE-50158