Dodeca Framework Release Notes

Applied OLAP, Inc.


Table of Contents

Version 8.1.4.35
Client-Side Logging
Commentary
Import Connections
Modules Metadata Editor
SQLPassthroughDataSets
Zoom Factor Tool
Version 8.1.3.77
Dodeca Shell
Import Metadata
Selectors
SQLPassthroughDataSets
View Template Designer
Workbook Script - Utility Scripts
Workbook Scripting
Version 8.1.2.35
Binary Artifact Editor
Commentary
Saved Views
SQL Connections
View Metadata Editor
Workbook Scripting
Version 8.1.1.72
Application
Commentary
Essbase Views
Excel Behavior
Metadata Dependency Explorer
Selectors
Toolbars Configuration Editor
Workbook Script Debugger
Workbook Script Editor
Workbook Scripting
Version 8.1.0.1304
Application - Duplicate (View) Tool
Application Culture
Application Metadata
Application Style Library
ClickOnce Prep Utility
Cell Attachments
Comment Range Editor
Commentary
Dodeca Shell
Essbase Data Audit Log
Essbase Cube Editor
Essbase Excel and SQL Excel Views - Cascading
Essbase Scripts Editors
Essbase Zoom In PopupMenuTool
Excel Template Views
Log4j Vulnerability
Metadata - Importing and Exporting Metadata from Local Zip File
Relational Views
Reporting Services View Type
Ribbons
Search Metadata Properties
Security - SamlAuthentication
Selector Lists
Selector Editor
Selectors
SQL Connections - Tokenized SQLConnectionID
SQL Passthrough DataSet Editor
SQL Passthrough DataSets
Outline Viewer
User Manager
Views - Miscellaneous
View Selectors
Workbook Script Debugger
Workbook Script Editor
Workbook Script PseudoCode
Workbook Script - Utility Scripts
Workbook Scripting
WorkbookScriptToolController
Version 8.0.4.37
Application and View Culture
ClickOnce Prep Utility
Essbase Connector
Essbase Scripts Editor
Essbase Views
SQL Passthrough DataSets
Views
Workbook Script Tracing
Workbook Scripting
Version 8.0.3.36
Application Behavior and Performance
Commentary
Dodeca Metadata and Essbase Servlets
Essbase Views
Excel Behavior
Open View Tool Controllers
SQL Passthrough DataSets
Workbook Analyzer Utility
Workbook Script Editor
Workbook Scripting
Version 8.0.2.45
Commentary
dodeca-essbase Server Timed Logger
Dodeca Shell
Essbase Connections and Essbase Authentication Services
Essbase Selectors
Essbase Views
HFM Connection
SQLPassthroughDataSets
View Metadata Editor
View Status Bar
View Usage Viewer
Workbook Script Editor
Workbook Scripting Methods
Workbook Scripting Functions
Version 8.0.1.37
Application - Floating View and Metadata Editor Windows
Application Metadata Editor
Audit Logging
ClickOnce Prep Utility
Commentary
Import Metadata
PDF View
Relational Views
View Selector
Workbook Analyzer
Workbook Script Debugger
Workbook Script Editor
Workbook Scripting
Version 8.0.0.569
Application
Application - Dockable Window Tools
Application - Floating View and Metadata Editor Windows
Application Metadata Editor
Application Styling
Binary Artifacts Editor
Cascade Views
Commentary
Dodeca Framework About Dialog
Dodeca Shell
Essbase Connections
Essbase Excel View - Data Drill-through
Essbase Excel View - Miscellaneous
Essbase Functionality
Essbase Member Select
Essbase Service
Essbase Scripts Editor
Essbase SmartLists
Excel-based Views
Excel Behavior
Excel File Encryption
Exporting an Excel File as a Binary Artifact
Importing an Excel File as a Binary Artifact
Metadata Dependency Explorer
Metadata Editors
Metadata - Importing and Exporting Metadata from a Local Zip File
Open View Tool Controllers
Relational Essbase Outline Caching
Relational Views
ScriptEssbase View
Selector List Metadata Editor
Selector List - Range Selector List
Selectors - Fixes
Selectors - Essbase Selector TreeView
Selectors - Last Used Items
Selectors - Multiple Item Selection Enhancements
Selectors - New SelectorTextBox Control
Selectors - SelectorListBox Search
Sign On and Set Active Essbase Connection Tool
SQL Passthrough DataSets
SQL Passthrough DataSets Metadata Editor
Tool (and Other) Images
Users Manager
View Hierarchy Metadata Editor
View Metadata Editor
View Selectors
View Template Designer
Workbook Analyzer
Workbook Script Editor
Workbook Scripting
Workbook Scripting Event Links
Workbook Scripting Functions
Workbook Scripting Methods
Version 7.8.8.7644
Application Styling
Excel Charting
Import Metadata
Metadata Editors
PDF View
Relational Views
Search Metadata Properties
View Selector Tree
Workbook Script Editor
Workbook Scripting
Version 7.8.7.7532
Adhoc Essbase View
Essbase Excel View
Formula and Script Editors
MDX
Metadata Dependency Explorer
Outline Viewer
Token Replacement in Excel Views
View Template Designer
Workbook Script Editor
Workbook Scripting
Version 7.8.6.7413
Metadata Dependency Explorer
Relational Functionality
View Metadata Editor
Workbook Script Editor
Workbook Scripting
Version 7.8.5.7321
Application Styling
Essbase Excel View
Essbase Selector Tree
Excel Behavior
JNDI Connections for Essbase
Relational (SQL) View
SQLPassthroughDataSet Metadata Editor
SQL Selectors
Workbook Script Editor
Workbook Scripting
Version 7.8.4.7239
Auto Build Tool
Comments
Essbase Date Measure
Metadata Dependency Explorer
Selector Lists
SQLPassthroughDataSet - Queries
Workbook Script Debugger
Workbook Scripting
Version 7.8.3.7209
Essbase Excel Views
Essbase Selectors
Essbase View Template Designer
Excel Auto-Filtering
HFM Connection
Spreadsheet Calculations
View (and Essbase View) Template Designer
Workbook Script Editor
Workbook Scripting
Version 7.8.2.7107
Application - Workbook Script Reference Guide
SQLPassthroughDataSet
Version 7.8.1.7084
Essbase Member Select
Version 7.8.0.7077
Essbase Connections Editor
Essbase Options
Essbase Outline File Extraction
Essbase Outline XML Extraction
Essbase Scripts Editor
Essbase Server Scripts Editor
HFM Connector
License Validation
Metadata Dependency Explorer
Selectors
SQLPassthroughDataSet - Queries
View Selector Tree
View Template Designers
Workbook Script Editor
Workbook Scripting
Version 7.7.3.6997
Essbase Outline XML Extraction
Workbook Scripting
Version 7.7.2.6976
Authentication Services - LDAP Authentication Services
Essbase Excel Views
Essbase Selector ComboBox
Excel Views
Export and Import Metadata
Linked Reporting Objects
Metadata Dependency Explorer
Page Setup Dialog
Search Metadata Properties
SQL Views
View Wizards
Workbook Script Editor
Workbook Scripting
Version 7.7.1.6909
Application Setup Utility
Selectors
Workbook Scripting
Version 7.7.0.6870
Accelerator Utility
Application - Session Timeout
Application - Startup
Application Tokens
Authentication Services - EssbaseSimpleAuthentication
Authentication Services - LDAP Authentication Services
Authentication Services - SQLSimpleAuthentication
ClickOnce Prep Utility
Essbase Date Measures
Essbase Audit Logging
Essbase Excel View — Export View to Excel / Import View from Excel
Essbase Options Dialog
Essbase Selector Tree
Essbase Selectors - Tokens
Essbase Service
Excel Undo and Redo Enhancement
PDF Support
Print Tools
Request and Response XML Logging
Selectors with Dockable Controls
Send To Mail Recipient Tools
SQL Connections
SQLPassthroughDataSet - Columns Editor
SQLPassthroughDataSet - Identify Table Columns
SQLPassthroughDataSet - Queries
User Manager
User Roles Editor
View (Excel and Essbase) Template Designer
View Selectors
WebBrowser Views
Workbook Script Debugger
Workbook Script Editor
Workbook Scripting Functions
Workbook Scripting Methods
Workbook Scripting - WorkbookScriptToolController
Version 7.6.3.6719
Application Default Admin Toolbars
Essbase Scripts
LDAP Authentication Services
PDF Support
Search Metadata Properties
SQLPassthroughDataSet Metadata Editor
View Metadata Editor
Workbook Scripting
Workbook Script Metadata Editor
Version 7.6.2.6670
Essbase Member Select
Linked Objects Browser
Metadata Dependency Explorer
View Template Designer – Name Manager
Workbook Script Editor – Fixes
Workbook Script Editor – Enabling/Disabling Event Links and Methods
Workbook Script Editor – Find/Replace Dialog
Version 7.6.1.6638
Dodeca Application Styling
Dodeca Metadata Service
Essbase Adhoc View
Essbase Excel View Cascading with MDX
Essbase Member Select
Essbase Script Editor
Essbase Text Measures
Metadata Dependency Explorer
Sample and Starter Kit Metadata
Security – SSL/TLS Support
SpreadsheetGear Control
SQLPassthroughDataSet – Identify Table Columns
SQLPassthroughDataSet – Test Form
SQL Query Performance
View Sharing
View Template Designer
Workbook Script Editor
Workbook Script Functions and Methods
Version 7.6.0.6549
Application Setup Utility
Essbase Adhoc Views
Essbase Excel Views
Essbase Selector Metadata Editor
Essbase Server Scripts Editor
Import View from Excel Tool
PDF View
Query Editors
SQLPassthroughDataSet Editor
SQLPassthroughDataSet Fixes
View Selector Tree
Workbook Script Editor Enhancements and Fixes
Workbook Script Functions and Methods
Version 7.5.0.6430
Cache Viewer
Client Startup
Commentary
Dodeca Application Styling
Essbase Excel Views
Essbase MDX Views
Essbase Report Script
Essbase Scripts Metadata Editor
Essbase Selectors
Essbase Send and Date Measures
Essbase Server Scripts Editor
Export Metadata to Local Zip
LDAP Authentication Services
JNDI Connections for Essbase
Metadata Dependency Explorer
SQL Selector Tree
View Metadata Editor
View Selectors
View Status Bar
Workbook Script Editor Enhancements
Workbook Script Editor Fixes
Workbook Script Functions and Methods
Version 7.4.3.6279
Fixes
Version 7.4.2.6268
Version 7.4.1.6256
ClickOnce Prep Utility and JDBC Test Utility
Essbase Connections Metadata Editor
Essbase Views
Hierarchy Metadata Editor
Outline Viewer
Version 7.4.0.6210
Authentication Services
Essbase MDX View Type
Essbase Scripts Metadata Editor
Essbase Selectors
OpenXML Document Support
Outline Viewer
Unknown Members and Strict Mode
View Metadata Editor
Workbook Script Editor
Workbook Scripting Functions and Methods
Version 7.3.0.6125
Authentication Services
Dodeca Metadata Service
Essbase Adhoc Views
Essbase Outline Viewer
Essbase Scripts Metadata Editor
Essbase Selectors
Excel Views
JNDI Connections for Essbase
Metadata Editors
Metadata Property Search Utility
SpreadsheetGear 2017
SQL Connections
SQL Selectors
SQLPassthroughDataSets - Testing and Debugging Enhancements
View Metadata Editor
View Selector Tree
Workbook Script Editor
Workbook Scripting Functions, Event Links, and Methods – Fixes and Enhancements
Version 7.2.2.5869
Fixes
Workbook Scripting
Version 7.2.1.5854
Fixes
SQL Selector Tree
Workbook Scripting
Version 7.2.0.5810
Application
All View Types
Authentication Services
Client Startup
Data Audit Log
Documentation
Essbase Adhoc Views
Essbase Selector Treeview
Essbase Views
Security
SQL Selector Tree
User Manager
View Usage Logs
Workbook Script
Version 7.1.11.5648
Essbase Excel View
Essbase Selector Treeview
Version 7.1.10.5635
View Selector Explorer Bar
Version 7.1.9.5627
Workbook Scripting
Version 7.1.8.5620
Excel Essbase View
Version 7.1.7.5610
Version 7.1.6.5605
Version 7.1.5.5596
Application – Security
Comments
Toolbars Configurations Metadata Editor
Workbook Scripting
Version 7.1.4.5582
SQL Selector Tree
Workbook Scripting
Version 7.1.3.5565
Version 7.1.2.5546
WebBrowser View
Essbase Views
Version 7.1.1.5531
Toolbars Configuration Editor
Version 7.1.0.5510
Workbook Scripting
Version 7.1.0.5508
Excel Essbase View
Request and Response XML Client-Side Logging
Version 7.0.1.5495
SQLPassthroughDataSet Editor
View Selector Tree
Workbook Scripting
Version 7.0.0.5479
Essbase Selector Treeview
Essbase Views
Version 7.0.0.5467
Essbase Views
Workbook Scripting
Version 7.0.0.5464
Essbase Selector Tree
Essbase Views
Save as PDF and Open in PDF Viewer
Workbook Scripting
Version 7.0.0.5433
Workbook Scripting
Version 7.0.0.5426
Version 7.0.0.5422
Comments – Fixed Issues
Workbook Scripting – Fixed Issues
Version 7.0.0.5405
Workbook Scripting – Fixes
Version 7.0.0.5401
Authentication Services – Fixes
View Usage Logging – Fixes
Version 7.0.0.5388
Metadata Database Schema Changes
New Workbook Scripting Functionality
Application – General
Application – User Access, User Manager and User Roles
Application – Session Timeout
Application Setup Utility – Import Dodeca License
Authentication Services – DodecaUserRoles and EssbaseSimpleAuthentication
Comments - Fixes
Dodeca-Essbase Server – Fixes
Dodeca Metadata Server and dodeca-essbase Server Logging
Essbase Data Audit Logging - Fixes
Essbase Selector Treeview – Expansion and Selection Filtering
Essbase Selector Treeview – Fixes
Essbase Views
Formatting Tools - Fixes
Request and Response XML Client-Side Logging
Selectors - Fixes
SQLPassthroughDataSet Editor
SQL Selector Tree
Token Editor
View Selectors – General
View Selectors – Access Filters
View Usage Logging
WebBrowser View - Enhancements
Workbook Script Editor - Fixes
Workbook Scripting – Event Links, Functions, Methods
Version 7.0.0.4749
Workbook Script Editor
Version 7.0.0.4688
Essbase Views
SQL View
Version 6.7.10.4588
Authentication Services
Excel and Essbase Excel View Wizards
Sign On and Set Active Essbase Connection
View sharing
Workbook Script
Version 6.7.9.4567
Version 6.7.8.4546
Version 6.7.7.4533
Version 6.7.6.4528
Version 6.7.5.4463
Version 6.7.4.4389
Version 6.7.3.4379
Version 6.7.2.4363
Version 6.7.1.4340
Version 6.7.0.4294
Version 6.6.0.4194
Version 6.5.2.3935
Version 6.5.1.3914
Version 6.5.0.3872
Version 6.4.3.3803
Version 6.4.2.3797
Version 6.4.1.3791
Version 6.4.0.3770
Version 6.3.0.3696
Version 6.2.4.3435
Version 6.2.3.3425
Version 6.2.2.3416
Version 6.2.1.3404
Version 6.2.0.3390
Version 6.1.1.3193
Version 6.1.0.3142
Version 6.0.0.3106
Version 5.3.1.2694
Version 5.3.0.2646
Version 5.2.2.2515
Version 5.2.1.2481
Version 5.2.0.2398
Version 5.1.0.2320
Version 5.0.1.2283
Version 5.0.0.2260
Version 4.1.0.1749 and Earlier

Dodeca Framework Release Notes

Version 8.1.4.35

June 10, 2022

This version of the Dodeca uses the .NET Framework, version 4.7.2 and higher on the desktop. The components used in this version of Dodeca are SpreadsheetGear 2017 (8.6.7.102), NetAdvantage 2021, Volume 2 (21.2.46), Aspose.Cells 19.5.0, Syncfusion Essential Studio 19.2.0.44, GdPicture.NET 14.1.0.112, 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 1.8. 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.

The release notes for this version contain the following sections:

Client-Side Logging

  • Added support for client performance logging and request/response xml logging at startup. These capabilities can be enabled by modifying the AppliedOLAP.Dodeca.SmartClient.exe.config file as in the following example. #3207

    <appSettings>
      <!-- ... -->
      <!-- Indicates whether to write performance log at startup. -->
      <add key="LogPerformanceAtStartup" value="true"/>
      <!-- Indicates whether to log request response xml at startup. -->
      <add key="LogRequestResponseXmlAtStartup" value="true"/>
      <!-- Indicates an optional path for logging request response xml at startup. -->
      <add key="LogRequestResponseXmlAtStartupPath" value="C:\temp\dodeca\logs"/>
    </appSettings>

Commentary

  • Fixed Issue: Certain Unicode characters, such as the Euro symbol "€", are not retained correctly in comments. For example, the Euro symbol renders as "€" when the saved comment is displayed in the client. This issue was introduced in 8.0.0.569 and only affects Windows servers. #3142

Import Connections

  • Fixed Issue: The Import Connections utility, which is accessed from the Essbase Connection Editor, does not assign the specified APS URL to the Essbase connections created by the import. #3202

Modules Metadata Editor

  • Fixed Issue: When none of the modules loaded into a running application include a .NET assembly (.dll) file, the Modules Metadata Editor's Module Files editor fails to validate any module and presents a path not found error message when the Validate button is pressed. This issue was introduced in version 8.0.0.569. #3184

SQLPassthroughDataSets

  • Fixed Issue: When a TIMESTAMP type column is inserted or updated, the value written into the table is shifted by the Dodeca client and server’s local time zone offsets. When a TIMESTAMP type column is subsequently selected, the value is shifted by the Dodeca server’s local time zone offset. #3208

Zoom Factor Tool

  • Fixed Issue: When the Ctrl key and mouse wheel are used to change the zoom magnification, the update of the percentage is not synchronized correctly with the magnification percentage of the sheet. #3200

Dodeca Framework Release Notes