Dodeca Version 7.6.1

The DodecaTeal_OfficeWhite_Style style library, which was made available in the 7.5.0.6430 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

Fixed Issue – When using the style library, DodecaTeal_OfficeWhite_Style, which was introduced in the 7.5.0.6430 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

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

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

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 7.5.0.6430. #2123

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

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

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

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

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:

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

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

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 7.6.0.6549 release. #2110

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 7.0.0.5388, March 23, 2016. #2089

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

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 7.5.0.6430 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 7.6.0.6549 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 7.6.0.6549 release. #2119

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

@ValueFormat([<Address>])

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 7.0.0.5388, 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 7.6.0.6549 as a result of the upgrade to SpreadsheetGear 2017. #2126