Dodeca Version 7.7.2

October 18, 2019 - Build 6976

This version of the Dodeca uses the .NET Framework, version 2.0, Service Pack 1 and higher on the desktop. The components used in this version of Dodeca are SpreadsheetGear 2017 (8.1.58.102), NetAdvantage 2011, Volume 1 (11.1.20111.2042), Aspose.Cells 19.5.0.0, Syncfusion Essential Studio 13.4.0.63, and GdPicture.NET 11.0.6.

This version of Dodeca has two server-side services that run inside a Java Application Server. The Dodeca service is supported and tested on Java 1.6. The Dodeca-Essbase service for all Essbase versions prior to, and including, Essbase 11.1.1.3 are supported and tested on Java 1.5. The Dodeca-Essbase service for all Essbase versions 11.1.1.4 and higher is supported and tested on Java 1.6. Both services are known to run on Java 1.7, 1.8, 1.9, and 1.10.

This release contains the following changes:

Authentication Services - LDAP Authentication Services

  • Fixed Issue - When leveraging an LDAP authentication service and the session expires due to the application’s SessionTimeoutPolicy, if the AllowReauthenticateAndContinue property is set to true, the user is not prompted to reauthenticate. #2372

  • Fixed Issue - When sharing views against an Active Directory server, attempting to share views with specific people can result in an invalid view selector state. Additionally, under some circumstances when no users or roles to share views with can be identified, Dodeca will attempt to look up valid users and roles each time the user presses the Share with…​ or Specific people…​ button. #2365

  • Enhancement - When authenticating against Active Directory, added support for a new UsersToShareViewsWith UsersInSpecificRoles policy for view sharing. This policy allows sharing views with any user in a role indicated via the UsersToShareViewsWith_SpecificRoles property. #2373

  • Enhancement - When authenticating against Active Directory and utilizing the UsersToShareViewsWith UsersInSameRoleAsUser policy for view sharing, a more efficient LDAP search query is now used to identify users in the same role as the current user. #2366

Essbase Excel Views

  • Fixed Issue: When a cascaded Essbase Excel view has a selector list configured with the TokenForMemberNameAndAlias property set to True, the T.Member.Name and T.Member.Alias tokens for the associated Essbase selector are not updated for each cascade sheet during the build. #2336

Essbase Selector ComboBox

  • Fixed Issue: When the selector list associated with an Essbase selector combobox, is configured with the TokenForMemberNameAndAlias property set to True, the T.Member.Name and T.Member.Alias tokens are not created. #2335

Excel Views

  • Fixed Issue: In the View Metadata Editor, the StatusSelectionTextChanged property value cannot be set (and no default value is displayed) for an Excel view or a SQL view. #2364

Export and Import Metadata

The Export Metadata to Local Zip File and Import Metadata from Local Zip File dialogs support Excel-style auto-filtering on rows. The maximum number of items in the filter drop-down lists has been increased to avoid the need to scroll when the total the number of items is 20 or less. #2376

Linked Reporting Objects

  • Enhancement - Added support for drill-through reports created in Essbase Studio. #2344

Metadata Dependency Explorer

  • Fixed Issue: The SQLPassthroughDataSet associated with an EssbaseSQLPassthroughDataSet selector list is not presented in the depended on dependency results. #2339

Page Setup Dialog

  • Fixed Issue: In the Page Setup dialog, when a font size is specified without also selecting the Bold and/or Italic style for a given header or footer section, the Unsupported format and element codes are highlighted in red. error appears when the dialog is reopened. #2278

Search Metadata Properties

  • Fixed Issue: When an application is assigned a SplashImage or the application’s view selector is assigned an Image, the image is stored in the metadata as an encoded string. In the Search Metadata Properties dialog, when a search is performed and the specified search string is contained within the image’s encoded string, the search fails and a large red X appears in the search results control. #2375

SQL Views

  • Fixed Issue: In the View Metadata Editor, the StatusSelectionTextChanged property value cannot be set (and no default value is displayed) for an Excel view or a SQL view. #2364

  • Fixed Issue: When the first row of a SQL view’s data table sheet range contains formulas, leading blanks are removed from text cell values in the first row of retrieved data. #2353

View Wizards

  • In the view wizards' Add an Essbase Excel view page, the Create an Excel 2007-2010 workbook (.xlsx) caption was replaced with Create an Excel workbook (.xlsx). #2362

Workbook Script Editor

  • Fixed Issue: When entering the Workbook Scripts Editor, and the Definition, Properties, and EventLinks sections are not visible, if the Help section splitter is raised as high as possible, unhiding the EventLinks, and then the Properties, and then the Definition sections results in an error. #2341

Workbook Scripting

  • New Function Argument: An optional parameter, UseCache, has been added to the MemberUDAs function to indicate whether the member UDAs should be returned from the session cache, if contained in the cache, or retrieved from the database. By default, the cached UDAs are returned by the function, which is typically appropriate, unless the member’s UDAs have been modified during the session. #1670

    Usage
    @MbrUDAs(MemberName, [AliasTable], [ConnectionID], [DefaultValue], [UseCache])
    Parameters

    • MemberName - The member specified can be an alias or a member name.

    • AliasTable - (Optional) The default is the view’s AliasTable. The alias table to use.

    • ConnectionID - (Optional) The default is the view’s connection. The ID of the Essbase connection.

    • DefaultValue - (Optional) The default is an empty string. The value to use if the member has no UDA’s.

    • UseCache - (Optional) The default is TRUE. Indicates whether the UDAs should be returned from the session cache, if contained in the cache, or retrieved from the database.

  • Fixed Issue with SetProtection method’s Workbook Overload: When StructureProtected is True, the specified Password is not applied. When the view is then opened in Excel, the user is not prompted to provide a password in Excel when attempting to unprotect the workbook. #2363

  • Fixed Issue with SetProtection method’s Sheets Overload: Unable to set SheetVisibility to VeryHidden when the sheet is currently hidden. #2374

  • Fixed Issue with the EssbaseMdxQuery method inserting columns in the first row and rows in the first column when the StartCell argument is specified. #2294