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 (8.3.34.102)*, NetAdvantage 2011, Volume 1 (11.1.20111.2042), Aspose.Cells 19.5.0.0, Syncfusion Essential Studio 13.4.0.63, and GdPicture.NET 11.0.6.
*The version of SpreadsheetGear was upgraded from 8.1.58.102 to 8.3.34.102.
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 11.1.1.3 are supported and tested on Java 1.5. The Dodeca-Essbase service for all Essbase versions 11.1.1.4 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
,
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 7.7.0.6870, the tool is automatically
disabled when a point-of-view selection changes. After building or refreshing, the
tool is enabled. #2480MemberExpansionFilters
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. #2484EssbaseConnectionID
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.
#2445An 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'.
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. #2444CulturePolicy
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." #2475AutoBuildOnViewBuild
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. #2443EssbaseRetrieve.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