Dodeca Version 7.3.0

RoleFilters – A new property has been added to Authentication Services that obtain roles directly from an upstream provider (EssbaseUserRolesFromGroupNames, LDAPUserRolesFromGroupNames, and DodecaUserRoles). RoleFilters allow administrators to govern which roles obtained from the provider are utilized and displayed within the context of a Dodeca Application. Multiple filter strings can be leveraged, and wildcards are supported. #1802.

LDAP Authentication Services: ConnectionMethod – A new property has been added to the LDAPConnectionProperties leveraged by the LDAPUserRolesFromGroupNames and LDAPUserRolesFromSqlPassthroughDataSet authentication services. The ConnectionMethod applies primarily to the Active Directory ImplementationType and dictates the way that authentication and role lookups are performed. #1847

Fixed Issue: When the dodeca metadata database credentials, as specified in the hibernate.properties file, are invalid, an error similar to the following is returned by the service: The servlet connection validation failed: "SOAP-ENV" is an undeclared namespace. Line 1, position 41. #1835

Fixed Issue: When an adhoc view’s ExcelAddInMode property is True and a connection is assigned to the EssbaseConnectionID, the RetainOnRetrieval setting is not applied for a workbook that was opened using the Open Workbook tool. #1772

Fixed Issue: An Undo of an Essbase operation positions the restored data with the origin at A1 instead of at the same origin as the original data. #1810

Developing Essbase Queries and Scripts – The Essbase Scripts query editor provides syntax highlighting and context-sensitive completion hints for all available query types. In this release, it provides further code assistance via supplementary documentation for the MDX and Report Script query types. Documentation for the remaining query types will be introduced in a subsequent release.

Testing Essbase Queries and Scripts – The ability to test queries has been added directly to the query editor. For the MDX, Report Script, and Member Query types, results can be shown in a grid or as a list of members by toggling the "Show as Member List" checkbox.

Refining Essbase Queries and Scripts – Two Essbase Script query editors can be open simultaneously, and changes can be made to the Essbase Script properties while a query editor is open. This was incorporated so that refinements to the Test properties can be made while an editor is open, and an open script can be minimized while other work is performed or another script is opened for comparison. The Test properties, including Tokens, are utilized to provide context for testing the script, and they serve to provide information otherwise provided by a View or Workbook Script. Test Properties do not apply when an Essbase Script is executed in the context of a View; rather, these properties are provided by the View or Workbook Script in which the query is executed.

Reusing Essbase Queries and Scripts – With the introduction of the Essbase Scripts Metadata and Query Editors, EssbaseScriptIDs can now be used throughout the product where appropriate. For script and query-based Essbase Selector Lists, a filtered list of EssbaseScriptIDs is now available.

New: EssbaseMdxQuery Selector List – The new MDX script selector list type supports the ability to generate the list of Essbase members presented by the selector with an MDX query, which can be used, for example, to create dynamic subsets of members. #1514

Enhancement: Essbase Selector Tree – The Item Selection and Item Expansion filters exposed in the Essbase Selector Tree have been enhanced to allow members to be hidden/shown or designated selectable/non-selectable in a tree on the basis of attributes and attribute expressions. #1850

Fixed Issue: Essbase Selector Tree – When an Essbase Selector Tree is using either an EssbaseDelimitedString or an EssbaseSQLPassthroughDataSet selector list and the selector tree has the BaseMemberNodePolicy set to AddBaseMemberAsDescendantNode, the first branch of members is displayed with the appropriate base members as the leaf nodes, but subsequent based members are not displayed (but rather only the parent nodes are displayed.) #1783

Fixed Issue: Essbase Selector Tree – When multiple selections are allowed and a base member and the related shared members (or only the shared members) are represented in the tree by multiple nodes, and either the user selects multiple occurrences of the member OR the selection defaults to the last used items (and the SharedMembersCheckboxChecked is True), the selector tool displays the member name/alias for each selected occurrence. (This may only be obvious in the tooltip if the SelectionTextMaxCharacters is used to limit the number of displayed characters.) In this release, only unique member strings are presented in the selector tool and tooltip. #1848

Fixed Issue: Essbase Selector Tree – In previous releases, when the selector is configured to allow multiple selections, and the control is opened by the user when the last used item includes a shared member, all occurrences of the shared member are selected when the SharedMembersCheckboxChecked is True. In this release, only the base member or first shared member (if the base member is not represented in the tree) is selected regardless of the value of the SharedMembersCheckboxChecked setting. #1851

Added the ability to save Excel-based views in CSV format using the standard Save As Excel tool. This functionality is introduced in conjunction with the SaveWorkbookAsCSV Workbook Script method, which can be utilized to accomplish the same result. #1790

Relational Essbase outline caching (refer to version 6.3.0.3696)

The EssbaseUserRolesFromGroupNames authentication service under certain circumstances (refer to version 6.2.0.3390).

When the Essbase connection’s ExtendedCubeInfoEnabled is set to true (refer to version 6.3.0.3696).

Essbase Outline Extraction, which is used in conjunction with the Outline Viewer capability also being introduced with this release.

In prior releases, when a metadata instance, such as a View, was created by copying another instance, the CREATED_BY, CREATED_DATE, UPDATED_BY, and UPDATED_DATE fields in the metadata repository database reflected the values for the source metadata instance. For this release, the values for these fields reflect the current date and the current user. #1734

Fixed Issue: When the Search Metadata Properties dialog is open and the Workbook Script Editor is not also open, pasting a value into the search text field results in two occurrences of the pasted value appearing in the field. #1855

Official support for Excel 2013 and Excel 2016.

Support for 50 new Excel 2013 functions as well as the Excel 2010 AGGREGATE function:

Excel 2016 compatible conditional formatting including:

Autofilter by font color, cell color and conditional format icon.

Support for reading, writing, and rendering gradient cell backgrounds.

Enabled multi-threaded recalc for array formulas and worksheet functions which evaluate as arrays (including functions such as SUMPRODUCT).

Improved the performance of copying formulas with 3d cell references, 3d name references and / or addin function references.

Improved the performance of a number of worksheet functions.

Improved the performance of parsing formulas with 3d references which refer to a workbook with a large number of worksheets. This yielded a dramatic performance improvement when reading Open XML workbooks with a significant number of such references.

Enhancement – When connecting to a Microsoft SQL Server database, support has been introduced for the equivalent of WindowsAuthentication authentication mode, where queries for a connection are executed as the Windows user currently logged in. Because all queries are executed on the server, this is accomplished via impersonation. Although the end result is the same, the specified connection user must have impersonate permissions in order to execute queries as the Windows user. This functionality is leveraged by setting the Database to "Microsoft" and the AuthenticationMode to "WindowsAuthentication". #1799

Fixed Issue: When migrating a selector between a Listbox or Combobox and a SQL Tree, an error similar to the following is encountered: The view "<view name> window cannot be initialized. Unable to setup selectors. Unable to initialize selector "<selector ID>". Unable to cast object of type AppliedOLAP.Dodeca.Common.SelectorItemCache" to type "AppliedOLAP.Dodeca.Common.SQLSelectorItemCache. #1789

The MinGenSelectable setting is not applied unless at least one SelectionFilter is defined. #1778

An error similar to the following is encountered when opening a view that uses a SQL selector tree, and the selector is attempting to restore the default selection (with the selector list’s ValidateDefaultSelection property set to True.): "The view "<view name>" window cannot be initialized. Unable to setup selectors. Unable to initialize selector "<selector ID>". Object Reference not set to an instance of an object." #1779

The Import from Excel command fails to restore selections for a SQL selector tree. #1780

Automatically load the test tokens for a SQLPassthroughDataSet from the point-of-view selections of an open view.

From the Workbook Script Debugger, view a resolved query within context (i.e. with tokens replaced) and optionally preview the query results.

Preview Query Results – Opens the Preview dialog, which executes the query and displays the results.

SQL Query Editor Enhancements: Find & Replace and better Token recognition/autocomplete.

The Copy view dialog now supports the ability to optionally copy the source view’s Excel template binary artifact and/or workbook script and automatically associate the new template and/or workbook script with the new view. The copy of the associated metadata is created when the new view is committed. #1372

The Delete view command now supports the ability to optionally delete the view’s Excel template binary artifact and/or workbook script, if applicable. If either an Excel template or workbook script are associated with the view, the Delete View dialog is displayed when the Delete button is clicked. The deletion of the associated metadata occurs when the deletion of the view is committed. #1504

When a new view is created, the WindowsViewUIObjectTypeID is pre-set to the appropriate value based on the view type. For instance, the value is set to PDF for a PDF view type, WorkbookView for all Excel-based view types, etc. #1853

Fixed Issue: When the last leaf node in the View Selector Tree is not a child of a root node, the Find command fails to locate a node that appears in the tree above the currently selected node. #1775

The Workbook Script Editor now allows a value to be pasted into the Name cell in the Property section. #1486

Fixed Issue: The "Trim trailing linefeeds" checkbox at the lower left of the Value Editor dialog does not trim the trailing linefeeds when checked. #1858

New Method – The CopyFromBinaryArtifact method supports the ability to copy a range or a sheet from an Excel template binary artifact to the view’s workbook. This functionality could be achieved previously, but required calling LoadWorkbook, then either CopyRange or CopyWorksheet, and finally UnloadWorkbook. #1662

New Method – The OpenApplication method supports the ability to easily launch a Dodeca Spreadsheet Management System instance with either a ClickOnce URL or the application parameters. When application parameters are provided, the target instance will be launched using the deployment mechanism of source instance. #1803

New Method – The SaveWorkbookAsCSV method supports the ability to save the view’s workbook as a CSV file. The CSV filename and folder may be specified as method arguments or, optionally, the Save File dialog can be presented to allow the user to specify the filename and location. The PreserveLeadingSingleQuotes argument controls whether the leading single quote within a cell, which used by Excel to denote a text value, is preserved or removed from the saved cell values. #1790

New Method Overload – The AddDataCache method has a new overload, EssbaseMDXScript, which allows a data cache to be populated with the results of an MDX query. For instance, the overload can be used to create a set of rows (or columns) with missing data rows suppressed.

New Method Argument – The EssbaseReport method has a new argument, IncludeAttributes, which controls whether an additional retrieve is performed on the server in order to obtain and return member attributes on calculated and member cells. #1655

New Method Argument – The SendEmail method has been enhanced by the addition of the ZipAttachments and ZipCompression arguments. These arguments allow the attachments to be compressed and sent in a .zip archive with the outgoing e-mail. #1795

New Function – The BinaryArtifactExists function allows a workbook script to determine whether a specified binary artifact exists in the metadata database for the current tenant. #1782

@BinaryArtifactExists(<BinaryArtifactID>, [<VersionNumber>])

New Functions – The FirstColumnLetter (@FColL) and LastColumnLetter (@LColL) functions are similar to the FirstColumn and LastColumn functions, respectively, but they return a column letter instead of a column number. #1807, #1811

New Function – The IsSharedView function returns whether the current instance of a View was shared by another user. #1800

Modified Functions: Added an optional AdjustBy argument to the FirstRow (@FRow) and LastRow (@LRow) functions to adjust the returned value based on the specified integer, which either increments or decrements the actual first row or last row, respectively. #1809, #1813

Modified Functions: Added an optional AdjustBy argument to the FirstColumn (@FCol) and LastColumn (@LCol) functions to adjust the returned value based on the specified integer, which either increments or decrements the actual first column or last column, respectively. #1808, #1812

Fixed the following issues with LookupValue Function:

Fixed Issue –– SQLPassthroughExecute Method: When the Transaction argument is False and a SQL exception occurs during processing, an error similar to the following is encountered: Cannot invoke a rollback operation when the AutoCommit mode is set to "true". #1806