Dodeca Version 7.8.0

The Essbase Connections Editor now supports the ability to determine the versions of various server components associated with a given connection, including the version of the Essbase server, the Java API, and the Dodeca Essbase servlet. The server locale is also available.

Fixed Issue: When an Essbase connection is added or modified, an unnecessary call to the server may be performed when the connection is committed. #2426

Similar to the existing SendBlanksAsZero option, new Essbase option, SendBlanksAsMissing, supports the ability to send blank data cells as missing data. #2397

To provide more control over Essbase outline XML extraction on the server, a new setting, OutlineExtractXmlVersionRetentionCount has been added to the Essbase connection metadata. The property controls the maximum number of extracted XML versions to keep for a given Essbase connection. By default, the value is -1, which indicates there should be no maximum limit on the number of extracted XML versions to retain for the Essbase connection.

Fixed Issue: By design, when OutlineExtractEnabled is set to True for a given Essbase connection, the Dodeca metadata service checks for changes to the outline at the configured time interval. When a change is detected, the outline is extracted as XML and saved in the metadata repository as an Essbase Outline XML binary artifact. The issue, which has been addressed, is that the XML was being extracted even when no changes had been made to the outline. #2390

Fixed Issue - Under some circumstances, deleting text in an Essbase query or script by holding the backspace key can raise an unhandled exception that has the potential to crash the application. This occurs when nested functions are present, and context-sensitive completion hints for multiple functions are displayed in quick succession. #2422

Fixed Issue - When filtering displayed server scripts by type and an expanded cube contains no scripts of the specified type, the status node text is incorrectly set to Node0, Node1, etc. #2427

Log Essbase Request and Response XML to the Server

Log Essbase Performance to Server

Fixed Issue: When the Dodeca metadata service starts, if license information cannot be obtained because the database is temporarily unavailable or the configured credentials are expired or otherwise invalid, the metadata service must be restarted after the underlying issue has been corrected. Until the metadata service is restarted, all clients will receive an error similar to the following when attempting to launch: The Dodeca license could not be validated. A valid license could not be found. #2421

Fixed Issue: The Metadata Dependency Explorer does not detect a depends on dependency between a workbook script and an MDX script when the AddDataCache.EssbaseMDXScript method overload is used. #2414

Fixed Issue: When an EssbaseSelectorTreeView, SQLSelectorTreeView, EssbaseSelectorListBox, or SelectorListBox is configured to allow multiple selections, a selected item may be excluded from the selection text displayed in the selector tool (and tooltip) and from the token value, when the item’s display text is embedded in another selected item. For the treeview selectors, specifically when the embedded text is in a previously selected item, and for the listbox, when the embedded text is in a selected item that appears in the list above the item. This issue was introduced in 7.3.0.6125. #2424

Fixed Issue - When using the SQLStandardizationPolicy FullStandardization for a SQLPassthroughDataSet query, block comments that are closed on the same line and immediately following a line comment are corrupted, resulting in the block comment being left open. This issue would occur for a comment similar to the following:

select column1,
       column2,
       /* -- column3, */
       column4
from   table1

Fixed Issue: When the view selector’s ViewSelectorItemToolTipPolicy is set to Description, views without a description will display the description of the previous view with a description, which was hovered over in the view selector. #2387

Fixed Issue: The Unhide Rows and Columns tool fails when the hidden rows or columns are represented by discontiguous ranges. The error message is similar to the following: EssbaseSpreadsheetGear.SetRowsHidden failed: "1:1,11:13" is not a valid range or reference for sheet "Income Statement." #2411

Fixed Issue: In the Excel (and SQLExcel) View Template Designer, when copied cells are empty, but contain formatting, the cell formats are not pasted when a Paste Special tool option, which includes formats, is used. #2425

Fixed Issue: When opening the Formula Editor to modify a value, Excel and Workbook Script function names contained in the value are automatically capitalized, which could cause issues under some circumstances. #2412

Fixed Issue: Procedures are sorted in descending order when opening the editor. #2389

The Substitute function has been deprecated. The function will continue to be supported, but has been replaced with the new Replace function. The Substitute function has a known issue with multiple quoted arguments, which results in a "Missing arguments" error. The Replace function does allow for multiple quoted arguments. #2394

New Function: The Base64Decode function returns a decoded representation of a given Base64-encoded string. #2407

New Function: The Base64Encode function returns a Base64-encoded representation of a given string. #2407

New Function: The DataTableRangeColumnInfo function returns the name or data type of a data table range column. The data must be retrieved before calling this function. #2408

New Function: The DataTableRangeColumnInfoByIndex function Returns the name or data type of a data table range column. The data must be retrieved before calling this function. #2408

New Function : The Replace function replaces existing text with new text in a text string. Unlike the Excel Substitute function, this function does not limit the text argument values to 255 characters, and also allows for specifying whether a match is based on a case-sensitive or a case-insensitive comparison. #2394

New Function Argument: An optional parameter, UseCache, has been added to the DimensionUDAs function control whether the UDAs are returned from the session cache, if contained in the cache, or from the database. #2392