Dodeca Version 7.6.1

December 12, 2018 - Build 6638

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.

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.

*Upgraded from SpreadsheetGear 2017 to 2017

The release notes for this version contain the following sections:

Dodeca Application Styling

  • The DodecaTeal_OfficeWhite_Style style library, which was made available in the release, is now installed as a separate metadata zip file in the metadata directory. Previously, the style library could only be imported from the or file. #1995

A slight revision has also been made to the style per the background color of selected rows in a grid control. The change requires importing the installed 7.6.1 version of the style library binary artifact from the zip file.

 Refer to Dodeca Style Library for more information about how to use the new style in your applications.

  • Fixed Issue – When using the style library, DodecaTeal_OfficeWhite_Style, which was introduced in the release, the Configure Selectors and New Selector List dialogs exhibit display anomalies due to the sizing of the Segoi UI font used for controls (as defined by the style.) #1987, #1995

Dodeca Metadata Service

  • Fixed Issue – When the application server or dodeca metadata servlet is started, if the database is unavailable or the file is misconfigured and a metadata repository cannot be resolved, the initialization of the service hangs indefinitely and has the potential to block server startup. In this release, the service will print a stack trace and abort initialization if a connection to the relational repository cannot be established within a minute of startup. This timeout is configurable via the hibernate.c3p0.checkoutTimeout property in the file. #2114

Essbase Adhoc View

  • Fixed Issue – For an Essbase adhoc view, the Save as Excel and Open in Excel tools save/open the view as an .xls file instead of an .xlsx file. This can result in an error when the number or rows and/or columns exceed the .xls limitations. #2120

Essbase Excel View Cascading with MDX

In the release, the ability to specify an MDX query as a cascade source was introduced. The initial implementation has been revised, and the following example provides a simple overview of the functionality. #2060

When an MDX query is used as a cascade source, each row retrieved by the query represents the members for which a cascade sheet is added. The example view is designed to cascade on the unique combinations of the children of the selected Market and Product that contain data.


The associated MDX script uses the selector tokens to query based on the selected point of view, which consists of the Scenario, Market, and Product.


The view’s cascade source configuration specifies the MDX script ID along with the tokens used for token replacement in the view’s template. Each token represents a value returned by the query. The tokens must be listed in the order returned by the script.


Essbase Member Select

  • Fixed Issue – When selecting a single page member, the Member Select dialog displays the Rules control on top of the Members control. The Rules control should not be displayed. This issue was introduced in #2123

Essbase Script Editor

  • Fixed Issue – Under some circumstances, when editing metadata object properties representing Essbase scripts, such as the ReportSpec and MdxQuery properties of Selector Lists, the Essbase Script Editor could raise an unhandled exception resulting in an application crash after pressing the OK button to accept the changes. #2127

Essbase Text Measures

  • Fixed Issue – Any Essbase text measure value, which begins with a number, such as 1-High, does not update the Essbase data upon a submit. #2100

Metadata Dependency Explorer

  • Fixed Issue with the following view depends on relationships not appearing in the dependency results: 1) The SQLPassthroughDataSet used by a view’s SQL selector list and 2) the SQL selector list used by a view’s SQL selector. #2036, #2037

Sample and Starter Kit Metadata

  • The Essbase Admin Console toolbars configuration packaged with the installed and files is now identical to the default admin toolbars configuration, which is used when an application’s UseDefaultAdminToolbarsConfiguration setting is True. #2019

Security – SSL/TLS Support

  • When connections to the metadata and/or Dodeca Essbase services require TLS 1.1 or 1.2, either due to the configuration of the application server or client machine security requirements, an exception similar to one of the following would occur:

    The servlet connection validation failed: The underlying connection was closed: An unexpected error occurred on a send.

    The servlet connection validation failed: The request was aborted: Could not create SSL/TLS secure channel.

    TLS 1.1 and 1.2 are not generally supported by applications targeting .NET Framework versions lower than .NET 4.5. Due to security vulnerabilities present in older versions of the TLS protocols used for SSL communication, explicit support for these protocols has been added to the product, provided that client machines have the .NET Framework version 4.5 or higher installed. #2105

SpreadsheetGear Control

The SpreadsheetGear control is the spreadsheet user-interface component used by the Excel-based views.

  • Fixed Issue – When a selection in Excel contains discontiguous cells, copying the selection from Excel and pasting into a Dodeca view results in the content of non-selected cells to be included. #2125

    For example, copying C2,E2:F2 from Excel…


    …and pasting into a Dodeca view results in the contents of C2:F2 being pasted.


    Similar behavior is exhibited when using the Go To dialog and pasting a range with discontiguous cells.

SQLPassthroughDataSet – Identify Table Columns

  • Fixed Issue – When identifying and importing table columns, all columns identified are added to the query after accepting the preview, regardless of the selections made in the preview form. In this version, only the table columns selected in the columns and primary key columns dropdowns are imported and used in any default statements generated. #2118

SQLPassthroughDataSet – Test Form

  • Fixed Issue – When testing a SQLPassthroughDataSet with invalid properties, an error is displayed after the “Test Data Set” button is pressed, and the Test form is not displayed. After correcting the invalid properties, whenever a query fails in a subsequent test, duplicate failure message boxes can be shown. #2109

  • Enhancement – In order to facilitate migrating selected column names from the test form to the template designer, the ability to copy the selected column names to the clipboard has been added. After testing a data set, simply right click any of the column headers in the test form to display the “Copy Column Names for Worksheet Paste” tool. The selected column names will be copied in Excel-compatible paste format for easy migration. This enhancement was added but not documented in the release. #2110

SQL Query Performance

  • To allow for performance tuning for relational queries, a FetchSize setting is now supported for a SQLPassthroughDataSet Query. #2088


View Sharing

  • Fixed Issue – When using the EssbaseUserRolesFromGroupNames and LDAPUserRolesFromGroupNames authentication services and the UsersToShareViewsWith AllUsers policy and/or RolesToShareViewsWith AllRoles policy, the lists of users and/or roles are not queried when pressing the “Share With…” button. This issue was introduced in version, March 23, 2016. #2089

View Template Designer

  • Fixed Issue – The following error is encountered when attempting to copy a sheet: A workbook must contain at least one visible worksheet. #1998

Workbook Script Editor

  • The “Procedures source list” dropdown on the context menu now always includes the procedures from the currently active script along with any procedures from the selected script. #2052

  • Fixed Issue with SetColor Method: When the ColorSelect property value is cleared in the editor by selecting the existing value and clicking the Delete or Backspace key, Color [Empty] appears as the value instead of no value. This behavior was introduced in the release. #2099

  • Fixed Issue – The dropdown list for method arguments that represent a metadata ID, such as EssbaseConnectionID, ScriptID, etc. do not display any values, with the exception of the dropdown list for an MDXScriptID argument. This issue was introduced in the release. #2097

  • Fixed Issue – Large workbook scripts take much longer to load than in previous releases. The resolution not only addressed the regression, but also resulted in an improvement in the load times experienced in previous releases. This issue was introduced in the release. #2119

Workbook Script Functions and Methods

  • New Function - The ValueFormat function returns the number format of a cell. If a range is not specified via the Address parameter, the current cell is used. #2102

    Function Usage:
  • Fixed Issue with SendEmail Method: The Security argument is not honored and always defaults to none. This could cause requests to be rejected when SSL/TLS or STARTTLS security is required by the mail server. This issue was introduced in version, March 23, 2016. #2079

  • Fixed Issue – Calling the CloseView from the procedure assigned as the SetControl.OnClickProcedure argument value throws an unhandled exception at runtime when the control is clicked. This issue was introduced in version as a result of the upgrade to SpreadsheetGear 2017. #2126