Version 7.0.0.4688

November 24, 2014

This version of the Dodeca Framework 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 2012 (7.1.2.150), NetAdvantage 2011, Volume 1 (11.1.20111.2042), Aspose.Cells 8.2.0.0, Syncfusion Essential Studio 11.3035.0.30, and GdPicture.NET 10.2.0.30.

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 are supported and tested on Java 1.6. Both services are known to run on Java 1.7, although extensive testing has not been performed on that Java version.

This release is intended as a patch to address an issue introduced between SpreadsheetGear 2010 (6.0.3.190) and SpreadsheetGear 2012 (7.0.5.140). The issue resulted in an unhandled exception "Invalid RGB value" encountered when rendering a specific chart in a customer’s template.

In addition to the upgraded version of SpreadsheetGear, this release contains the following:

Essbase Views

  • Fixed issue with the Excel Essbase View Cascade functionality: When a cascaded member contains an invalid Excel sheet name character, building the view fails with the following error (#1340):

    Unable to build the view. Unable to do cascading.

    EssbaseSpreadsheetGear.CopyWorksheet failed. Sheet names must be between 1 and 31 characters long, may not start with a single quote (') character, and may not contain any of the following characters: [ ] * / : ? or \

  • Fixed the "Value does not fall within the expected range." exception, which is encountered when an Essbase error occurs on the first Essbase operation performed for a given view. This is typically a Retrieve operation, but could be another operation performed by way of a WBS or by the user in an adhoc view with ExcelAddInMode enabled. (#1337)
  • Fixed an issue with the Adhoc View –

    Issue: When the ExcelAddInMode is set to True, a Send operation is always performed for the used range and not the selected range.

    Resolution: The Send operation is performed on the selected range when the selected range contains at least two rows and two columns; otherwise, the Send operation is performed on the used range. (#1335)

  • For the Adhoc view’s Undo/Redo Essbase operation capability, the caption presented for each operation has been modified to include up to three selected member names, and the zoom level for a Zoom In operation.

    Note

    The Undo/Redo Essbase operation capability is only supported for an Adhoc view when the ExcelAddInMode is set to True.

    image

SQL View

  • Fixed issue with Cascade: When a cascaded item contains an invalid Excel sheet name character, building the view fails with the following error (#1340):

    Unable to build the view. Unable to do cascading.

    EssbaseSpreadsheetGear.CopyWorksheet failed. Sheet names must be between 1 and 31 characters long, may not start with a single quote (') character, and may not contain any of the following characters: [ ] * / : ? or \

Dodeca Framework Release Notes