Dodeca Version 8.2.1

Fixed Issue: When connecting to an LDAP server, Dodeca constructs a network credential for the user with the Windows logon domain. If the Windows logon domain differs from the domain of the configured LDAP server, the connection can fail or incorrect group information can be returned. A new LDAPCredentialDomainPolicy property has been added to the LDAP connection properties to allow for a credential to be constructed without using the Windows logon domain. #3287

Fixed Issue: When the ListSourceType of an auto-complete range is DelimitedString, and each string in the DelimitedString value is specified on a separate line in the Editor, only the first string is presented in the auto-complete dropdown list in the worksheet cell. #3315

Fixed Issue: When the user enters blanks as the accepted value, the value is not detected as invalid. #3290

Fixed Issue: When a view contains auto-complete ranges, closing the view window may cause the application to abort and display the following error: WorkbookView has been disposed. This issue was introduced in 8.2.0.913. #3283

Fixed Issue: When an Excel Essbase view is configured with multiple cascade sheets, only the data set ranges that apply to the first cascade template sheet are retrieved. #3349

Fixed Issue: In the Comments Editor, the Chat style user-interface window does not use all of the available horizontal space before wrapping. #3253

Fixed Issue: In the Comments Editor, the Grid style user-interface does not allow the Subject to be edited. #3330

Fixed Issue: When a comment range’s InCellDisplayPolicy is MostRecent, and a comment is already associated with a given cell, when another comment is entered and saved from the Comments Editor, the cell in the sheet is not automatically updated to reflect the most recently added comment. When the view is rebuilt, the sheet cell does contain the most recently added comment. #3268

Fixed Issue: When AllowAttachments is enabled for a comment range and the sheet range contains more than 1000 cells when using Oracle as the metadata database (or more than 2100 cells when using SQLServer), an error occurs when the view is built. #3338

Fixed Issue: When the Dodeca metadata service is used in a load balanced environment, changes to metadata are not reflected by all servers within the environment. As a consequence, changes made by a developer are not available to all clients. #3355

Fixed Issue: When Oracle is used as the metadata database, the following error occurs with the delete-metadata-audit-log-records --days <# of days> command: org.hibernate.exception.DataException: could not execute statement #3297

Fixed Issue: When the TENANT_CONFIG TokenDurationSeconds has not been explicitly configured in Dodeca Shell, an Error executing client request occurs when an SSO token is being created by the metadata server. #3242

Fixed Issue: When multiple Essbase drillthrough reports are available for a given cell or cells, an error similar to the following occurs when the user double-clicks to open the drillthrough report: Unable to get the Linked Objects Browser. Unable to construct the user-interface component object type "AppliedOLAP.Dodeca.Essbase.Windows.Common.DrillthroughBrowser". […​] This issue was introduced in Dodeca 8.1.0.1034. #3274

Fixed Issue: When multiple ranges are retrieved by a view that has the Asynchronous and ParallelExecution properties set to True and at least one of the retrieved ranges contains an unknown member, attempting to display the Unknown Members Explorer can result in an error similar to the following: Unable to update Unknown Members Explorer. Index was outside the bounds of the array. #3312

Fixed Issue: When the Export Metadata to Local Zip File utility is used and an existing file is selected, the user is prompted with "<file name> already exists. Do you want to replace it?" The issue is that when the user clicks Yes, the exported metadata is added to the existing zip file instead of the file being replaced with a zip file that contains only the currently selected metadata instances. #3189

Fixed Issue: When the Import Metadata from Local Zip File client utility is used to import metadata that already exists in the metadata repository, the original Imported Date value is cleared in the databaase and the current date is not assigned as the new value. As a result, no Imported Date is retained in the database. #3357

Fixed Issue: When the Dodeca Shell import-tenant command is used to import metadata and the --import-user flag is not used to specify the Imported By user, the Imported Date is not presented in the Import Metadata from Local Zip File and Export Metadata to Local Zip File utilities in the client. #3356

Fixed Issue: The Metadata Dependency Explorer does not detect an application’s dependency on the view specified as the DefaultViewID. #3218

Fixed Issue: The Metadata Dependency Explorer does not detect a SQLPassthroughDataSetHierarchy selector list’s dependency on the SQLPassthroughDataSet specified as the SQLPassthroughDataSetID. #3345

Fixed Issue: In the Module Editor, when a new module is created and files are added to the module, and then committed, the files are not retained and must be re-added to the module and then re-committed. #3292

Fixed Issue: When a view’s caption contains a forward slash and/or backslash, the following error occurs when the Open In Excel tool is used to open the view in Excel: The process cannot access the file "<file name>" because it is being used by another process.

Fixed Issue: In a previous 8.x release, the Open In Excel tool was modified to replace all non-alphanumeric characters in the view’s caption with an underscore when constructing the Excel file name. This is for security reasons, but the approach has been slightly revised to retain blank characters. So, any blanks in the view’s caption are retained in the Excel file name. #3336

Fixed Issue: When opening a PDF in the system’s default viewer with the Open in External Viewer tool, an error similar to the following is displayed: Unable to open "<file path>" in an external viewer. Unable to create the PDF file "<file path>". This issue was introduced in 8.0.0.569. #3343

Fixed Issue: The PDF navigation tools for moving to the first, last, previous, next, or specified page do not work. This issue was introduced in 8.2.0.913. #3342

Fixed Issue: Opening a PDF view can cause the application to rescale incorrectly on high DPI monitors. This issue was introduced in 8.0.0.569. #3344

Added support for rendering additional document formats, notably .doc, .docx, .htm, .html, .msg, .odt, .ppt, .pptx, .rtf, .txt, .xls, and .xlsx. #3306

In versions prior to 8.2.1, a saved Essbase adhoc view, when opened, did not restore sheets that had been added by the user before saving the view, so only the first sheet was available when the saved view was opened. This issue has been addressed in 8.2.1. #3353

Fixed Issue: When a query’s DeleteSQL, InsertSQL, or UpdateSQl calls a stored procedure, and the casing of the characters in the column names specified in the stored procedure differs from the column names in the SelectSQL statement, the delete, insert, or update operation is not performed at runtime, and no error is reported.

Fixed Issue: When the Insert View dialog is opened from the View Hierarchy Editor, the first item is highlighted, but not selected, which is misleading. If the first item represents the view to be inserted, the user must manually select the item. #3261

Fixed Issue: When an application’s ViewSelectorObjectTypeID is set to ViewSelectorExplorerBarTreeHybrid, and the view hierarchy contains a view as a root node, the context menu is either not displayed when the view is clicked with the right mouse button, or the context menu for another view that was most recently displayed, is displayed instead. #3254

Fixed Issue: When the build of a view fails due to a workbook script error, the raw XMl is written to the View Usage Log and presented in the View Usage Viewer as the Build Error. In 8.2.1, the error is logged and presented as readable text instead of XML. #3111

In 8.2.1, a Help "?" button is available for the Removed Defined Names where field. When clicked, the Where Syntax Help is opened. #3276

In the Workbook Script Debugger, when the user clicks the Formula Evaluator tab caption to open the tab or the tab is already open and visible, the value of the selected method argument in the Breakpoints tab is automatically shown in the Formula field. #3224

Fixed Issue: An error similar to the following occurs when the Workbook Script Debugger is open during the BeforeRangeRetrieve event for a view that contains multiple retrieve ranges, and any of the retrieve ranges does not use the view’s Essbase connection: #3308

Fixed Issue: In the Formula Editor, when the user attempts to insert a Dodeca function immediately prior to another Dodeca function by typing the @ symbol, the text insertion cursor jumps to the end of the second function and the context choice menu is not displayed. #3351

Fixed Issue with Workbook Script Trace Logging: When a Dodeca application is launched as a user without a documents folder (such as the sytem account), the application can get caught in an infinite loop and hang indefinitely. #3339

Fixed Issue with RangeSelectionChanged event: When a procedure is associated with the RangeSelectionChanged event link, the procedure can be executed more than once each time the range selection changes. This issue was introduced in 8.2.0.913. #3348

Fixed Issue with @Path() function: When the @Path() function is used to perform a CleanPath operation, invalid file characters are removed rather than only invalid path characters. In 8.2.1, only invalid file path characters are removed. #3329

Fixed Issue with RenameWorksheet method: When the SheetToRename and NewSheetName arguments have the same value (i.e. a sheet is being renamed to the current name), ' (1)' is added to the sheet name. #3320

Fixed Issue with SendEmail method: When any of the AttachView method arguments is True and the view’s CaptionAfterBuild property is set, the caption is not used as the name of the attachment. #3296

Fixed Issue with SetRowHeight method: The MinHeight argument is not applied when CellByCell is not used. #3321

Fixed Issue with WriteLogMessage method: When the specified Filename does not include the file extension, the following error occurs: WorkboookScriptClasses_Invalid_folder_or_filename #3275

Fixed Issue with EssbaseRetrieve method Range overload: An error similar to the following occurs when the sheet name contains a single quote or special character: Unable to retrieve range on sheet "Sheet'1". "Ess.Retrieve.Range.1" is not a valid range name. #3305

Fixed Issue with SpecifySheetsBy.AllSheets execution in asynchronous views: When adding, removing, or rearranging worksheets via a method with the SpecifySheetBy argument set to AllSheets, an illegal sheet index exception can occur. #3327