This version of the Dodeca Framework 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.0.67.102), NetAdvantage 2011, Volume 1 (11.1.20111.2042), Aspose.Cells 17.1.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 are supported and tested on Java 1.6. Both services are known to run on Java 1.7, although extensive testing has not been performed on that Java version.
The release notes for this version contain the following sections:
The new Essbase MDX view type provides a simple approach to leveraging the MDX functionality within the framework in order to generate view content without the need for workbook scripting. The MDX query can either be specified using the MdxQueryID property, which refers to a query defined using the Essbase Script Editor, or as the actual query using the MdxQueryString property. The other view properties that are used to control the query results are the same as those supported for the EssbaseMdxQuery workbook script method. Refer to the Workbook Script – Essbase MDX, 6.3.0 section, for additional information.
This issue was resolved in Dodeca 7.3.0.6125. See the notes on SpreadsheetGear 2017 from the 7.3.0.6125 release for further details on the enhancements provided.
A new Essbase option, referred to as Strict Mode, controls whether or not Essbase operations are performed on the server when unknown members are detected. The operations include all retrieve-based operations and the send operation. When strict mode is turned on, the detection of an unknown member prevents the operation from being executed, and the existence of unknown members is reported in the client. When the Display Unknown Members option is also turned on, the unknown members are also presented. #1539
The Strict Mode option is particularly useful within the context of performing a send operation. It allows for the data to be corrected before another send is attempted, and ensures that all members are valid before any data is written to the database.
Fixed Issue – An issue with the LastColumn function, which was introduced in version 7.3.0.6125 and caused some issues with existing workbook scripts, has been resolved and the function now works exactly as before. This function has never worked as intended when a range argument value is not specified. The function argument description has been modified to read as follows:
If an address is not specified, then the column count of the used range is returned. If the origin of the used range is not in column A, the returned value must be adjusted by the number of columns to the left of the first column of the used range in order to compute the actual last column.
As an alternative to using the LastColumn function to obtain the last
column of the used range, the new LastCell function can be used
instead, such as =COLUMN(LastCell())
.
New Functions – The FirstCell and LastCell functions return the address of the first and last cell, respectively, of the specified range, or used range if no range argument value is specified. #1874
Function Usage:
@FCell([<Address>]) and @LCell([<Address>])
New Function – The SheetName function returns the sheet name for the specified one-based sheet index argument, or the current sheet name if no sheet index argument value is specified. #1682
Function Usage:
@SheetName([<SheetIndex>])