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 (184.108.40.206)*, NetAdvantage 2011, Volume 1 (11.1.20111.2042), Aspose.Cells 220.127.116.11, Syncfusion Essential Studio 18.104.22.168, and GdPicture.NET 11.0.6.
*The version of SpreadsheetGear was upgraded from 22.214.171.124 to 126.96.36.199.
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 188.8.131.52 are supported and tested on Java 1.5. The Dodeca-Essbase service for all Essbase versions 184.108.40.206 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 220.127.116.1170,
Essbase Excel Views, a dependency was introduced in the Export to Excel tool on the
AllowSaveproperty, which requires the property be set to True to enable the tool. This dependency has been removed; however, with the change in 18.104.22.16870, the tool is automatically disabled when a point-of-view selection changes. After building or refreshing, the tool is enabled. #2480
EssbaseSelectorTreeViewhave 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
EssbaseConnectionIDis 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
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
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'.
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
CulturePolicyand a view’s
CulturePolicyare 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
Fixed Issue: When a SQL View has a dataset range configured with the
AutoBuildOnViewBuildproperty set to False, and the
BuildDataSetRangeworkbook 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.Rangeto 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