Dodeca Version 8.5.0

September 17, 2025 - Build 977

This version of the Dodeca Framework uses the .NET Framework, version 4.7.2 and higher on the desktop. The components used in this version of Dodeca are SpreadsheetGear 2023 (9.3.23.102), NetAdvantage 2021, Volume 2 (21.2.46), Aspose.Cells 24.10.0, Aspose.Slides 24.10.0, Syncfusion Essential Studio 25.1.39, GdPicture.NET 14.1.0.121, and Xceed Zip 3.6.7363.15420.

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 17 and 21. The minimum supported versions of popular Java Application Servers are:

  • Apache Tomcat 10.1.x

  • Oracle WebLogic 12.2.x

  • IBM WebSphere 9.0

The Dodeca-Essbase connector (for all Essbase versions) is supported and tested on Java 8, 11, 17 and 21.

This version of Dodeca contains updated JDBC drivers for various relational databases. Note that other drivers can also be used with Dodeca. Drivers packaged with this version are shown in the table below. #4115

Driver Class Version

oracle.jdbc.OracleDriver

23.9

com.microsoft.sqlserver.jdbc.SQLServerDriver

12.10

com.ibm.db2.jcc.DB2Driver

4.35

com.mysql.cj.jdbc.Driver

9.4

org.h2.Driver

2.3

org.postgresql.Driver

42.7
Known Issues with Packaged Drivers

PostgreSQL JDBC driver version 42.7.4 or lower is currently supported for a Dodeca repository.

DB2 JDBC driver 4.35 has a classpath reference to a jar file that appears to be missing from the DB2 installation. The missing jar, pdq.jar, may cause multiple log file error entries referring to a java.nio.file.NoSuchFileException when scanning for the pdq.jar file. This log message has no known effect on Dodeca repository operations.

The release notes for this version contain the following items:

Application Culture

  • Enhancement: Added a Spanish language pack such that the display language of a Dodeca application can be set to Spanish via the application’s CulturePolicy and/or CultureName settings. #3905

Cascadable Views

  • Enhancement: EssbaseMemberQuery has been added as a Cascade Source Type. #3976

    image

ClickOnce Deployments

  • Fixed Issue: The SmartClient will redownload even though it has been successfully downloaded in the past. #4010

Commentary

  • Fixed Issue: Resolved an issue where comments were not properly deleted when using the Comments Editor with the EditMode property set to Grid.

Composite View

A new view type, referred to as a Composite View, has been added to Dodeca. This new view type can be used to combine worksheets from multiple views into one view. #4077

Dataset Adaptors

  • Added a Parquet adaptor, which allows for bringing connector data in Apache Parquet data format into Dodeca views and selectors. #4098

Dodeca Shell

  • New Commands: Saved View Commands:

    • remove-sharing: Remove sharing for a saved view

    • list-saved-views: List saved views

    • list-shared-views: List shared views

    • delete-saved-view: Delete a saved view #3815

  • Properly mask JDBC password input on Windows when using the jdbc-test command. #4145

Essbase Scripts

  • Fixed Issue: In an MDX script, when a shortcut qualified member name or alias contains an internal closing bracket, an Essbase error similar to the following occurs when executing the query: Unknown Member <member-containing-bracket> used in query. In this release, Dodeca will automatically escape internal closing brackets in tokens. #3728

Metadata Server

  • Enhancement: The Dodeca Metadata Server has been fully migrated to Spring Boot, modernizing the architecture, simplifying configuration, and aligning with current Java web application standards. The migration is designed to be mostly transparent to existing deployments, while improving maintainability and enabling future enhancements. #3387

    Supported application servers include:

    • Tomcat 10.1.x and higher

    • Oracle WebLogic 12.2.x and higher

    • IBM WebSphere 9.0 and higher

  • Fixed Issue: Attempting to launch DSMS leads to an error connecting to database when the password is encrypted. #4041

Modules

  • Fixed Issue: In 8.4.0, .NET assembly binding was loosened to support the ability to update Dodeca without the need to repackage and update modules. Support was added for Applied OLAP assemblies but not third-party dependencies, which could result in an error similar to the following: Could not load file or assembly '<assembly identifier>' or one of its dependencies. #3952

OAuth Connections

  • Enhancement: Added support for client-based OAuth connections in order to support providing authorized access to protected resources throughout Dodeca applications.

    Below is an example of a generic OAuth connection that authorizes the end user by signing in with Google:

    Google Connection

    OAuth connections can be tested using the standard Test Connection functionality of the Connections Editor.

    Google Connection Test

    While a generic OAuthConnection is provided in the standard distribution, vendor-specific OAuth connection types are available for download from the Applied OLAP website. Some connection types in Dodeca, such as SharePointConnection now require a vendored OAuth connection(MicrosoftConnection) as part of their standard configuration. This is more maintainable and reusable than setting OAuth configuration properties directly in connection definitions.

    SharePoint Connection

    Likewise, an OAuth connection can now be used to authorize access to arbitrary HTTP resources and DataSets:

    HTTP Connection

    In the Dodeca 8.5.0 release, the following connection types can be configured with OAuth connections: EDMConnection, EPMCloudPlanningConnection, HTTPConnection, and SharePointConnection. #4070

Selectors - ComboBox

  • Enhancement: Added support for multi-select in the SelectorComboBox control. #2472

    image

Selectors - Last Used Items

  • Fixed Issue: For SQL Selectors, when the selector list is set to DefaultSelectionPolicy=LastUsedItem, the selection policy is MultipleItems, and selection is optional, running the view with no items selected does not clear the cached items. #3858

Sharepoint Connections

  • Enhancement: Added support for OAuth connections to Microsoft Entra via an OAuthConnectionID property. This enhancement allows a SharePoint connection to use a predefined Microsoft connection ID to obtain an access token. #4068

SQL Connections

  • Enhancement: Added support for client-based, native .NET SQL connections for enhanced SQL integration within Dodeca applications.

    Client-based connections offer several advantages over traditional JDBC-based connections. The most significant benefit is simplified support for integrated security mechanisms provided by database vendors. This allows seamless authentication using Windows credentials or other directory services, enabling more secure and manageable database access.

    By leveraging integrated security, client-based connections also make it easier to enforce database-level row security, ensuring that users only access the data they are authorized to view—without requiring additional application-side logic.

    To Enable Client-Based SQL Connections, follow these steps:

    1. Download the client connector module from the Applied OLAP website.

    2. Install the module on client machines.

    3. Restart the Dodeca client to load the new module.

    4. Create a new SQL Connection in the Admin tool.

    5. Set the ConnectionMethod property to ClientBased.

    Below is an example of a native connection for Microsoft SQL Server:

    image

  • Enhancement: Added support for a native .NET connector for Microsoft SQL Server. #3654

  • Enhancement: Added support for a native .NET connector for Oracle Database. #3910

SSL/TLS Support

  • Enhancement: Add support for TLS 1.3 connections to the metadata and/or Essbase and EPM Cloud connector services. #4144

Toolbar Designer

  • Fixed Issue: The Toolbar Designer does not contain a Copy button. #3931

Toolbars Configuration Editor

  • Various enhancements were made to the Toobars Configuration Editor.

    • A Copy button has been added to the ToolbarsDesigner Tools page to copy an existing tool.

    • A Display Keys/Display Captions option has been added to the context menu of the ToolbarsDesigner Tools page to toggle the displaying tool keys rather than tool captions. This helps distinguish tools when two or more have the same caption.

    • The ToolbarsDesigner’s Toolbar Designer and Popup Menu Designer pages have been enhanced as follows:

      • A filter box has been added to allow filtering of available tools.

      • Double-click has been enabled to add an available tool to the selected toolbar or popup-menu without having to drag it.

      • A context menu item has been added to copy the right-clicked tool to the selected toolbar or popup-menu without having to drag it. #4073

  • Enhancement: A module for mapping custom tools to tool-controllers is no longer required. Each custom tool’s mapping is now stored in the tool itself. A new button, "Convert Tool-Controllers", has been added to the Toolbars Configurations Editor’s tools to provide for converting all custom tools to the new mode of mapping. #3576

User Manager

  • Fixed Issue: When two otherwise identical entries are present in the USERS table and the USER_ID differs only by case, an error is presented upon launching the User Manager: Unable to execute user query. Unable to deserialize UserQuery response. Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints. #3696

View Selectors

  • Enhancement: View Selectors now support thumbnail preview capability. #1638

  • Enhancement: A filter box has been added at the top of the View Selector. Entering text into the filter box will automatically select the first view that contains the entered text. A ShowAutoFind property has been added to the Applications Editor’s View Selector properties. The filter box also has a dropdown list of most recently used filter strings. #3977

    Filter box keys:

    • Tab will automatically select the next view that contains the entered text.

    • Shift-Tab will automatically select the previous view that contains the entered text.

    • Enter will run the selected view.

    • Esc will clear the filter box.

    • Shift-Del will clear the dropdown list of most recently used filter strings.

Workbook Scripting

  • Deprecated Method Arguments: The SharePointOperations method’s SiteType, SiteUrl, AuthenticationPolicy, ClientID, TenantID, ClientCertificate, ClientSecret, Username, Password, and Domain arguments have been deprecated. A new argument, ConnectionID, has been added to allow a reusable SharePoint connection to be used. See SharePoint Connector for more information. #3967

  • Fixed Issue: the Date overload for the PromptForInput method does not honor the DefaultValue argument. #4089

  • New Function Parameter: The SQLPassthroughDataSet Overload for the BuildRangeFromScript method has new argument, IncludeColumnNames. When set to True, it return the column headers as the first row in the dataset. If left blank, it will default to False, and not return the column headers. #3741

  • New Method: Utilize generative AI connections to provide an AIOperations.GenerateContent method/overload. This overload takes ConnectionID, Caption, Prompt, ShouldAllowEditPrompt, ShouldAllowEditResult, ShouldExecuteUponPresent, ShouldPresent, ShouldShowPrompt, ShouldShowResult, ContentPropertyName, and ContentAcceptedPropertyName arguments to manage the presentation and interactive elements of the AI prompt form. #4036

  • New Event Link: AfterDataTableRangeValidate - Occurs after a DataTableRange is validated, prior to committing changes.

  • New Event Link: BeforeDataTableRangeValidate - Occurs before a DataTableRange is validated, prior to committing changes. #2998

Workbook Scripting Functions

  • Fixed Issue: @RangeContainsRange(<Range1>, <Range2>) function returns an incorrect result if the Range1 argument contains a discontinuous range that is not configured in ascending row order. #3730

  • New Function: The SSOAttributes function returns the value (or values) of the specified attribute from the application’s configured AuthenticationProvider. #4107

    Usage
    @SSOAttributes(<AttributeName>, [<Delimiter>])
    Parameters

    • AttributeName - The name of the attribute for which the value or values are returned.

    • Delimiter - Optional (defaults to ";"); The delimiter to use when an attribute has multiple values.

  • New Function: The CHAR returns the character from the Windows character set that matches the specified value. #3854

image