Dodeca Version 8.2.0

Fixed Issue: In the client application, when the user attempts to close multiple window tabs consecutively by clicking the X on each tab, especially when the tab width is the same (such as multiple instances of the same view with the same caption), the single click can be interpreted as a double-click (when clicking relatively quickly), which causes the window to float instead of being deleted. #3181

In the 8.1.x versions, the following error may occur during the client startup: Module CustomToolControllers was installed but was determined to be invalid after installation. Your application may not behave as expected.

A new application property, ViewChatPollingInterval, is the interval (in seconds) used by the View Comments Editor to check for new/updated comments when the editor is configured in Chat mode. A value of 0 disables polling for updated comments. Refer to the View Commentary and Attachments section for additional information.

When generating a self-signed certificate used to sign the ClickOnce deployments, using the SHA-1 (with RSA) option produces valid manifests that utilize the wrong hash algorithm in the manifest signature block. This results in the publisher being shown as Unknown Publisher, even if the generated certificate has been installed into the Trusted Root Certification Authorities key store. #3155

Fixed Issue: When a comment contains a Unicode control character or otherwise invalid XML character as defined by the XML 1.0 spec, an error similar to the following can occur: Unable to build the view. Unable to write or send ViewUsageUpdate request. '[<char>]', hexadecimal value <char value>, is an invalid character. #3225

Refer to the View Commentary and Attachments and Worksheet Worksheet Commentary sections for additional information about new commentary features.

In 8.2, the set command supports an optional --env flag. #3158

dshell/:>help set

NAME
	set - Set a variable

SYNOPSYS
	set [--env]  [[--name] string]  [[--value] string]

OPTIONS
	--env	Set variable from environment. Pass with no parameters to pull in all environment variables
		[Optional, default = false]

	--name  string
		The name of a variable to set, or the name of an environment variable if using the --env option
		[Optional, default = <none>]

	--value  string
		Value to set for a variable, or a default value to use if an environment variable doesn't exist
		[Optional, default = <none>]

dshell/:>

In 8.2, the `` command can be used to restore artifact descriptions to the BINARY_ARTIFACTS table’s ARTIFACT_DESCRIPTION field. In 8.0.0569, the description was not transferred to the field when importing metadata. #3193

In previous versions, changes to Essbase and SQL connections metadata that are committed by an administrator are not detected by the other client sessions when the connection has already been used. In 8.2, changes are detected and downloaded to the client as determined by the application’s CheckForMetadataUpdatesFrequencyPolicy setting, which is consistent with the handling of all other metadata types. #2736

Fixed Issue: The following error was reported by a customer when attempting to perform a Send operation using a stateful Essbase connection after the Essbase or APS server was restarted: Invalid session ID. One possibility is that the server may be restarted. Sign off and sign on again.

APS Url

REST Url

OLAP Server

Application

Cubename

Username

Password

Admin Username

Admin Password

Username for Impersonation

SSOToken

In 8.2, the automated Essbase Outline XML Extraction for use with Dodeca Outline Viewer reports, has been removed and replaced by a Windows batch and Linux shell script process. #2886, #3033

Fixed Issue: When the view’s Asynchronous property is True and workbook script is used to perform an Essbase operation that changes the size or layout of a retrieve range, the DataCellDoubleClickPolicy may not be properly respected. For example, when using the OpenViewForDrillthrough policy, the target view, specified as the DataDrillthroughViewID, may not open when the user double-clicks a data cell. This issue was introduced in version 8.0.0.569. #3183

Added support for parallel resolution of commentary ranges when the Asynchronous and ParallelExecution properties are True. #2841

Auto-Complete: In 8.0.0.569, functionality was introduced to provide a capability similar to Excel auto-complete. In 8.2, auto-complete has been enhanced to support the ability to optionally display a drop-down button in the active cell when edit mode is entered. By default, the ShowDropDownButton property is False. Use of the drop-down button more closely mimics the Excel behavior. #2801

Fixed Issue: When a metadata property that represents a color is set to Transparent, the color reverts to White. This includes the following properties:

Fixed Issue: Under certain circumstances, such as when the repository contains a large number of binary artifacts, the following error occurs when running a Depended On By search in the Metadata Dependency Explorer: Servlet engine ran out of available memory. #3210

Fixed Issue: With the SQLPassthroughDataSets Editor and Essbase Scripts Editor, the Commit button becomes enabled after opening the SQL Editor or Query Editor and clicking OK without making a change. This issue was introduced in version 8.0.0.569. #3212

Fixed Issue: In 8.0.0.569, the sorting of items in Metadata Editors was changed to sort based on natural order, such that View1, View2, and View10 would display as View1, View2, and View10 instead of View1, View10, View2. This caused a performance degradation when a Metadata Editor is opened and there is a large number of metadata instances, so the change has been reverted. #2558

For the selector tool, which appears in the toolbar for a selector tree and listbox, an image has been added to the button that, when clicked, opens the tree or listbox control. The image provides an end user with a visual cue. In addition, the text to the left of the button, which displays the null selection text or the current selection, also opens the control when clicked. #3227

Fixed Issue: When a SQL or Essbase Excel view, with DataSetRanges defined, contains an array-entered formula, such as INDEX, in a data table sheet range, the following error occurs when the view is built and no rows are retrieved: Operation is not valid for a partial array formula or data table. #3156

Fixed Issue: For a Select statement, which has an AS clause that refers to an Alias beginning with a single number, the number is removed from column name in the results. When the alias begins with a number followed by '0', an error similar to the following occurs: Invalid 'name' attribute value '019YTD': The '0' character, hexadecimal value 0x03, at position 0 within the name, cannot be included in a name. This issue was introduced in 8.0.0.569. #2756

Fixed Issue: When an INSERT or UPDATE statement contains multiple occurrences of the same argument, which is denoted by the @ character, the following error occurs with Oracle as the database when the user attempts to save changes: Unable to save changes to <dataset range ID>. Invalid values were detected by the database when saving changes. All valid changes were successfully used. Correct the errors and retry saving any unsaved changes.

The Enabled property must be set to True for view comments to be available.

The KeyItems defines the key items that are used to associate or link the comments to the view. Each key item is represented by a unique key and the associated value, and is referred to as a key/value pair. One key item is required.

When the AutoAddViewIdToKeyItems property is True, which is the default value, a view ID is automatically added as a key item.

When the AutoAddSelectorValuesToKeyItems property is True, which is the default value, key items for the selectors are automatically added. Selectors that allow multiple selections are not included.

The EditMode controls whether the Chat interface or Grid interface is presented.

If specified, the ContextString is stored with each comment. It can be used to capture context-specific information that may be important to understanding the comment.

AllowAdd, AllowDelete, and AllowUpdate control which operations are allowed. The value can be specified as a formula that evaluates to True or False. When AllowDelete or AllowUpdate evaluates to True, the context menu contains the Delete or Edit tool, respectively.

MaxCommentCharacters controls the maximum number of characters that a given comment can contain. A value of -1, which is the default, indicates that the number of characters is not limited.

When EditMode is Grid, SortPolicy controls how comments are sorted in the Comments Editor. DateAscending sorts by date, oldest to most recent. DateDescending sorts by date, most recent to oldest. None applies no sorting.

When the EditMode is Grid, ThreadPolicy controls the type of threading allowed for view comments.

Caption, CaptionToolTip, TabCaption, and TabCaptionToolTip control the captions and tooltip text presented in the user-interface. <<<

DisplayMode controls whether the View Comments Editor is displayed in a docked pane or a modal dialog.

DockedControlLocation - Controls the initial docked location of the View Comments Editor.

The remaining properties are only applicable when EditMode is Grid, and control the components presented in the View Comments Editor: ShowLinks, AllowLinks, ShowContext, AllowContext, and which optional columns are included for the list of comments: ShowSubject, ShowCreatedBy, ShowDateCreated, ShowModifiedBy, ShowModifiedDate.

The Enabled property must be set to True to allow files to be attached to the view. To allow for end-users to attach a file to a view, the EditMode must be set to Grid, since the Chat interface does not support attachments.

AllowDelete controls whether the user is allowed to delete an existing view attachment. The value can be specified as a formula that evaluates to True or False.

AllowedFileTypes, MaximumFileSize, and MaximumAttachments represent parameters that control the file type and size, and number of attachments.

Fixed Issue: When a view is added to a hierarchy, the views may be listed in the Select View(s) to Insert dialog in descending alphabetical order. *3211

In previous versions, the context menu displayed by the ViewSelectorTree and the ViewSelectorExplorerBar are different and neither reflects the application styling. #2528

In 8.2, a new view selector type, ViewSelectorExplorerBarTreeHybrid, combines ExplorerBar groups with tree hierarchies. #2490

When the application’s ViewSelectorProperties.AllowEditViewMetadata property is True, additional options are available in the context menu for navigating to a view’s related metadata, including the following: Edit Essbase Connection, Edit Selector, Edit Selector List, and MDX Script from AutoCompleteRanges. #3190

Fixed Issue: The Workbook Analyzer processing fails with the following error when an analyzed Excel file is currently open in Excel: Analysis failed with exception: WorkbookParser is null. #3102

In the Workbook Script Editor, a new context menu option, Go to procedure, supports the ability to navigate from a procedure argument name to the referenced procedure. When defined in the current workbook script, the procedure is activated and scrolled into view. When the procedure is defined in another workbook script, the workbook script is selected, and the procedure is selected and scrolled into view. #2384

In 8.2, the Workbook Script Editor supports the ability to easily return to any of the 25 most recently activated cells in the editor. The Return to the previously active cell and Return to the next cell in the previously active cell list tools allow for navigating backwards and forwards cell-by-cell, or for selecting a specific cell from a dropdown list of the cells. #2384

Fixed Issue: In the Formula Editor, when the dropdown list of available functions is displayed, the tooltip is not updated for the highlighted item when the up and down arrow keys are used to scroll through the items in the list. #2913

When an event link is added and the user accepts the default name for the procedure, the procedure is automatically created, a new method row is added, and the method selection list is displayed. In previous versions, when an event link is added and the user changes the default procedure name, the procedure is not automatically created. In 8.2, the procedure is automatically created for a non-default, custom procedure name. #3198

The ErrorHandlingMode, OpenDebugger, has been removed as an option from the dropdown list in the Workbook Script Editor. The option was never supported, and has always been treated the same as the ThrowException option. #1092

New Function: The DataTableRangeHasChanges function returns whether a specific range within a DataTableRange’s sheet range has any unsaved changes. Any named range or address within the DataTableRange’s sheet range may be used. If an address is not specified, the current cell address is used. #2989

New Argument for LookupValue Function - In previous versions, the LookupValue function performs a case-sensitive comparison when the MatchType is Exact, but performs a case-insensitive comparison when the MatchType is Contains, StartsWith, or EndsWith. To allow for the ability to perform a case-insensitive comparison for an Exact match, an optional IgnoreCase argument has been added, which defaults to False. The argument only applies when the MatchType is Exact. When set to True, the case is ignored when looking up the Value. #3174

New Argument for ExecuteProcedure Method - The Break argument supports the ability to conditionally exit the procedure from which ExecuteProcedure is called. This avoids the need to call the ExitProcedure method after ExecuteProcedure when exiting the procedure is appropriate based on a given condition. The Break argument is only evaluated after the procedure associated with ExecuteProcedure is executed. #3087

The PromptForInput method has been revised to support the use of tabs and the return key, which allows for multiple lines to be entered, in the input field. #2958

New ToolClicked and ToolValueChanged Event Links and ExecuteProcedure.ToolAction Method Overload: #2741

Fixed Issue: When a view’s Asynchronous property is True and it utilizes one or more workbook script MethodCondition or CellCondition method arguments that evaluate the state of the view’s workbook, various errors can occur. For example, when using @SheetProp(Visible,"@SheetName()") as the MethodCondition during an asynchronous event, the following error occurs: No sheet with the name or index "<sheet name>" could be found in the workbook. #3188