Dodeca Version 8.8.1

Fixed Issue: When launching an application configured to show a splash screen (SplashEnabled=True), the main window could open behind other windows instead of coming to the foreground. #4294

Fixed Issue: Table of contents links in a Composite View, as well as the return-to-table-of-contents link, could construct an invalid worksheet range reference because the sheet name portion of the hyperlink was not properly delimited and escaped, causing the link to fail to navigate to the correct worksheet. #4505

Enhancement: The jdbc-test command now supports Oracle’s wallet-based connection syntax, prompting for an Oracle Wallet Directory (TNS_ADMIN) and TNS alias/service name and constructing the correct JDBC URL automatically, instead of requiring the wallet syntax to be pasted in manually. #4353

Fixed Issue: The Update Outline XML and Create Outline File commands in the Essbase Connection Editor could fail for EPM connections with an error similar to the following: The specified path, file name, or both are too long. The fully qualified file name must be less than 260 characters, and the directory name must be less than 248 characters. #4461

Enhancement: A new command-line utility has been added for encrypting and decrypting username, password, adminUsername, and adminPassword values for JNDI resources that use the Essbase Connector. When a JNDI resource’s encrypted attribute is set to true, all four of these properties must be encrypted; leaving any of them in plain text can cause the connection to fail with an error similar to the following: Unable to build the view. Unable to retrieve the view data. …​ The following required connection information is not properly specified: Username. #3964

Enhancement: The AutoAddRetrieveSubRanges feature of Essbase views is now supported when using RESTful Essbase connections. #4381

Fixed Issue: The Dynamic Time Series "Latest Month" option is not supported by the Oracle Essbase REST API, so it is now disabled in the Essbase Options pane when the active connection is RESTful, instead of appearing available but silently failing to apply during retrieval. #4463

Fixed Issue: For RESTful Essbase connections, the Alias Table option could, in some cases, cause a Retrieve operation to fail with an error similar to the following: Unable to perform Essbase Retrieve operation. Object reference not set to an instance of an object. #3620

Fixed Issue: When testing a script with a connection that utilizes OAuth, the connection attempt failed with an error similar to the following: Unable to connect. Cannot invoke "com.appliedolap.dodeca.retroess.soap.EncodedString.getValue()" because the return value of "com.appliedolap.dodeca.retroess.soap.EssConnection.getUsername()" is null. #4255

Fixed Issue: Token replacement in MDX scripts and queries was case-sensitive, causing a token not to be replaced if the casing in the script did not exactly match the token name. #4424

Enhancement: The performance of serializing SQLPTDS query results to XML has been substantially improved (as much as 4-8x faster in internal benchmarks) by precomputing XML element tags and avoiding unnecessary escaping overhead when writing response elements. #4346

Fixed Issue: When ConcurrentQueryExecutionEnabled was used for a SQLPTDS operation, the per-query connection pool could be left open after the query completed, eventually exhausting the database’s session/connection limit. Connection pool management was hardened, and a scheduled job now periodically evicts idle connection pools. #3674

Fixed Issue: SQLPTDS queries against Oracle DATE columns dropped the time-of-day component, both in spreadsheet results and in the raw XML response, because the column’s JDBC type was coerced from TIMESTAMP to DATE before serialization. The Oracle JDBC driver always reports a DATE column as TIMESTAMP, and that type is now preserved as-is, so time-of-day is no longer lost; use TRUNC() in the query if a date-only value is desired. #3958

Enhancement: The last login date is now returned to the client as part of the access validation process that occurs during startup. #2716

Enhancement: When a View Selector is configured with an optional graphic, the search/filter box now appears immediately below the graphic instead of above it, so the graphic, search box, and view hierarchy tree flow together naturally. #4474

Fixed Issue: When the OpenView method is called with the ShowViewAsActiveWindow argument set to False and the source view is asynchronous, the opened view can remain active instead of the source view retaining focus. #3914

Fixed Issue: When the SetEntry method is called with the CellByCell argument set to True to write multiple comments to a comment range, only the first comment is saved if the source view is asynchronous. #3453

Fixed Issue: When the SetProgressText or SetStatus method is called in an asynchronous view, the progress or status text set by the procedure can be overwritten after the event completes. #3381, #3539

Fixed Issue: When the OpenView method is called with the Close argument set to True from a cell double-click event, the AfterBuild event of the opened view is not fired. #3651

Fixed Issue: The Dataless argument of the BuildRangeFromScript method’s EssbaseMdxQuery overload defaulted to True when left blank, rather than False as documented. #3739

Fixed Issue: The @TVal function did not resolve the value of an Application or View token when evaluated from a WorkbookScript procedure attached to the AfterConstruct event, because application and view tokens were not refreshed until after the AfterConstruct event had already been raised. #4399