Dodeca Version 7.8.3

May 14, 2020 - Build 7209

This version of the Dodeca uses the .NET Framework, version 2.0, Service Pack 1 and higher on the desktop. The components used in this version of Dodeca are SpreadsheetGear 2017 (*, NetAdvantage 2011, Volume 1 (11.1.20111.2042), Aspose.Cells, Syncfusion Essential Studio, and GdPicture.NET 11.0.6.

*The version of SpreadsheetGear was upgraded from to

This version of Dodeca has two server-side services that run inside a Java Application Server. The Dodeca service is supported and tested on Java 1.6. The Dodeca-Essbase service for all Essbase versions prior to, and including, Essbase are supported and tested on Java 1.5. The Dodeca-Essbase service for all Essbase versions and higher is supported and tested on Java 1.6. Both services are known to run on Java 1.7, 1.8, 1.9, and 1.10.

This release contains the following changes:

Essbase Excel Views

  • Fixed Issue: In version, Essbase Excel Views, a dependency was introduced in the Export to Excel tool on the AllowSave property, which requires the property be set to True to enable the tool. This dependency has been removed; however, with the change in, the tool is automatically disabled when a point-of-view selection changes. After building or refreshing, the tool is enabled. #2480

Essbase Selectors

  • Enhancement: The MemberExpansionFilters of the EssbaseSelectorTreeView have been extended to support members being hidden or shown on the basis of the number of their ancestors that are represented in the tree. This can be useful for displaying a list of arbitrary members as root nodes in the tree while limiting the number of expandable descendant generations. #2484

Essbase View Template Designer

  • Fixed Issue: When the view’s EssbaseConnectionID is tokenized, clicking almost any tool in the designer results in an error similar to the following: Unable to refresh tool controller "EssbaseAdhocOperationRedoMenu". The Essbase connection "[T.Cube]" does not exist. #2445

Excel Auto-Filtering

  • An inconsistency between Excel and Dodeca, which is related to auto-filtering, has been addressed. It is exhibited when a single cell (or adjacent cells in a single row) is copied and pasted into a selected range, which is within a filtered range, and the selected range intersects rows that are hidden as a result of an active filter. Under these conditions, Excel does not paste values into the hidden cells. In Dodeca, the values are pasted into the hidden cells.

    While this inconsistency has been addressed, it should be noted that in both Excel and Dodeca, when cells in multiple rows are copied and then pasted over hidden rows in a filtered range, values are pasted into the hidden cells. #2453

HFM Connection

  • Fixed Issue: When an HFM connection is assigned to an adhoc view, an error similar to the following is encountered when attempting to open the view: #2456

    Unable to initialize tool controller "EssbaseConnect".

    Unable to get the metadata for Essbase connection ID "HFM". Unable to retrieve the metadata for Essbase connection ID "HFM". Unable to retrieve the requested metadata from the HFMConnectionQueryDetails service for metadata artifact "SAMPLE_DEV.ESSBASE_CONNECTION.HFM.1". Unable to process HFMConnectionQueryDetails request. No implementation mapping found for action 'HFMConnectionQueryDetails'.

Spreadsheet Calculations

  • Fixed Issue: The CELL("width", …​)` worksheet function does not recalculate when column widths or column hidden state is changed. For example, when the column is within a group, and the user collapses the group. #2444

View (and Essbase View) Template Designer

  • Fixed Issue: When the application’s CulturePolicy and a view’s CulturePolicy are set to UseWindowsCulture, and the regional settings for window’s culture uses a non-comma List Separator, the Unhide Rows and Columns tool fails when the hidden rows or columns are represented by discontiguous ranges. The error message is similar to the following: EssbaseSpreadsheetGear.SetRowsHidden failed: "1:1,11:13" is not a valid range or reference for sheet "Income Statement." #2475

Workbook Script Editor

  • Fixed Issue: The argument value editor dialog does not retain the font size after being changed, following the second subsequent edit. #2467

  • Fixed Issue: When the Properties section contains more properties than can fit vertically in the Workbook Script Editor window , the following error occurs when the Event Links section is toggled from hidden to visible: The Event Links command failed with the following error: SplitterDistance must be between Panel1MinSize and Width - Panel2MinSize. #2470

Workbook Scripting

  • Fixed Issue: When a SQL View has a dataset range configured with the AutoBuildOnViewBuild property set to False, and the BuildDataSetRange workbook script method is subsequently called, the dataset range is not retrieved. If the Workbook Script Debugger is open when the method is called, an error similar to the following is displayed: Error building the SQLPassthroughDataSetRange 'MyDataSetRange'. SQLExcelView.BuildAsync does not support multiple concurrent invocations. #2443

  • Fixed Issue: When a workbook script deletes rows from a named retrieve range after building the view, and then calls EssbaseRetrieve.Range to synchronize the representation of the data retained in memory to reflect the deletions, any workbook script Essbase functions, which use the internal representation, will subsequently return results based on the data retrieved during the build. #2457