Dodeca Version 7.7.0

Fixed Issue - When used on a computer with the .NET Framework version 4.0 or higher installed, the accelerator utility registered the Dodeca assemblies into the .NET 2.0 assembly and native image caches. Since the 7.6.1.6638 release, this caused Dodeca to run without acceleration when a .NET Framework version 4.0 or higher was installed. This did not produce further issues, but acceleration did not result in the expected performance benefits. #2147

Enhancement - Support has been added for optionally allowing the current user to reauthenticate and continue the session after an inactivity or scheduled timeout occurs. When the application’s AllowReauthenticateAndContinue property is set to True and an authentication service that requires credentials is configured, the user will be prompted with an opportunity to reauthenticate and continue the session. When this property is set to True, the MessageTextForClosingSession property should be updated to inform the user that she or he must reauthenticate to continue and that cancelling will terminate the application. #2116

Enhancement - When a required startup parameter is missing, (i.e., Tenant or Application for a ClickOnce deployment), optionally show a launch dialog rather than displaying an error. This is particularly useful when a new Dodeca user accesses a deployment URL in an unsupported browser (or a supported browser without a ClickOnce extension) and the startup parameters are lost.

<appSettings>
  [...]
  <!-- Indicates whether to prompt the user when the application is missing required
  startup parameters. -->
  <add key="PromptWhenMissingParameters" value="false"/>
</appSettings>

Fixed Issue - When authenticating against the EssbaseSimpleAuthenticationService, the AuthenticatedUsername is not assigned to the current user, and it does not get written to the USERS table. #2222

Enhancement - When authenticating against Active Directory, an LDAPReturnGroupCommonNames property has been added. This property controls whether to return the group common names as opposed to the relative distinguished names that Dodeca has returned in previous releases. This is useful in general, but it is particularly useful when switching between Essbase authentication via Shared Services and the upstream Active Directory server directly, since the same roles will be obtained by Dodeca from both authentication services. Additionally, an LDAPReturnGroupFilter property has been added to support only returning roles under a given directory in the tree. #2207

Fixed Issue - When generating a ClickOnce manifest directly for an IPv6 address rather than a hostname or FQDN, the ClickOnce deployment provider is represented incorrectly. This issue does not affect deployments accessed over IPv6 when a hostname or FQDN was specified in the ClickOnce Prep Utility. #2221

Enhancement - When generating a Dodeca servlet in an environment without Internet access, display only a single prompt to indicate that the timestampUrl could not be accessed and that the deployment’s signature could not be timestamped. When a certificate is generated dynamically, this information is indicated in the output log, but a prompt is not displayed. #2162

Fixed Issue – When a date measure value is retrieved from Essbase into a worksheet, then modified and sent to Essbase, the updated value can subsequently be retrieved from Essbase. However, if a date measure value retrieved from Essbase is not modified, but is included in a send operation along with Essbase values, which have been modified, the value of the date measure is changed to January 1, 1970. #2253

Fixed Issue – Nulls are inserted into the DATA_AUDIT_LOG_DATAPOINTS table when enabling the view’s UseMemberNamesAndAliasesForRowDimensions property and both the member name and alias are included in the send range. #2144

Fixed Issue – When an Essbase Excel view is exported to Excel and any of the view’s selector token values exceeds 255 characters, an “Invalid defined name” error occurs when the view is imported from Excel. #2195

Fixed Issue - When the user is allowed to set the Alias Table in the Essbase Options dialog, the alias table presented as the default for a given connection is not the most recent alias table selected for the connection. #2285

Fixed Issue – When the Essbase member hierarchy represented by the selector tree is an alternate hierarchy of shared members and the associated selector list’s SelectorListProperties.DefaultSelectionPolicy is LastUsedItem, the default selection is not restored. This is an issue when the selector is configured for single and for multiple selections. #2208

The Dodeca version has been added to the information displayed when the dodeca-essbase servlet URL is typed into a web browser window. This can be done to verify the service is running and to view the configuration and logging configuration settings. #2213

Fixed Issue - When converting an Excel view to PDF, if the view contains a chart with an overlaid Series, the Series plot points can be rendered misaligned. This issue has been addressed by updating the Aspose.Cells library to version 19.5.0.0. #2283

Enhancement - In this release, printing from a workbook view now queues in the background and does not lock the user interface while the job is spooling. In prior releases, the user interface could become locked for a significant period of time under certain networking and driver configurations. Additionally, printing is now a cancelable background operation that can be controlled via the status bar’s Cancel button. #2165

Enhancement - Print tools are now configurable with respect to showing the Print Settings dialog that allows the user to choose a printer and configure the printer settings. In previous releases, the location of the tool dictated whether a print dialog was shown. The newly added PrintBehavior property is optional; valid PrintBehavior options are listed below. #2169

Fixed Issue for SelectorListBox, SQLSelectorTreeView, EssbaseSelectorListBox, and EssbaseSelectorTreeView - The view’s SelectorControlDisplayMode property controls whether the view’s selectors are displayed as a modal dialog, docked control, or locked docked control. When set to "locked docked control", the user is prevented from moving the control to a different location or floating the control. The issue that has been addressed is that when the title bar of the dockable control pane is double-clicked, the control pane becomes a floating control. #2203

Fixed Issue - When the a view’s SelectorDockedControlGroupStyle is set to SlidingHeaders, a previously opened selector control can re-open automatically after being closed by the user. #2293

Fixed Issue - When Dodeca runs as a 64-bit process, as it does when using a .NET 4.6.2 release, an error similar to the following error could occur when attempting to send e-mail via the Send To Mail Recipient (As Excel Attachment) or Send To Mail Recipient (As PDF Attachment) tools: Unable to send mail. Arithmetic operation resulted in an overflow. #2276

Enhancement – Added support for prompting end-users to provide SQL credentials when the Username and Password are not configured on a SQL Connection object and a JNDI DataSource is not defined. This capability is intended to behave similarly to the Essbase Login dialog, which allows an end-user to provide credentials which are cached for the duration of the session and subsequently reused. The caption of the displayed SQL Login dialog is controlled via the tokenizable LoginDialogCaption property. #2124

Fixed Issue - When removing a copied column (or any copied item in any of the various list forms throughout the product) with the Remove button, the original column could be removed instead of the copy. #2155

Enhancement – Added an Insert button to support inserting a new column at the currently selected index, rather than at the end of the list. This is useful when dealing with a large number of columns. #1736

Fixed Issue - When using the SQLPassthroughDataSet Identify Table Columns functionality against a Microsoft SQL Server database, tables with non-dbo schemas were not returned correctly, and generated default statements did not use the appropriate schema for the selected table. #2112

Enhancement - Added support for identifying tables and columns of PostgreSQL databases. PostgreSQL can also now be specified as a SQL Connection Database type from the SQL Connections Metadata Editor. #2236

Enhancement - Added support for auto-completing table names as the user types into the Table Name combo editor. #2246

Fixed Issue - When using the SQLStandardizationPolicy FullStandardization for a SQLPassthroughDataSet query, literals and identifiers containing contiguous spaces or commas could become corrupted. In this release, the FullStandardization policy has been updated to preserve literals and identifiers, along with the additional enhancement below. To use the previous implementation of FullStandardization, the SQLStandardizationPolicy can be switched to FullStandardizationClassic. #1760

Enhancement - When using the SQLStandardizationPolicy FullStandardization for a SQLPassthroughDataSet query, the use of line comments is now supported. In previous versions of Dodeca, line comments needed to be removed or converted to block comments in order for the query to execute correctly. #2022

Fixed Issue - When utilizing a DB2 database, under some circumstances, the list of users cannot be retrieved and the following error is displayed: Unable to execute user query. Unable to deserialize UserQuery result. Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints. #2282

Fixed Issue - After deleting a role from the list in the User Roles Editor, attempting to add an additional role before committing the deletion resulted in the following error: Deleted row information cannot be accessed through the row. #2270

Added support for the ability to open the view associated with the template using the Open View tool. #1505

The view’s culture, based on the CulturePolicy and CultureName properties, is now reflected in the View Template Designer. #1436

The Essbase View Template Designer has been modified to not automatically connect to Essbase, since doing so could result in inadvertently initiating a zoom operation by double-clicking a cell. #1491

The Essbase View Template Designer has been modified to not automatically retrieve data after the Member Selection dialog is closed. #1450

Fixed Issue for ViewSelectorTree - When there is only a single root node, the Find dialog fails to locate a node that appears in the tree above the currently selected node. #2291

Enhancement - Added support for displaying multiple View Hierarchies in a View Selector via HierarchyToRoleMapping entries, whether or not an authentication service is utilized for the application. By simply specifying a Hierarchy ID and leaving the Role empty, all users of an application will see the specified hierarchy or hierarchies. #2292

Enhancement - Added support for performing a POST operation against the configured URL and rendering the response in a browser view. This capability can be used to post data to any web service, but one of the primary motivations for this enhancement is that it provides the ability to drill through to Drillbridge reports from Workbook Script in the context of an Excel-type view. #2254

Enhancement - When opening the current URL of a Web Browser View with the Open in New Browser tool, ensure that the page is opened in user’s default web browser. In previous releases, the page was opened in Internet Explorer, regardless of the user’s default browser. #2256

On the Breakpoints tab in the Workbook Debugger, to visually distinguish between enabled and disabled methods, a disabled method is now displayed with a gray background in the list of methods for the current procedure #2196

The Evaluate as Address button on the Breakpoints and Formula Evaluator tabs does not evaluate the formula when the view’s culture uses a non-comma character as the List Separator. #2286

Fixed Issue: When attempting to cut multiple rows, the client can become frozen if the first selected row is the active row. #2296

Enhancement: The ability to navigate directly from an event link to the associated procedure is now supported by the following keyboard and mouse operations: #1141

Enhancement: The Workbook Script Editor now supports the ability to navigate from a method argument value that represents a metadata ID directly to the metadata instance in the appropriate Metadata Editor.

Enhancement: The ability to copy and paste an entire workbook script as text is now supported. With this capability, a workbook script can be viewed as text in any text editor, edited, and then pasted back into the WBS Editor. #2093

Enhancement: In previous versions, clicking the Method Arguments column header automatically sorts the arguments in ascending order alphabetically. Clicking again sorts the arguments in descending order. The only way to restore the original default order is to close and reopen the editor.

In the 7.6.2.6670 release, the Find/Replace dialog was revamped to provide a more user-friendly and robust capability. The 7.6.3.6719 release included additional fixes and enhancements, and this release includes further improvements, including the addition of Bookmark All and Clear Bookmarks functionality. #2176, #2158

Enhancement: The height of the Help pane in the Workbook Script Editor Help pane height is retained when the editor is closed and restored when the editor is reopened. The height is persisted across sessions. #2094

Enhancement: A new button on the Procedures toolbar and context menu has been added to provide the ability to expand or collapse all procedures and their methods. #1374

Formula Editor Enhancement - The position of the splitter between the function description pane and the formula pane is now retained when the dialog is closed and restored when the dialog is reopened. The position is persisted across sessions. #2085

Fixed Issue: The user is allowed to paste a value into an Event Link, Method, or Argument Name column. #2181

Fixed Issue: Under certain conditions, the following message can be displayed when attempting to copy the text from a cell and pasting into another cell: The clipboard contains a WorkbookScript object. Paste the WorkbookScript text into the active cell?. In the 7.7 release, the user is not required to approve the paste operation #2093

Fixed Issue: When the Formula Editor is closed by clicking Cancel or by clicking the X, the pencil icon is displayed to the left of the argument name, which incorrectly indicates the cell value has been edited. #2093

New Function: The DataCacheToString function returns a string of values from a column in the specified DataCache. #2159

New Function: The DefinedNames function returns a delimited list of defined names based on a specified scope. #2274

New Function: The IsMember function returns whether the specified member exists. #2271

New Function: The MemberAttributeValue function returns value of the specified member attribute. #1663

New Function: The MemberFormula function returns the formula of the specified Essbase member. #2107

New Function: The Path function returns results of Path related operations. #2262

New Function: The ServerTime function returns the current date/time from the Dodeca server as an Excel date/time value. #2157

New Function: The SheetExists function returns TRUE if the specified worksheet exists. #2216

New Function: The ToolValue function returns the value of a toolbar tool. #1390

New Function: The UniqueValues function returns a delimited list of the unique values found in a given list. #1572

New Function: The UrlDecode function returns a decoded representation of a given URL-encoded string. #2255

New Function: The UrlEncode function returns a URL-encoded representation of a given string; typically used for the CallWebService method or Web Browser view’s PostData property. #2255

New Function Argument: An optional parameter, Transpose, has been added to the DelimitedStringFromRangeValues function to allow the row and column positions to be swapped. #2238

Fixed Issue with the DelimitedStringFromRangeValues and StringFromRange functions when used in conjunction with the PromptForInput method’s DropDown overload. When the function is used as the DropDownList argument value to represent the display/data value pairs presented by the dropdown list, which requires \n as the row delimiter, the dropdown list only displays a single value. #2215

The handling of the MethodCondition and CellCondition method arguments has been revised. If the argument value is the literal "false", or a case-insensitive equivalent, the method is skipped and no other arguments are evaluated.

New Method Argument: A SortOrder argument has been added to the following methods and functions to provide the ability to specify one or more columns by which to sort a data cache: BuildRangeFromScript.DataCache and ForEach.DataCache method overloads, and the DataCacheContents and DataCacheToString functions. #1672

Example: Col1
Example: Col1, Col3
Example: Col2 DESC, Col1 ASC

New Method Arguments: All methods that prompt the user for a file path, now support a ResultPropertyName and a FullFilePathPropertyName argument, which captures whether or not the user cancelled the prompt and the full path of the selected file, respectively. These properties were added to the following methods: ExportToExcel, SaveWorkbook, SaveWorkbookAsCsv, SaveWorkbookAsPdf, UpdateBinaryArtifact. #2251

New Method Overload: A FromFile overload has been added to the CopyRange and CopyWorksheet methods. The overload supports copying a specified range from an Excel file into the view. For the CopyRange method, the overload also supports copying from a delimited file (.csv) into the view. 2250

Corrected Method Documentation: The SetTextAlignment method’s HorizontalAlignment argument documentation incorrectly included RightIndent and LeftIndent as options, which are not supported. #2248

New Method: The BinaryArtifactOperations method supports the following overloads:

New Method: The EssbaseRunMaxL method runs a MaxL script on the Essbase server. #1659

New Method Overloads: The ShowMessageBox method has two new overloads, which are YesNo and YesNoCancel. These overloads allow for a workbook script to show an enhanced message box, which is also used throughout the client. For example, the Yes/No/Cancel message box is displayed when the user has modified an editable SQL View and attempts to close the view without saving the changes:

New Method Argument: The EssbaseRunCalc method now supports a RuntimeSubVars argument, which allows the method to be used to run calculations that use the runtime variables functionality introduced in Essbase 11.1.2.3. The argument value should be specified as a delimited string of dimension and member pairs, as in the following example. #1683

Market="Florida";Scenario="Actual";

New Method Argument: An InsertPolicy argument has been added to methods that copy a range. Prior to this release, these methods only performed an overlay of the CopyToRange. #2268

New Method Arguments: The SetTool method now supports the following arguments: Caption, ToolTipText, ToolTipTitle, and DisplayStyle, which controls whether or not the caption is displayed. #1890

Fixed Issue with BuildRangeFromScript Method: When the Insert argument is TRUE, the BuildRowsOrColumns argument is set to Columns, and the StartCell argument references a non-blank column, the first column of the insert range is overwritten, which also leaves a blank column to the right of the insert range.

Fixed Issue with OpenView Method: In the 7.6.3.6719 release, an issue was addressed with the opened view’s AfterBuild workbook script procedure not executing when the Close argument is set to True. Another related issue has been addressed, which can be encountered when calling OpenView in a report generator workbook script. When the workbook script opens an Essbase view after opening a SQL view, the procedure that called the ForEach method does not resume. #2188

Fixed Issue with RenameWorksheet Method: For an Essbase Excel view, which has the DataCellDoubleClickPolicy set to AddSheetForDrillthrough, and also has a workbook script, which calls RenameWorksheet to rename a drill-through sheet, the user is then unable to perform Essbase operations on the drill-through sheet. No error is displayed when an operation is attempted, it simply does not perform the operation. #2204

Fixed Issue with SendEmail Method’s General Overload: When Dodeca runs as a 64-bit process, which it does when using a .NET 4.6.2 release, an error similar to the following error could occur: Unable to send mail. Arithmetic operation resulted in an overflow. #2276

Fixed Issue with SendEmail Method’s ServletSMTP Overload: When using the FromDisplayName argument, an e-mail is delivered, but the FromDisplayName is not honored and the sender is displayed as the From address. #2257

Color Index Method Arguments: In Excel, a valid color index is 1 to 56. In a workbook script, a valid color index is 0 to 55; however, in previous releases, the dropdown list of valid values for a method argument, which represents a color index, included values 1 to 56, but setting the value 56 resulted in the following error: Color index must be between 0 and 55. And, there was no way to specify the first Excel color index.

Enhancement: When using tools with a WorkbookScriptToolController, tool settings such as Visible and Enabled that have not been mapped to workbook script properties can now be configured in the Toolbars Designer or via the SetTool workbook script method. In previous Dodeca versions, using the Toolbars Designer or SetTool method to configure unmapped tool properties resulted in the settings being reverted to the default value (True) whenever the tool refreshed. #2111