Dodeca Version 7.2.1

March 30, 2017 - Build 5854

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 (, NetAdvantage 2011, Volume 1 (11.1.20111.2042), Aspose.Cells, Syncfusion Essential Studio 11.3035.0.30, and GdPicture.NET 11.0.6.

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 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 contains the following:


  • Application Setup Utility: On the Update Dodeca License tab, the following error is displayed when no license exists: No message found for exception passed via class: java.lang.NullPointerException #1746

  • Essbase Cascading: For the Essbase Excel view type, the tab color of the cascade sheets is not the same as the tab color of the associated cascade template sheet. #1744

  • Request Validation: When request validation is enabled for the dodeca-essbase server, MDX queries containing newline characters fail to pass validation. When request validation is enabled for the dodeca server, requests containing diffgrams fail to pass validation. These issues are only encountered when the dodeca-request-validator is enabled for the servlets, which was part of a security enhancement included with #1745, #1758

  • SQLPassthroughDataSetHierarchy Selector List: The SpecifiedString DefaultSelectionPolicy failed to select the item or items corresponding to the specified string. #1757

  • WebBrowser View: When the WebBrowserURL tool is not used with a WebBrowser View, the WebBrowserGoBack and WebBrowserGoForward tools do not update correctly when navigating. #1743

SQL Selector Tree

Workbook Scripting

  • New Method – The DeleteFile method allows a file to be deleted from the client system. #1747

  • New Event Link – The BeforeCascadeSheetBuild event allows a workbook script to add, change, or delete a given cascade sheet-specific token (using the AddToken method, General overload) before the sheet is added and before the sheet-specific tokens are used for token replacement on the sheet, within SQLPassthroughDataSet queries, or any other constructs where token replacement is performed. The SheetName event property, @EPVal(SheetName), returns the name of the cascade sheet to be added if the event is not cancelled. Canceling the event with the CancelEvent method prevents the insertion of the cascade sheet into the workbook. #1753

  • New Function – The CanConnect function determines whether the specified Essbase connection ID can be connected to Essbase using the connection’s current username and password as the test credentials or using the specified username and password as the test credentials. #1754

    Function Usage:
    @CanConnect(<ConnectionID>, [<Username>], [<Password>])

    For example, if the connection to test is Demo.Basic and the view’s EssbaseConnectionID is Sample.Basic, the following can be used to determine whether the view connection’s credentials can be used to connect to Demo.Basic. This example assumes that the view’s connection has associated credentials when CanConnect is called.

    @CanConnect(Demo.Basic, @EssConnPVal(Sample.Basic, EssDomain.Username), @EssConnPVal(Sample.Basic, EssDomain.Password))
  • New Function – The IsConnected function determines whether the specified Essbase connection is connected. #1755

    Function Usage:
  • Fixed Issue – [EssbaseMDXQuery Method, GridData Overload]: The following exception can occur: Unable to execute the Essbase MDX query. Index was outside the bounds of the array. This issue was introduced with version #1748

  • Fixed Issue: – [SetSelector Method, General Overload]: When the Value argument is used to set the selection to a shared member, the selection is not updated. #1759