Dodeca Version 7.2.0

Default Admin Toolbars: A new Workbook Script Reference Guide tool has been added to the Help menu of the Default Admin Toolbars to ensure that report developers and administrators can access the provided documentation quickly and easily. #1726 [7.2.0.5782]

The default splash screen has changed.

The ability to control whether only a single instance of a view can be opened by the user from the view selector is now supported. When a view’s AllowOnlySingleInstanceFromViewSelector property is True, only a single instance is allowed. When the user attempts to open another instance of the view from the view selector, the existing view' instance is activated. #1576 [7.2.0.5782]

Fixed Issue: When an Authentication Service is assigned to an application and IntegrateDodecaRoles is true, two UserAccessValidation requests are sent to the Dodeca metadata service. #1713 [7.2.0.5782]

Fixed Issue: Previously, for a ClickOnce deployment, the username was cached at startup when provided as a query string parameter. The issue occurs when the username is no longer specified as a parameter, and the cached username is used instead of the current system user, which potentially results in the application running with the wrong or invalid user. #1710 [7.2.0.5782]

Fixed Issue: In Dodeca, numeric member names or aliases are prefixed with a single quote when retrieved into a worksheet in order to place the data into cells as text. When the members are subsequently used to send data to Essbase and a data audit log record is created, the leading single quote may not be appropriately removed from the member. #1694 [7.2.0.5782]

Enhancement: The Dodeca Workbook Script Reference Guide has been redesigned to enhance its usefulness and make finding the required information easier than ever for report developers and administrators. Previously, the Workbook Script Reference Guide was made available via the Dodeca Framework installation and via the Applied OLAP website, but gaining access to the documentation sometimes presented challenges for report developers. In addition to making the documentation easier to use, the Workbook Reference Guide is now deployed as part of the Dodeca server, and a link has been added to the Help menu provided by the Default Admin Toolbars. #1726 [7.2.0.5782]

For an adhoc view with ExcelAddInMode enabled, non-numeric text, which appears to the right of a cell (or cells) that contain a numeric value, the non-numeric text is not retained when a retrieve operation is performed. For example, "abcdefg" in I3 is not retained unless a retrieve range, which includes the cell, is selected before the retrieve is performed.

Unknown Members – For some layouts, when an unknown member is detected by Essbase, the member is flagged as unknown, but the unknown member is replaced on the sheet with a known member from an adjacent cell. #1536

Fixed Issue in which multiple occurrences of a shared member are automatically (and inappropriately) selected in the tree. The following are a couple of examples of when this issue is encountered.

Fixed Issue: An error similar to the following can be encountered when attempting to perform an Essbase update/send operation when the Essbase database is case-sensitive: Unable to perform Essbase operation. Alias [default] Does Not Exist For Database [Basic] #1740 [7.2.0.5810]

Addressed Vulnerability: This release includes server-side changes to address the potential for XML External Entity (XXE) vulnerability in server XML parsing. #1472 [7.2.0.5782]

Enhancement: This release contains modifications to both the dodeca and dodeca-essbase services to prevent arbitrary request execution and XML tampering. #1732 [7.2.0.5782]

Fixed Issue: The serialized XML that represents the selector item is displayed in the selector tool until the selector tree is opened, which forces the selector tool to refresh and display the selected item. #1707

Enhancement: A ToolTipItemDetailsColumns property was added to the SQLPassthroughDataSetHierarchy Selector List. This property corresponds to the "Details" ItemToolTipContentOptions of the SQLSelectorTreeView, and it allows any number of custom ToolTipItemDetailColumns to be shown via the Selector Control’s item tooltip. #1733 [7.2.0.5782]

Fixed Issue: When the combination of the language and region of a client system did not represent a valid, four-letter, ISO language code, the User Manager displays the following error: "Unable to execute user query. Unable to deserialize UserQuery result. Culture name 'xx-xx' is not supported. Parameter name: name." #1712 [7.2.0.5782]

Fixed Issue: ViewUsage records report incorrect usage log timestamps. Timestamps come from the client rather that the server. #1727

Fixed Issue: ViewUsage records appear to report incorrect durations when extended AfterBuild Workbook Script processing occurs. #1728

New Methods – The DeleteBreak and InsertBreak methods remove or add printing breaks to the workbook for control over print layout and PDF production. #1724 [7.2.0.5782]

New Method – The OpenBinaryArtifact method allows any file stored as a Binary Artifact to be opened using the default viewer installed on the client system. #1725 [7.2.0.5782]

New Method – The ShowLoginDialog method allows a user to provide credentials which can be validated against an existing SQL connection or against any compatible web service in conjunction with the CallWebService method.

Added Password argument to LoadWorkbook – The argument is used when the loaded workbook is password-protected. #1737

New Function – The Contains function returns whether a string contains a substring. If the optional IgnoreCase parameter is provided, the case of the substring will not be checked. [7.2.0.5782]

@Contains(<Substring>, <WithinString>, [<IgnoreCase>])

New Function – The FileExists function returns whether the specified file exists. If the optional SpecialFolder parameter is provided, the FileName argument will be appended to the resolved special folder. Valid SpecialFolder parameter values are: desktop, documents, appdata, favorites, and personal. #1680 [7.2.0.5782]

@FileExists(<FileName>, [<SpecialFolder>])

New Function – The IsProtectedSheet function returns whether the specified sheet is protected. If the optional SheetNameOrIndex parameter is not provided, the active sheet will be checked. #1723 [7.2.0.5782]

@IsProtectedSheet([<SheetNameOrIndex>])

BuildRangeFromScript Method, EssbaseMdx Overload – Added a Dataless argument, which controls whether the MDX query returns data values along with the members or returns members only. [7.2.0.5782]

CallWebService Method, RESTRequest Overload – Added FollowRedirects, RequestHeaders, ResponseCodePropertyName, and ResponseHeadersPropertyName arguments. [7.2.0.5782]

SendEmail Method, SMTP Overload – Added an IsHtmlMessage argument which controls whether the message body should be displayed as HTML by recipients. [7.2.0.5782]

Fixed Issue: BuidRangeFromScript Method, EssbaseMdx Overload] – When no rows are returned from the MDX query, a single occurrence of the CopyFromRange "row template" is inserted in the sheet. #1690

Fixed Issue: EssbaseReport Method – The Missing Label and No Access Label are not applied to the report results. This occurs both when specified as method arguments and when specified as view properties. #1720 [7.2.0.5782]

Fixed Issue: Method [EssbaseMdxQuery Method, GridData Overload] – When dimension properties are included in the MDX, the left columns are not property buffered when data is returned, which results in the overwriting of row labels with data. #1533 [7.2.0.5782]

For the Breakpoints tab, the expansion state of the Context, Method Arguments, and Procedure Methods sections is retained and restored within and across sessions. [7.2.0.5810]