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 (22.214.171.124), NetAdvantage 2011, Volume 1 (11.1.20111.2042), Aspose.Cells 126.96.36.199, Syncfusion Essential Studio 188.8.131.52, 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 184.108.40.206 are supported and tested on Java 1.5. The Dodeca-Essbase service for all Essbase versions 220.127.116.11 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 18.104.22.168 to 2017 22.214.171.124.
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 126.96.36.19930 release, is now installed as a separate metadata zip file in the metadata directory. Previously, the style library could only be imported from the metadata_starter_kit.zip or sample.zip 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 188.8.131.5230 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 hibernate.properties 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 hibernate.properties 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 184.108.40.20649 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 220.127.116.1130. #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 metadata_starter_kit.zip and sample.zip 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
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
…and pasting into a Dodeca view results in the contents of
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 18.104.22.16849 release. #2110
SQL Query Performance
To allow for performance tuning for relational queries, a FetchSize setting is now supported for a SQLPassthroughDataSet Query. #2088
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 22.214.171.12488, 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 126.96.36.19930 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 188.8.131.5249 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 184.108.40.20649 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. #2102Function 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 220.127.116.1188, 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 18.104.22.16849 as a result of the upgrade to SpreadsheetGear 2017. #2126