Changelog

This page lists the version history of QiBates Extensions releases.

68054ba1 (2025-03-26)​

Bug Fixe​

• Google Sheets :
  • Planning :
    • Handling of PIPE character encoding.

New Features​

• Google Sheets :
  • Essbase :
    • Added a form library.

Improvements​

• Google Sheets :
  • The "Server" field in the connection view no longer displays personal addresses stored by the browser.
  • Improved user interface.
  • Essbase :
    • An error message is now displayed when the name of the sheet created by the cascade already exists.
  • SSAS :
    • Updated to SSAS V2.

6a27ebbb (2024-11-20)​

Bug Fixe​

• Google Sheets :
  • Planning
    • Fixed the display of the window that appeared too small when launching a script.

New Features​

• Google Sheets :
  • Added the ability to import and export settings.
  • Planning :
    • When an administrator updates a task list or a form, it is now possible to refresh the entire hierarchy without logging out.

Improvements​

• Google Sheets :
  • Planning
    • Improved handling of #Error.
    • Smartlists are now displayed in the order defined in Hyperion Planning.
    • Enhanced the alert message for script execution timeout.

98b1ac99 (2024-08-08)​

Bug Fixe​

• Google Sheets :
  • PBCS/Planning
    • The drop-down lists of viewpoints no longer have a number limitation.

Improvements​

• Google Sheets :
  • Added notifications at the end of data submissions.
  • Improved the display of hours in messages.
  • Essbase
    • Improved error message display for cascading actions.
  • PBCS/Planning
    • Display of the "no action on this cell" submenu when the form menu is empty.
    • Improved informative message when submitting cells with more than 255 characters.

71cdc4d5 (2024-07-10)​

Bug Fixe​

• Google Sheets :
  • PBCS/Planning
    • Improvement of error message management.

Improvements​

• Google Sheets :
  • It is no longer necessary to log in to Google twice for authentication during the first login.

34c21ead (2024-05-15)​

Bug Fixe​

• Google Sheets :
  • PBCS/Planning
    • A problem with launching scripts from a form via a contextual menu has been fixed.
  • Essbase
    • Submissions on Essbase now work correctly.
    • The syntax for named ranges has been fixed, allowing a sheet to be named starting with a number.

Improvements​

• Google Sheets :
  • The management of session timeout has been improved for a better user experience.
  • Planning
    • Views are now better managed in the scripts executed during saving.

b75c682d (2024-04-24)​

Bug Fixe​

• Google Sheets :
  • The "No Access" color option now functions correctly.
  • PBCS
    • Disassembling after merging cells now functions correctly.
    • The "keep-only" action now works on rows.
  • Essbase
    • Correction of the management of numeric members in grids.
    • Colors for "Colorcoding" that were not displaying now appear correctly.

Improvements​

• Google Sheets :
  • Essbase
    • Improved editing interfaces for types and labels.
  • PBCS/Planning
    • The "complete/not complete" option is no longer displayed on the parent node in the task.
    • Red indicators on cells indicating "Invalid - entry must be a valid date" now only appear on editable cells.
    • The POV section dropdown now displays aliases when the form property is set to show aliases only.
  • PBCS
    • After duplicating an ad-hoc sheet and refreshing the second sheet, the sheet content is now correctly refreshed.
    • When refreshing an ad-hoc sheet, formulas are now retained.
    • Error messages that were displaying in French are now displayed in English.
    • The second row is hidden based on form settings.
  • Planning
    • When refreshing on a sheet with no metadata, a warning is now displayed with a more explicit message.

0953e734 (2024-03-06)​

Bug Fixe​

• Google Sheets :
  • Refreshing a form while connected to Essbase no longer breaks the sheet and now displays a "warning" message.
  • The "number precision" option set to "0" has been corrected.
  • PBCS
    • AdHoc action on PBCS now considers the selected alias table.
    • The alias table displays correctly on cell A1 of PBCS cubes.

New Features​

• Google Sheets :
  • Essbase :
    • Addition of "Member Colour" functionality to Essbase colors.

Improvements​

• Google Sheets :
  • User interface improvements: "login, toasts, toast flow, POV, data prediction, member selection, data integration, help, about, cascade".
  • Error messages during "Zoom-In, Zoom-Out, Keep-Only, Remove-Only, Refresh/Refresh All, Submit/Submit All" actions now display with the sheet name to identify the origin of the problem more easily.
  • By default, Essbase colors match those on Planning.
  • Planning
    • Improved storage of selected members on Planning to retain them between each session.
    • Enhanced management of form ranges. It is now possible to add comments around forms, and there is no longer protection outside of forms.
    • Increased inactive session duration on Planning to 3 hours.

07865ddf (2024-01-23)​

Bug Fixe​

• Google Sheets :
  • Improved handling of numeric members in grids and forms.

New Features​

• Google Sheets :
  • Added a button to view the toast messages history.

Improvements​

• Google Sheets :
  • Improvement of the application's settings screen for an optimized user experience.
  • Essbase
    • Loading data files onto Essbase.

5dae9951 (2023-10-05)​

Improvements​

• Google Sheets :
  • Planning
    • Improvement of the metadata storage management for forms.

950cbf38 (2023-09-27)​

Bug Fixe​

• Google Sheets :
  • Planning
    • Implementation of a compression algorithm to optimize the storage of form metadata.
  • Essbase
    • Due to the new standards set by Google for the certification of our add-ons, the ability to import data from a file located in Google Drive has been temporarily disabled.

71113ef0 (2023-08-30)​

Bug Fixe​

• Google Sheets :
  • Essbase
    • Improvement of digital members management for the POV line.

71113ef0 (2023-08-21)​

Bug Fixes​

• Google Sheets :
  • A link to the QiBates documentation has been added to the help screen.
  • Essbase
    • The user interface for managing grid types and labels has been improved.
  • Planning
    • The data submission on Planning is working correctly after the alias modification.

8263f907 (2023-07-31)​

Bug Fixes​

• Google Sheets :
  • Essbase
    • Special characters in server, application and cube names are now supported.

a2f276e5 (2023-07-03)​

Bug Fixes​

• Google Sheets :
  • The color modification on edited cells has been removed.
  • Planning
    • The color management on empty forms is now handled.
    • The spinner on opening forms has been fixed.

Improvements​

• Google Sheets :
  • A blue toast message indicates now the additional informations.
  • The Qibates interface is now compatible with Safari.
  • Check color coding for background coloration in data predictions.
  • The interfaces on "Task list" and "Available connections" have been improved.
  • Essbase :
    • Cascade :
      • A warning message appears when the cursor is not in an existing grid.
      • Keep the format if color coding is disabled.
      • Keep the number format if number precision is disabled.
      • Keep formulas.
      • Keep the same position as the grid in the cascade.
    • The pivot to POV now rotates the member into a point of view, not just the dimension.

New Features​

• Google Sheets :
  • Essbase :
    • Each grid can have a custom label.
    • It is now possible to create grid types and group grids within types.
      • Each grid can be associated to only one type.
      • The "Refresh type" action refreshes all grids with a specific type.
    • Comments are added to cells to indicate when there are comments in the member area. It is possible to enable this feature with the new "Unknown Member Indication" setting.

2694f694 (2023-05-10)​

Bug Fixes​

• Google Sheets :
  • A better timeout handler has been implemented to improve the performance of the add-on.
  • Handling of timeout errors when listing servers, applications, cubes, tasks, and forms has been improved to prevent errors and improve the stability of the add-on.

Improvements​

• Google Sheets :
  • Essbase :
    • The label for the "signin" button has been changed to "refresh" when trying to refresh directly from the extensions sub-menu to make it more intuitive and easier to understand.

New Features​

• Google Sheets :
  • Essbase :
    • A new feature called "submit all" has been added, which allows users to submit all the grids in the sheet at once.
    • Users may submit grids regardless of the cells they have selected.
  • Planning :
    • It is now possible to launch runtime prompt rules on submit action.
    • It is no longer possible to enter an invalid value in a cell of type date.
    • The error handling system has been improved to make it easier for users to understand.
    • Prohibit unauthozized value entry for smartlist

2233a5cb (2023-02-20)​

New Features​

• Google Sheets :
  • Planning :
    • It is now possible to launch task rules whose execution time exceeds 10 seconds.

40556175 (2023-01-30)​

New Features​

• Google Sheets :
  • Planning :
    • During form loading, if a cell contains text exceeding 255 characters, an error message will display and the data load will become invalid.
    • The "Submit With Long Cell" option has been added in the planning settings. When this option is checked, valid data will be sent but cells containing more than 255 characters will be ignored and replaced with previous valid values.

4d6a4f85 (2023-01-23)​

Improvements​

• Google Sheets :
  • Essbase :
    • Session management in connection pools has been improved.

4d6a4f85 (2023-01-16)​

New Features​

• Google Sheets :
  • Planning :
    • Data loading from a Planning webform in QiBates referencing old labels is now supported.

e92c1548 (2023-01-09)​

Bug Fixes​

• Google Sheets :
  • Planning :
    • Apostrophes are now handled correctly when loading data.

9e7e4338 (2023-01-02)​

Bug Fixes​

• Google Sheets :
  • Essbase :
    • Fixing grid display with codes and aliases after every action and refreshing grids.
    • Fixing the selection of the "Display code and alias" option in the "Settings" view after logout and login.
  • Essbase 21C :
    • Fixing the connection to Essbase 21C.

Improvements​

• Google Sheets :
• Essbase :
  • When an action is in progress on the member selection, it is no longer possible to switch dimensions before the execution is completed.
  • In order to recreate the connection on a cube from Qibates, you must systematically choose the connection relative to the cube through the "Set as active" button.

New Features​

• Google Sheets :
  • Essbase :
    • The connection of the last refreshed cube is automatically set as active by default.

b3961957 (2022-11-30)​

Bug Fixes​

• Google Sheets :
  • Planning :
    • Taking into account session cookies used by the load balancer.

b3961957 (2022-11-28)​

Bug Fixes​

• Google Sheets :
  • Essbase :
    • Numbers that have the same value as member names are now considered numbers and not members.
    • For dimensions requiring more than 10 seconds of response time, the result was not retrieved. Now, regardless of the necessary time, the content of the dimension is displayed.

dd06ece3 (2022-11-16)​

Global​

• Google Sheets :
  • With this version, QiBates allows connecting to any PBCS instance with username/password. To use it, you must select the PBCS connector from the drop-down list of connectors.

Improvements​

• Google Sheets :
  • Session expiration has been increased to invalidate a session after 8 hours. In practice, a user will therefore have a login request once a day.
  • Essbase :
    • Named ranges that are not attached to a cube are ignored, which allows creating named ranges not linked to QiBates without impacting cube management.
    • By default, the "Missing" label is set to "0" and color-coding is disabled.
    • Connection pool management has been improved to take into account session expirations.
  • Planning/PBCS :
    • The improvement of encoding management allows handling all special characters and line breaks in cells. In order for single quotes to be taken into account by Google Sheets, they must be entered twice.

New Features​

• Google Sheets :
  • Essbase :
    • It is now possible to refresh grids generated with the version of QiBates that used the SmartView API.

579fe968 (2022-10-17)​

Bug Fixes​

• Google Sheets :
  • Decimal numbers with precision adjustment are supported on numbers from the Essbase and Planning connectors.
  • Essbase :
    • It is now possible to freeze Essbase grids by checking the option from the settings view.
    • The loading icon waits for the complete grid display before disappearing.
  • Planning :
    • We only display selected members that are available in the "promptlist".
    • Refreshing the POV displays the selected perspectives instead of the old default value "Pick a POV...".
    • The management of colors on cell security has been improved.
• Microsoft Excel :
  • Essbase :
    • It is now possible to perform actions on grids generated with a cascade.
  • Planning :
    • It is now possible to launch a rule from the task list.

New Features​

• Google Sheets :
  • It is now possible to set the number of decimal places from the Essbase and Planning settings.
  • To allow access to our API, a pop-up appears upon first connection to allow clients to authenticate via OAuth protocol. This means that all requests to QiBates are now performed with the identity of the connected person.
  • It is now possible to change the alias table directly from the connections view. Actions have also been added to allow refreshing the cube or shape, directly displaying the sheet related to the connection, and highlighting a specific cube.
  • Essbase :
    • A new window has been added during Ad-hoc to choose the grid position and to delete the sheet content. A new option appears in the settings to customize the default grid position.
    • If the cursor is placed on an existing grid or if there is no active connection in a sheet but there is a correctly formatted grid, a "Refresh" button has been added to the pop-up to refresh the grid based on the connection selected when the Ad-Hoc action was triggered.
  • Planning :
    • Indentations are now enabled by default for planning forms. It is possible to disable it in the Planning connector settings.
• Microsoft Excel :
  • When an action is too long, the action continues to run in the background. A notification is displayed in the bottom right to warn the user. When the action is completed, another notification still in the bottom right informs the user that the action is finished. While the action is executing, the user can continue working on other grids. The only constraint is to keep the tab containing the spreadsheet to be updated open.
  • Web socket connections with the server now work with the STOMP communication protocol.
    • Essbase :
      • Translated: After an action (Zoom In, Zoom Out, Keep Only, Remove Only, Pivot, Refresh, and Submit), cells with formulas or comments are preserved.
      • A new window has been added during Ad-hoc to choose the position of the grid and clear the contents of the sheet. A option has been added in the settings to customize the default position of the grid.
    • Planning :
      • For each cell, if the note is equal to the value in the cell, the note is not displayed.

79aeefc (2022-09-16)​

Global​

• Web socket connections with the server now work with the STOMP communication protocol.

Bug Fixes​

• Google Sheets :
  • Essbase :
    • Comments ending with a number preceded by a space are now handled correctly.
  • Planning :
    • Cell color codes in planning grids are now handled correctly. Cells marked as read/write are now displayed as read-only.

New Features​

• Google Sheets :
  • Planning :
    • "Rules prompts" now only display members of the form's intersection in the "prompt list". If not, the member is set to empty.

2364bd5 (2022-08-04)​

Bug Fixes​

• Google Sheets :
  • Essbase :
    • Data submission now works correctly.
    • The side menu now correctly displays on the "Login" view.
    • The "cascade" action now works correctly.
  • SSAS :
    • Actions on SSAS grids now work correctly.

Improvements​

• Google Sheets :
  • Essbase :
    • To allow a smooth transition from the QiBates version to the B-Right version, changes have been made to the "refresh" action :
      • The connection of the old grid is now automatically retrieved on the first "refresh".
      • We have also added a confirmation message if the user wants to open a cube on an existing active grid.

New Features​

• Google Sheets :
  • Planning :
    • A search bar has been added to the perspective selection.

ac2b1479-2 (2022-07-07)​

Improvements​

• Microsoft Excel :
  • Planning :
    • The drop-down list does not appear in the form when the cell is in read-only mode.
  • Essbase :
    • In the member selection, it is now possible to display members of dimensions containing special characters and spaces.

ac2b1479 (2022-06-28)​

Improvements​

• Google Sheets :
  • The maximum waiting time for an action has been increased. If the action takes more than 10 seconds, a warning message informs the user that the action is still in progress.
  • Planning :
    • The drop-down list does not display in the form when the cell is in read-only mode.

New Features​

• Essbase :
  • It is now possible to place comments and/or formulas inside and outside of Essbase grids.
  • The grids can be moved within the same sheet while preserving connection information.
  • In the case of multiple grids on a sheet, it is now possible to add members below any grid. They will be taken into account during the next "refresh".
  • Microsoft Excel :
    • In forms, the "#Missing" are now added to drop-down lists. After editing the "Missing" label in the settings, the modification will be made directly in the drop-down list after a "refresh".

fbb01845 (2022-05-23)​

Bug Fixes​

• Google Sheets :
  • Special characters are now handled in Essbase cubes and Planning forms.
  • The list of applications now displays in alphabetical order.
  • Essbase :
    • The user no longer needs to select a cell within the range containing the grid to save the data. The submit can now be performed outside of the range of an Adhoc grid.
    • It is now possible to load Essbase data with a dimension that has coded fields such as "007" by adding an apostrophe in front.

New Features​

• Google Sheets :
  • We now offer first-level prediction on any grid with date-related data. The feature is accessible from the main menu.
  • The cells that are modified within the newly displayed data range are highlighted in dark yellow.
  • The new notification system has three levels of information presented to the user :
    • Information, the operation was successful, and we communicate statistics on the execution of the related action.
    • Warning, the operation was completed, but with a cautionary note to the user to ensure the result is as expected.
    • Error, an error caused the action to stop, and the system will therefore not be able to perform the requested task.
  • When an action takes too long, the action continues to run in the background. A notification is displayed in the lower right to alert the user.
  • Essbase :
    • You now have the ability to load flat files directly into Essbase without having to open and/or convert them into a spreadsheet and save. This feature is accessible from the Data Load menu.
    • A connection pool has been set up to allow multiple actions to be performed in parallel on different sheets. It is possible for a user to launch both a Refresh and calculations on both the same cube and different cubes.
    • You have the cube connection information directly in a note on the first cell.
  • Essbase 21C :
    • The Essbase 21c connector is now supported and directly accessible from the Essbase connector. Depending on the version of your data source, we automatically select the appropriate version. No user action is required.
  • Planning :
    • The selection of members in a rule execution invite is now limited to only selectable members.
    • Views are directly updated when clicking on the "POV" menu.
    • If the "Colour Coding" option is disabled, colors are no longer overwritten on existing Forms. Previously applied formatting is therefore preserved.
    • The "Keep conditional formatting" option has been added so that conditional formatting is not overwritten by "Color Coding".
  • SSAS :
    • Cells containing members and displayed data are now subject to coloring if the user has decided to activate it.

3f8bb21 (2022-05-18)​

Bug Fixes​

• Google Sheets :
  • Planning :
    • If the non-editable POV is too long, it will be displayed with the area with a scroll bar.

New Features​

• Google Sheets :
  • Planning :
    • Notes are no longer displayed if the cell value is equal to the note.
    • The refresh launched on a form with an active filter retains the color coding.

59ca88a (2021-08-13)​

Bug Fixes​

• Google Sheets :
  • Support for Cookies has been removed.
  • The ability to return to the login screen from the burger menu if the user is not yet logged in.
  • Essbase :
    • Unmerging cells correctly copies the value of the merged cell into all the new cells.
    • Selection of alias tables and use of the alias table for subsequent queries.
    • Automatic cell formatting as a hyperlink has been disabled.
    • Support for numbers for member cells.
    • Preserving all values on a sheet next to an ad-hoc grid after a navigation action.
    • Refreshing a grid that has never been connected previously based on the active connection.
  • Planning :
    • Forcing cells in the top-left corner to take on the format of cells containing members.
• Google Slides :
  • Detection of an invalid session and resuming the connection validation process to allow our solution to access the user's drive.

Improvements​

• Google Sheets :
  • Replacing the cache provided by Google with an in-memory database hosted by Quartz Insight.
  • Optimizing the space used in the user interface.
  • Opening/closing a node in the application view by clicking on the label.
  • Double-click to initiate the action
  • Displaying the active connection.
  • Planning :
    • Comprehensive review of the process for initializing/resuming an existing sheet with consideration for existing data.
    • Displaying the value representing #Missing instead of the default EPOCH date in case of missing values.
    • Support for empty webforms and the ability to refresh a sheet containing an empty webform.
    • Adding the Missing label for the choice lists of a cell to make the cell valid in case of missing values.
  • Essbase :
    • Comprehensive review of the process for initializing/resuming an existing sheet with consideration for existing data.

New Features​

• Google Sheets :
  • Refresh Menu to refresh the active sheet without prior connection, the connection is initiated during the refresh.
  • Refresh All Menu to refresh all sheets in the active workbook, without user-initiated prior connection.
  • Prevent display of the login window if the Google account doesn't have a license associated with our add-on.
  • In case of session expiration, redirect the user to the login screen and display an informative message about the reason for the redirection.
  • Keep the connection active if the right-side panel is closed.
  • Essbase :
    • Support for sheet-level or globally-attached grid parameters, with parameter inheritance management.
    • Remove rows/columns containing only #Missing.
    • Display calculations below the cube and remove the view dedicated to calculation scripts.
  • Planning :
    • Display the Full View in a note attached to cell A1.
    • Support for sheet-level or globally-attached grid parameters, with parameter inheritance management.
    • Protect write-prohibited cell ranges.
    • Display webforms and/or tasks based on the license provided to the user.
    • Support source POV elements to set the point of view of the new webform to be opened (used for links between webforms via menus).
    • Display the connection associated with the grid in the note in cell A1.
• Google Slides :
  • Edit a table with the assistant.
  • Edit a chart with the assistant.

1aeeb4e8 (2021-07-08)​

Bug Fixes​

• Google Sheets :
  • Essbase :
    • Alias table for grid creation.
    • Preserve text outside of the blank grid area.
    • Refresh a grid from scratch on a new sheet that has never been connected.

Improvements​

• Google Sheets :
  • Essbase :
    • Review of the functioning of the alias table.
    • Use of the alias table for member selection.

New Features​

• Google Sheets :
  • Essbase :
    • Ability to merge cells.
    • Ability to freeze panes.
    • Ability to delete blank rows.
    • Ability to enter values outside of the grid (with a known bug on the items in the blank area where only formulas are taken over).

03ed1f1c (2021-04-23)​

Global​

• The connection to the Essbase engine is evolving. We are now using the Essbase Java API (JAPI). This means that we are using a new access point that follows the format: https://yourdomain/aps/JAPI.
• As a result, the URL https://yourdomain/aps/SmartView is no longer necessary and can therefore be removed from the allowed URLs.
• The data flow used by the Essbase Java API is no longer a readable format as was previously available. This means that it is no longer possible to validate the content of the HTTP request through a DTD for example. This validation must be disabled.
• These changes affect the Google Sheets, Google Slides and Microsoft Excel Add-Ons.

Bug Fixes​

• Google Sheets :
  • Planning :
    • Unable to refresh the webform after changing members on the page.
    • The date display relies on the time zone settings of the spreadsheet to always display the date in the format DD/MM/YYYY.
    • Redesign of the task list reading to load it dynamically on user demand and avoid capacity overruns.
    • Webform displayed in the wrong place if there are multiple webforms with the same name in different applications.
    • Preserve all native formatting elements of the sheet when connector formatting is disabled.

Improvements​

• Google Sheets :
  • Display of menu buttons based on the connector chosen at the start of the session.
  • Display of the version in the "About" view.
  • Default formatting colors for Essbase and Planning connections are identical to what is offered on the extensions provided by the respective publishers.
  • Update to Font Awesome 5.13.
  • Queries to multidimensional data sources containing the Signature header with the Quartz Insight certificate.
  • Planning :
    • Display of perspective and page items in a note accessible in cell A1.
    • The task list is directly accessible from the application view without requiring a reload.
    • Clean up the entire sheet before displaying a webform.
    • Line break in the task tree view.
  • Essbase :
    • Display of the calculation script view from the application menu.
    • An Ad-Hoc request on a sheet already containing a grid from the same cube can be refreshed instead of reset.
• Microsoft Excel :
  • Update to Font Awesome 5.13.

New Features​

• Microsoft Excel :
  • Support for the new Essbase query engine.
• Google Sheets
  • SSAS :
    • Addition of a new connector for Microsoft multidimensional databases: SQL Server Analysis Services. To use our solution, your SSAS instance must be accessible through HTTPS via the MSMDPUMP module at https://yourdomain/OLAP/msmdpump.dll. We now have 3 supported connectors: Essbase, Planning, SSAS. Data exploration features are supported, as well as writing. For writing, you need to have write back enabled on the necessary cross-tabs.
  • Essbase :
    • New display ergonomics for applications and cubes, with a main action on single left click (Ad-Hoc) and secondary actions available in a contextual menu accessible through right click.
  • Planning :
    • Merge adjacent cells containing the same member (rows or columns).
    • Hide cells and/or columns that do not contain data.
    • Customize the displayed value for empty cells.
    • Automatically freeze panes based on the structure of the displayed webform.
    • Protect the sheet with a warning before modifying a sheet containing a planning webform.
    • Support for SmartLists in read/write mode.
• Google Slides :
  • Drag and drop table creation assistant, support for dimension filters.
  • Native support for charts. One chart type is supported: column chart. No need to use Spreadsheet documents to manage and maintain charts in Slides.

5ef3daf (2021-02-18)​

Global​

• The connection to the Essbase engine is evolving. We are now using the Java Essbase APIs (JAPI). This means we are using a new access point that follows the format: https://yourdomain/aps/JAPI.
• As a result, the https://yourdomain/aps/SmartView URL is no longer necessary and can be removed from the authorized URLs.
• The data flow used by the Java Essbase API is no longer a readable format as was previously available. This means that it is no longer possible to validate the content of the HTTP request using a DTD, for example. This validation must be disabled.
• These changes affect the Google Sheets and Google Slides Add-Ons.

Bug Fixes​

• Google Sheets :
  • Display error for "Alias Tables".
  • Display a visual for applications without cubes.

Improvements​

• Google Sheets :
  • User interface: Display the selected cube.
  • Re-wording of the alert message for new ad-hoc analysis.
  • New engine: General improvement in Essbase response times (using Essbase JAPI).

New Features​

• License Server :
  • Support for filters and preservation of filters in tables with pagination.
• Google Sheets :
  • Advanced member search.

55e780b (2020-12-01)​

Global​

• Google Sheets :
  • Essbase :
    • Member present outside of the Essbase grid blocks refresh.
  • Planning :
    • Date validation in Planning grids.

Improvements​

• Google Sheets :
  • Display of the active cube/form in a notification.

New Features​

• Google Sheets :
  • Essbase :
    • Simple grid cascading with member selection assistant.

9ddcaed (2020-05-21)​

Global​

• Google Sheets :
  • Preserve Spreadsheet formatting if syntax coloring has been disabled.
  • Essbase :
    • In case of unknown member, continue to display the grid returned by Essbase with added dimensions if necessary.
    • Unable to submit a grid if the connection has not been selected from the list of cubes.

Improvements​

• License Server :
  • Reset SQL connections in case of a loss of connection to the database.

42e640d (2020-03-27)​

Global​

• Google Sheets :
  • Essbase :
    • Handle members containing a period in the member code.

New Features​

• Google Sheets :
  • The client is now compatible with user management rather than domain management.

2e56610 (2020-01-23)​

Bug Fixes​

• Google Sheets :
  • Essbase :
    • Handling of members containing a dash in the member code in the Member Selection view.

Improvements​

• Google Sheets :
  • The "Options" view in the login screen is hidden by default.
  • The display button for the toolbox is in the menu bar.
  • Essbase :
    • Addition of insertion buttons at the top and bottom of the member selection view.

New Features​

• Google Sheets :
  • The history of servers that the user has connected to is saved locally in the browser. A drop-down list is then offered to the user to choose from among the previous servers used.

aad6427 (2019-10-29)​

Bug Fixes​

• Google Sheets :
  • Essbase :
    • Unable to apply a filter to the result of a search.

Improvements​

• Google Sheets :
  • Essbase :
    • Perform the following actions on a selection of multiple members :
      • Zoom In.
      • Zoom Out.
      • Keep only.
      • Remove only.

New Features​

• Google Sheets :
  • Essbase :
    • Additional Zoom Actions :
      • Zoom in to the finest levels.
      • Zoom in to all levels.
      • Zoom in to formulas.
      • Zoom in to siblings members.
      • Zoom in to members at the same level.
      • Zoom in to members of the same generation.
    • Additional Refresh Actions :
      • Refresh entire workbook.
      • Refresh a single grid in a multigrid tab.
      • Refresh all grids in a sheet.
    • Additional Pivot Actions :
      • Pivot the row or column dimension to the POV.

64d0cc9 (2019-10-07)​

Bug Fixes​

• Google Sheets :
  • Essbase :
    • Fixed the Keep Only and Remove Only icons that were switched. The actions were present but the icons were reversed.
    • Supports members with special characters for filtering in the Member Selection view.

Improvements​

• Google Sheets :
  • Essbase :
    • Improved Essbase formatting experience. There's now only one option to switch between two behaviors. If Essbase color coding is selected, it replaces all Spreadsheet formatting while still retaining formulas and comments. If Essbase color coding is not selected, Spreadsheet formatting is consistently applied, such as conditional formatting, font, and borders.

f997e9d (2019-09-19)​

Bug Fixes​

• Google Sheets :
  • Consideration of the change in the Quartz Insight website for logos.
  • Essbase :
    • Consideration of the alias table for handling multi-grids.
    • Ability to submit cells with 0 value.
    • Support for cells not belonging to a grid in a single-grid tab.

Improvements​

• Google Sheets :
  • Display of all errors in a toast-style window in the bottom right corner.
  • Complete overhaul of the toolbar :
    • Visual indicator of an action being processed.
    • Display only of possible actions for users.
  • Essbase :
    • Member selection and display of directly accessible applications from the menu bar.