Dodeca Version 8.0.0

Default Administrator’s Toolbar - The application toolbars configuration used when an application’s UseDefaultAdminToolbarsConfiguration property is True has been revised. In previous versions, the Admin menu contained the metadata editors as well as various utilities. The Admin menu has been replaced with the Metadata Editors and Admin Utilities menus. #2599

By default, dragging a tabbed window in the main application window moves the tab to a new tab group or an existing tab group. To enable the ability to drag a tabbed window to a floating window, the Drag Tabbed Windows as Floating option in the Window menu must be checked.

A tabbed window can be floated by 1) dragging the tab with the left mouse button when the Drag Tabbed Windows as Floating option is checked, 2) double-clicking the tab, or 3) using the Float tool from the view or metadata editor context menu.

A floating window can be moved to the active tab group in the main application window by 1) clicking the floating window caption with the left mouse button and dragging the cursor to the position indicator at the center of the application window, 2) double-clicking the floating window caption, 3) using the Move to Active Tab Group in Main Window tool from the context menu.

Only one window, either tabbed or floating, is active at any time. When the active window contains a view, the application toolbars reflect the mergeable toolbars of the view.

A Workspace Layout cannot contain floating windows. If attempted, the Save Layout as File and Save Layout as Binary Artifact tools inform the user that all floating windows must be moved to a tab group or closed before the layout can be saved.

Fixed Issue: The Application Metadata Editor allows special characters, such as the percent sign "%", to be included in the application ID. The use of these characters results in an error and prevents the application from being run. #963

A new tool, Export All Excel Files, in the Binary Artifacts Editor supports the ability to export all the Excel files that are stored as binary artifacts to a selected folder. #2495

In 8.0, committing a binary artifact, which does not contain an imported file, to the database is not allowed. If an commit is attempted, the following error is displayed: The binary artifact "<binary artifact ID>" does not contain an imported file. An empty binary artifact cannot be committed to the metadata database. After importing a file, retry the commit. #2624

In previous versions, when the metadata repository is an Oracle database, and the user attempts to commit a binary artifact, which does not contain an imported file, an error similar to the following occurs:

Delimited String Cascade Source - Essbase Excel and SQL Excel views support the ability to cascade based on the selections of one or more POV selectors. In addition, Essbase Excel views support the ability to cascade based on the results of an MDX query. #2737

In 8.0, when a view’s cascade Source Type is EssbaseMdxScript, the Script ID can be tokenized, which allows for the MDX script used for cascading to be determined at runtime. #2723

In the View Metadata Editor, when a view’s cascade Source Type is EssbaseMdxScript, the context menu for the CascadeSources property supports the ability to navigate to the MDX script in the Essbase Scripts Editor. #2734

Server-side Performance Enhancement: As the result of optimized SQL query algorithms implemented in the Dodeca Server, the loading of comments is often significantly faster than with previous versions, and is most noticeable when a large number of comments is retrieved. #2371

Additional properties have been added to the CommentRange definition, which is used by Excel and ExcelEssbase views to configure the various settings that control the location, behavior, and appearance of related commentary. The new properties, KeyItemsColumnRange and KeyItemsRowRange, facilitate the use of Excel formulas on the sheet to construct the key items string for each cell within a comment range. The key items string is used to uniquely identify the comments associated with a given cell. It is a concatenated string of semicolon delimited key/item pairs, such as Measures=Sales;Market=New York;Product=Cola;Year=Jan;Scenario=Actual.

The Comment Range Editor assists with the creation of the key items formulas in the KeyItemsColumnRange and KeyItemsRowRange, as described in the previous section, as well as with the configuration of other comment range settings. The editor is opened from the Home tab in the View Template Designer. #2542

The CommentsEnabled property, which has been added to the Excel and Essbase Excel view types, controls whether the comments are loaded when the view is built. As noted in the property description, this setting is applied to all the comment ranges, and is typically used for development/debugging purposes. #2625

Comment Audit Log - Comment audit logging is supported in 8.0 to provide the ability to track comment changes, including inserts, updates, and deletes. By default, comment audit logging is not enabled in a deployment. To enable, the dodeca.comments.audit-logging setting should be set to true in the dodeca.properties file. #2647

Fixed Issue: When a view is refreshed by using the Refresh View tool after a selector’s selection is changed, the on-sheet comments are not cleared from the cells when there are no persisted comments for the newly selected item. #1399

Fixed Issue: Comments are deleted after an existing comment is edited in a cell and then another comment is edited in the Comments Explorer and the Save button is then clicked. #1706

Fixed Issue: When the Comments Explorer is used to add or change comments, and the user subsequently attempts to build the view without saving the comments, a warning is displayed that unsaved changes exist, but the user is not given the option to save the comments. #2674

Fixed Issue: When a comment range contains multiple cells which represent the same unique comment key and a comment is entered for one of the cells, either directly into the cell or in the Comments Explorer, the other cells are not automatically refreshed to display the comment. #2675

In 8.0, the order in which named retrieve and send ranges on a given sheet are processed has changed and is based on the natural order instead of the ascii or alphabetical order. The name of a retrieve or send range must be of the format Ess.Retrieve.Range.X or Ess.Send.Range.X, where X is a unique identifier and is typically a number by convention.

In 8.0, when an Essbase Excel view is cascaded and the cascade source is MDX, additional tokens are created for each cascade item (i.e. each member returned by the MDX query) within the context of a given cascade sheet. These include a token to represent the member name and another for the alias. For example, if the cascade source defines the token as [T.Year] and the alias table as Long Names (in the Sample.Basic database), and the member is Jan, the additional tokens are [T.Year.Name] and [T.Year.Alias] with the values Jan and January, respectively.

Ancestor On Top - Essbase 19c supports the ability for a user to set whether ancestors are positioned at the top or the bottom of related child members in the results of a zoom operation. #2493

For an ASO cube, the Member Select dialog no longer includes the Attribute Calculation dimension in the Dimension dropdown list. ASO cubes only support the Sum attribute calculation. #2458

Fixed Issue: The Member Select dialog, which is typically used only in an Essbase Ad hoc view, fails to complete the expansion of a parent member in the tree when the parent has a significantly large number of child members, such as several hundred thousand. #2393

The Essbase service no longer supports Essbase Peformance Logging. To reflect this change on the client, the default Administrator toolbar’s Utility menu does not include the Log Essbase Performance to Server options and the DoEssbasePerformanceLogging property is not displayed for an Essbase connection in the Essbase Connections Editor. #2448

The Depends On and Depended On By tools have been added to the Essbase Scripts Editor. #2745

In previous versions, when the value of the GridContextMenuID, GridContextMenuIDForDrillthroughSheet, or SheetContextMenuID property of an Excel, SQL, or any Essbase view type is not valid, no error message is displayed. The property value can be assigned either in the view’s metadata or by a workbook script in the RequestContextMenuID and RequestSheetContextMenuID event links. To be valid, the ID must be the key of a PopupMenuTool in the view’s toolbars configuration, i.e. ViewToolbarsConfigurationID. #2688

Auto-Complete - In Excel, when the user is typing into a cell, the auto-complete functionality attempts to anticipate what the user is intending to type and automatically matches existing values within the same column and fills in the cell value based on the closest match. This allows a value that has previously been entered to be subsequently entered without completely retyping the value. Alternatively, the user may pick the value from a dropdown list, which is similar to, but not the same as a data validation list, which does not find matching items when the user is typing. #2708

Tab Ratio: A new property, TabRatio, has been added for Excel, SQL Excel, and Essbase Excel views. The value controls the ratio of the width of the worksheet tabs to the width of the horizontal scrollbar as a number between zero and one. By default, the value is .6.

Fixed Issue: Using conditional formatting, when the Format Style is set to Icon Sets and the Type to Percentile, all the cells display the icon associated with the lowest value. #2266

Fixed Issue: When an Excel, SQL Excel, or Essbase Excel view is configured with the AutoCalculateEnabled property set to True, the computed values displayed in the status bar are inaccurate when any cells in the selected range contain the SUBTOTAL formula. #1511

Excel Workbook (*.xlsx) and Excel 97-2003 Workbook (*.xls)

Excel Macro-enabled Workbook (*.xlsm)

CSV (Comma-delimited)(*.csv)

All files (*.*)

Optimized the scanning of binary artifacts when searching for Depended On By dependencies. #2614

When searching for Depended On By dependencies and an error is encountered on the server when analyzing a binary artifact, the error is presented in the Metadata Dependency Explorer below any dependencies. At present, the only anticipated error will occur when an Excel binary artifact contains an encrypted (i.e. password-protected) file, since an encrypted file cannot be analyzed. The Excel binary artifacts are only analyzed when a Depended On By search is performed for an Essbase connection. #2666

Fixed Issue: The workbook script methods, CopyFromBinaryArtifact.Range, BuildRangeFromScript.ImportRange, and OpenBinaryArtifact.General, require the specification of an Excel binary artifact ID. The VersionPolicy argument indicates whether the latest version or the specified version should be used by the method. If no value is specified, the default is Latest. If the value is Specific, another argument indicates the specific version.

Fixed Issue: When the Log Application Request and Response XML to Server is enabled, the Metadata Dependency Explorer displays the following error when searching for Depends On dependencies: The search failed with the following error: Root element is missing. #2510

Several of the metadata editors have always supported the ability to filter the metadata items based on a type. For instance, in the View Metadata Editor, the views can be filtered based on view type to show only those views of the selected type, such as ExcelEssbase. #2556

The Application, View, and View Property Set Metadata Editors allow for the metadata instances to be displayed by the ID or the Name. By default, the Name is displayed. In previous versions, this setting was not retained across sessions, so if an administrator prefers to see the ID, the ID button would have to be clicked each time the editor is opened. In 8.0, the setting is retained and restored. #1562

In previous versions, the only option supported by the metadata editors for committing new, modified, or deleted metadata instances was to commit all the changes to the metadata repository at once. In 8.0, it is possible to commit only the selected metadata instance. For instance, this screenshot of the View Metadata Editor shows the Commit Selected and Commit All tools. #2160

Fixed Issue: In the Metadata Editors, items are not sorted based on the natural order. For example, in the Binary Artifacts Editor and the Essbase Outline XML Binary Artifacts Editor, when all versions are displayed and include, for example, Version 1, 2, and 10. This also occurs when ID’s or names contain numbers, such as View1, View2, and View10. As such, Version 10 and View10 should appear in the list after Version 2 and View2, respectively. #2558

Imported Date and Imported By - In addition to the Created Date, Created By, Updated Date, and Updated By fields that are maintained for metadata binary artifacts, additional fields have been added to retain the most recent date and identity of the import of a binary artifact. #1496

An AutoBuildOnOpen tool argument has been added to the OpenViewForDataCellToolController and OpenViewForMemberCellToolController tool controllers. By default, the value is Default, which indicates that the opened view’s AutoBuildOnOpen setting should be used. If the tool argument is set to True or False, the opened view’s AutoBuildOnOpen setting is overridden and the specified tool argument value is used. #2499

A ShareSelectorTokens and a ShowViewAsActiveWindow tool argument has been added to the following Open View tool controllers:

When a SQL view with a long-running relational query is building, the user is able to perform another task in the application, such as activating another window, since the query runs in the background. In previous versions, upon completion of the build, the window with the long-running query would automatically become activated. In 8.0, the window is not automatically activated in order to allow the user to continue uninterrupted with the current task and then decide when to change the active window. #1826

Fixed Issue: In SQL views and (the relational functionality in) Essbase views, when primary keys are entered by the user into a data table range on the sheet, duplicate primary keys are not detected on the client when a save is attempted. #2563

An AttributesPolicy property has been added to the ScriptEssbase view type. The property controls whether the server performs a retrieve on the results returned by the script in order to obtain attributes for the member and data cells, which are then returned with the results to the client. By default, the value is set to NoAttributes. #2308

Added support for the ability to navigate from a selector list in the Selector List Metadata Editor to the associated SelectorID in the Selector Metadata Editor. #1975

Fixed Issue - When the SelectorControlProperties.ItemsSorted is True for the selector list associated with a SelectorListBox, the items are sorted, but items containing numeric characters are not sorted in natural order. In 8.0, items are sorted as shown in the image on the right. #2663

ExpandSharedParent - A shared parent member is a shared member whose associated base member has children. In the Essbase selector treeview, a user is able to expand the node representing a shared member parent to view the descendants of the base member. The behavior is optional and is controlled by a new property, ExpandSharedParent, which has been added to the SelectorControlProperties for an EssbaseSelectorTreeView selector list. #2700

In previous versions, the view SelectorLastUsedItemContext property supports the following options: None, ByView, BySelector, and ByLabel. The property controls the caching of the item(s) selected when the view is built or refreshed. The cache is used to determine the default selected item(s) for the selectors whose selector list has a DefaultSelectionPolicy of LastUsedItem. For example, if the SelectorLastUsedItemContext is ByView, the default selections reflect the last used items for the most recently built instance of the same view.

In previous versions, when the selector list assigned to a selector has a DefaultSelectionPolicy of LastUsedItem and the selector list is used by selectors configured with both of the Selection Policy options, which include SingleItem and MultipleItems, the default selection is not retained for the selector when switching from a view with a Selection Policy of MultipleItems to a view with a Selection Policy of SingleItem.

Use of the Shift and Control keys

Use of lasso selection, which allows a dragging selection for multiple items. The drag operation is initiated by clicking the left (primary) mouse button on an item and then moving the cursor over other items while continuing to press the mouse button.

Using the left mouse button, click the checkbox by one of the highlighted items, which toggles the check state for the item and also sets the check state of the other highlighted items accordingly.

Use the space bar to toggle the check state of the active item, which also sets the check state of the other highlighted items accordingly.

The search tool is activated either by clicking with the mouse or by using the Ctrl+F shortcut keys. The selector control must be active for Ctrl+F to activate the tool.

The specified string is applied as each character is keyed in and is based on whether the Starts with or Contains option is selected.

When the search tool is active, pressing the Enter key exits the tool and saves the specified text to a list of most recently used search strings, which is available in a dropdown list. The list contains a maximum of the 10 most recently used strings, and is persisted across sessions.

When the search tool is active, pressing the Escape key clears the search string and exits the search tool.

If the selector is configured to allow multiple selections, the Select All and Clear All buttons select or clear only the items shown (i.e. the filtered items.)

For the EssbaseSelectorListBox, after a search is applied, toggling the Show Names / Show Aliases option does not clear the results, which allows for filtered member names to be viewed as aliases and vice versa. For example, after searching for cola with the Show Aliases option enabled, Show Names was then enabled.

When the Alias table is changed, the items are refreshed and the search is reapplied.

The Sign On and Set Active Essbase Connection tool, which is typically used with an Essbase Adhoc view, has been modified to automatically attempt to sign on when the Sign On control is opened and credentials already exist for the view’s login service. If successful, the hierarchy of server(s), applications, and databases is displayed. This prevents the user from having to specify the credentials again. #2494

Database Transactions - The ability to execute a query’s insert, update, and delete statements in a transaction is supported in 8.0. The use of transactions is controlled by the query’s UseTransactions property. The property is set in the Query Editor, which is accessed from the SQL Passthrough DataSet Metadata Editor. #2436

The Query ConnectString property, which was used in pre-5.0 Dodeca versions to specify connection information using Hibernate syntax, was deprecated in Dodeca 5.0, when the SQLConnectionID property was introduced. Support for the ConnectString property was eventually phased out, but continued to be presented in the Query Editor. In 8.0, the property is no longer presented in the client. #2725

Fixed Issue: When a SQL Passthrough DataSet properties are Categorized, each category can be collapsed or expanded. The categories include Information and Misc. When the Query Editor is opened, and a Query is selected, the expanded/collapsed state of the Misc category in the SQL Passthrough DataSets Metadata Editor, if different, is changed to the expanded/collapsed state of the Misc category in the Query Editor when the Query Editor is closed. #2658

Built-in toolbars, including the Essbase View Template Designer, Excel View Template Designer, PDF View, and Outline Viewer View.

View status icons, which appear on the view tabs and in the status bar:

Metadata Editor status icons, which indicate whether a metadata instance is new, edited, or deleted:

Shared view icons, which are displayed in the View Selectors to indicate whether a shared view is shared with noone, everyone, or specific people:

Various other dialogs, such as the Workbook Script Debugger:

Starter Kit toolbars configurations, such as the following:

Fixed Issue: When the last leaf node in the hierarchy 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. #2526

Fixed Issue: When there is only a single root node, the Find command fails to locate a node that appears in the tree above the currently selected node. #2526

Automatic Refresh: A view metadata instance can be changed and saved from the View Template Designer by assigning a different version of the template to the view or (in 8.0) by using the Comment Range Editor to edit the comment ranges. If the View Metadata Editor is open when a change is committed from the designer, and the View Metadata Editor is subsequently activated by the user and the modified view is the selected view, the properties are automatically refreshed to reflect the saved changes. #2586

In Version 7.5.0.6430, support was added for the ability to select a defined range name from a dropdown list in the DataTable Range Editor for the DataSheetRangeName and DataBlockSheetRangeName properties and in the RowSortAndGroupByInfo Editor for the GroupTemplateSheetRangeName property. #2662

Fixed Issue: When the view properties are Categorized, each category can be collapsed or expanded. For a view that supports a CommentRanges property, one of categories is Behavior. When the Comment Range Editor is opened, and a Comment Range is selected, the expanded/collapsed state of the Behavior category in the View Metadata Editor, if different, is changed to the expanded/collapsed state of the Behavior category in the Comment Range Editor when the Comment Range Editor is closed.

Fixed Issue: When multiple views have very similar ID’s, which contain a percent sign (%), such as Ops Costing as a % of Sales and Ops Costing as % of Sales, attempting to select Ops Costing as % of Sales in the View Metadata Editor results in the following error: #2454

In previous versions, for both the ViewSelectorExplorerBar and ViewSelectorTree, the Edit Excel Template option is displayed on the context menu when the ViewSelectorProperties.AllowEditViewMetadata property is set to True. The option opens the Binary Artifacts Editor and sets the Excel template’s binary artifact instance as the active instance. To decouple this option from the AllowEditViewMetadata property, the AllowOpenExcelBinaryArtifactEditor property has been introduced, which now controls whether the Edit Excel Template option is displayed on the context menu. #2481

When a view selector’s AllowEditViewMetadata property is set to True, an Edit toolbars configuration item is added to the context menu to allow the user to navigate from a view in the view selector to the view’s associated toolbars configuration, as defined by the ViewToolbarsConfigurationID property, in the Toolbars Configuration Editor. #2525

A new setting, AllowOpenViewHierarchyEditor has been added to the ViewSelectorExplorerBar and ViewSelectorTree to allow an administrator to navigate from a view in the view selector to the View Hierarchy Metadata Editor and, when possible, to the corresponding view item in the appropriate hierarchy. #2482

In previous versions, when the Find dialog, which is used in the ViewSelectorTree, is initially opened, the Match case and Match entire name options are checked. In 8.0, the options are not checked. In all versions, the checked status of Search for and Options are cached and then restored when the dialog is subsequently opened within the same session or another session. #2822

Cut, Copy, Paste, and Format Cells options have been added to the context menu in the View Template Designer. #2762

Fixed Issue: Under certain conditions, in the View Template Designer for an Essbase Excel view, the Undo and Redo Ad hoc Operation tools do not become enabled when an Essbase operation is performed and the Undo/Redo Enabled option is checked. This occurs when 1) the view’s EssbaseConnectionID is set, 2) the active sheet does not contain named retrieve ranges with associated named connections, and 3) the Sign On and Set Active Connection control is not used to connect explicitly. #2429

The View Template Designer toolbars have been replaced with a ribbon. The Home tab is displayed as the active tab when the designer is opened. #2466

When the view template is saved, a confirmation is displayed in the status bar. #1506

The Double-Clicking and Secondary Button mouse tools have been added to the Essbase View Template Designer ribbon. The tools function similarly to the equivalent tools in the Dodeca Excel Add-In for Essbase, and allow the user to control whether mouse actions, such as double-clicking, perform an Essbase operation instead of the default Excel behavior. #1491

All links can be removed or only orphaned (unused) links.

All custom properties can be removed. Custom properties are inserted by SmartView to store information, including retrieved data, in the workbook. If the workbook was previously used in SmartView, these properties likely exist and inflated the the size of the original workbook.

All custom styles can be removed. A workbook may have been the target of an Excel macro virus years ago, which generated potentially thousands of custom styles. If the analysis report indicates an unreasonably high number of custom styles, the workbook was likely a target of the macro.

All defined names containing an invalid reference (#REF! error) can be removed.

The Remove from where option represents a text string used to filter and select the names to be removed based on criteria related to the Name, Visible, Scope, and RefersTo values listed in the Range Names section of the analysis report. The syntax of the string is similar to a SQL WHERE clause, and is documented in the Syntax Help task pane.

Workbook Script Reference View - In 8.0, a view can be associated with a workbook script. The referenced view’s Excel template is then used to populate dropdown lists for the selection of sheet names and range names, as well as to show the workbook’s color palette in color pickers. The view’s properties are used to populate DataSetRangeName selection lists.

For all method arguments that represent an Excel color index, the dropdown list of index values presented in the editor has been changed to include both the index number as well as the color name represented by the index. #2459

The Find/Replace functionality has been refined and the dialog has been replaced with a dockable control. #2175

Automatic Refresh: A workbook script can be changed and saved from the Workbook Script Debugger. If the Workbook Script Editor is open when a change is committed from the debugger, and the Workbook Script Editor is subsequently activated by the user and the modified workbook script is selected, the editor is automatically refreshed to reflect the saved changes. #2586

Changing a method: In previous versions, once a method is selected from the dropdown list, the dropdown list is no longer available, and the method cannot be changed. If the wrong method was selected, the method must be deleted and a new method added, and then the intended method selected from the dropdown list.

Missing Workbook Script Methods: On occasion, a customer has a requirement for workbook script functionality, such as a method, that is not supported in the framework. With the Dodeca extensibility model, we are able to make the functionality available by providing a module, which contains the implementation assembly and configuration files. The module can be imported as metadata. Once the module is imported into the tenant, the custom method is available for use. When the Dodeca framework is subsequently upgraded, the components must also be upgraded.

Expand All Procedures Tool - In previous versions, the tool used to Expand all procedures and all of their methods was only displayed in the toolbar when the Procedures grid had the focus. In 8.0, the tool is always displayed to allow for expanding the procedures and methods regardless of which grid has the focus. #2715

Fixed Issue: In the Workbook Script Editor, if a column header is clicked in the Procedures control, and then another column header is clicked to sort the column, the following error occurs: grdProcedures_BeforeSortChange failed with the following error: Key not found, Parameter Name: key. #2462

Fixed Issue: In the Formula Editor dialog, the mouse scroll wheel does not work when attempting to scroll the dropdown list of Functions. #2043

Fixed Issue: When the Workbook Script Editor is in the mode where the active method’s arguments are displayed on the side, methods that have been disabled are not formatted to reflect the disabled status (i.e. grayed out.) #2542

Fixed Issue: When the Hide empty arguments button is used, checkbox arguments do not become hidden when they have previously been checked and then unchecked. And, if the active row represents an empty argument, the row stays active when hidden. #2698

In previous versions, method arguments could be sorted by clicking the sort dropdown arrow button located on the right side of the Argument header. Once sorted, which typically occurs by accident, the arguments cannot be restored to the default order. The dropdown arrow button has been removed. #2797

A Workbook Script Set supports the ability to associate multiple workbook scripts, which are executed at run-time in a pre-defined order. By design, each workbook script contains a Workbook Script Set, which consists of itself as the Main workbook script, and to which other workbook scripts can be added.

Workbook Script Method Exception Dialog - In previous versions, workbook script error messages were presented in a message box. To provide a better user-interface for identifying and resolving workbook script errors, the message box has been replaced with the Workbook Script Method Exception dialog, which presents the error message and related workbook script information in a more readable and understandable format. #2754

Workbook Script Trace Logging - The workbook script trace logging capability has been improved and enhanced. In previous versions, trace logging was enabled for a workbook script through the DoTracing setting in the script definition. This setting has been removed, and trace logging is controlled instead through the Utilities menu in the Admin application main toolbar. #1598

Workbook Script Deprecation - It is sometimes necessary for a workbook script element (including functions, event links, methods, method overloads, and method arguments) to be deprecated in order to discourage the use of the element. This is typically due to an issue or behavior related to the element, which cannot be fixed because of the potential impact on existing workbook scripts. To address the underlying issue, a new element is usually introduced, such as a new method argument, which corrects the flawed behavior. #2229

New Event Link: The AfterCascadeSummarySheetBuild event link can be used to execute a workbook script procedure after a summary sheet is built for a cascaded SQL or Essbase Excel view. The creation of a summary sheet for a cascaded view is controlled by the view’s SummarySheetAdd or CascadeSheetConfig properties.

New Event Links: In addition to the existing ClipboardPasting and ClipboardPasted, event links have been added for clipboard cutting and copying, including: ClipboardCopying, ClipboardCopied, ClipboardCutting, and ClipboardCut. The ClipboardCopying and ClipboardCutting events can be cancelled by using the CancelEvent method.

New Event Links: The BeforeDataSetRangeBuild and AfterDataSetRangeBuild event links be used with a SQL or Essbase Excel view, and occur before and after a data set range is built. The event properties include DataSetRangeName, DataSetID, and SheetName. #1581

New Event Links: The BeforeDataSetRangesSave and AfterDataSetRangesSave can be used with a SQL or Essbase Excel view, and occur before and after all the view’s data set ranges are saved. The BeforeDataSetRangesSave event can be cancelled using the CancelEvent method. #2402

New Event Link: The CommentExceptionOccurred event link allows a workbook script to handle a failure when comments are loading, saved, etc., which is primarily caused by a network connectivity issue. The event has an Exception event property. #2476

New Event Link: The BeforeAutoCompleteRangeListLoad can be used in conjunction with the AutoCompleteRange functionality to customize the list of cell values for the active cell within the context of other cell values. The event occurs before the list of cell values is generated or loaded from the list source. #2784

New Function: The IsValidRange function returns True/False to indicate whether the specified value can be resolved to a valid range address. #2686

New Function: The Evaluate function returns True/False to indicate whether the specified value can be resolved to a valid range address. #2686

New Function: The TimeZoneInfo function returns the value of the specified property of the local timezone. #2277

Fixed Issue: Any function that has multiple string arguments fails with a Missing argument(s) error when the function is called with multiple strings arguments enclosed in double quotes. #2555

Fixed Issue: For the following functions, when the Address argument value is qualified with a sheet name, such as Sheet1!$A$1, an Invalid range reference error occurs: CellFillColor, CellIsHidden, CellIsLocked, Checksum, ColumnWidth, CommentPropertyForCell, ExcelComment, HasExcelComment, IsDataCell, IsMemberCell, and any of the DataPoint and MemberCell functions. #2696

Fixed Issue: The following error occurs when the CommentPropertyForCell function is called and the CellAddress property is an invalid cell address: Object reference not set to an instance of an object. #2696

Fixed Issue: The help for the ReplaceTokens function did not include the Text argument. #2696

The @RangeContainsRange(<Range1>, <Range2>) function returns FALSE when either of the specified ranges does not exist. In previous versions, the function returned a blank. #2804

In 8.0, the CallWebService, OpenApplication, and Process methods are supported as Workbook Script Extensions instead of as built-in methods. Because there is a potential security risk associated with the use of these methods, the availability of the methods requires the explicit inclusion of the extensions either by importing as a module into each tenant, or by including as a component in the deployment. The module can be imported from the wbs_extensions.zip, which is installed in the DodecaFramework metadata folder. The component can be included when creating the deployment in the ClickOnce Prep Utility, which is the recommended approach. #2648

The AddDataCache.SqlScript overload, BuildRangeFromScript.SqlScript overload, and ExecuteSqlTransaction are no longer supported. #2566

Fixed Issue with AddDataCache Method: When the EssbaseMembersPerGeneration overload is used to add member information to a data cache, member information from the level that matches the given number or name is returned instead. #2680

For the SetBorders, SetConditionalFormat, SetFill, and SetWorksheetOptions methods, a color RGB argument has been added for all existing arguments that accept an Excel color index, but not a specific color. For example, SetBorders has a TopColor argument, which specifies an Excel color index. A TopColorRGB argument has been added to allow for specifying the color as an RGB value instead of an Excel color index. #2460

A new argument has been added to the EssbaseSend method: The UseMemberNamesAndAliasesForRows argument controls whether members names and aliases are used for row dimensions. The argument allows for overriding the view’s UseMemberNameAndAliasesForRowDimensions setting, which is used when the argument value is not specified. The argument is primarily used when multiple send ranges exist, and require a different value for the setting. #2637

In 8.0, a SQLDataCache overload is supported for the ForEach method, which is used in conjunction with a data cache created using the AddDataCache method’s SQLPassthrougDataSet overload. The SQLDataCache overload allows access to each column value of the current row from within the procedure called by the ForEach method. The value of a given column for the current row is available in a workbook script property, which has the same name as the column. #2449

New Method: The CommentOperations method, Load overload, can be used to reload comments or to load the comments for a comment range, which has the LoadPolicy set to None. #1415

New Method: The SetDataTableRangesModificationTracking method allows for a workbook script to control whether changes to cell values in existing rows in a data table sheet range are subsequently detected as unsaved changes when the view is rebuilt or closed.

New Method: The SetEssbaseSendRangeModificationTracking is used to enable or disable modification tracking for Essbase send ranges by setting an Essbase view’s SendRangeModificationTrackingEnabled run-time property. #1591

New Method: The Wait method pauses the execution of the current procedure for a specified number of seconds using the General overload or until a specified condition is met using the 'Until' overload. #2279

New Method Overload: The SetBorder method has a new LineStyleSG overload. The overload addresses a limitation with the support of Excel line styles by the SpreadsheetGear control, which can only render the Excel line styles None, Continuous, and Double. The Excel line styles Dash, DashDot, DashDotDot, Dot, and SlantDashDot are rendered as Continuous. All Excel line styles are maintained and displayed correctly when the workbook is viewed in Excel.

New Method Overloads: The CopyRange method has two new overloads. The ToClipboardAsImage and ToFileAsImage overloads copy a range to the clipboard or to the specified file as an image. #2228 +

New Method Argument: A ShowViewAsActiveWindow argument has been added to the OpenView method to support the ability to control whether the opened view’s window becomes the active window. #2613

New Method Arguments: Several arguments have been added to the SendEmail.SMTP method overload to support the ability to include a snapshot of a range or ranges from the view in the email. #2223

New Method Argument: A Cut argument has been added to the appropriate CopyRange method overloads to allow the method to perform a cut operation and automatically clear the copied cells. #2527

New Method Argument: A StatementMessagesSheetName argument has been added to the EssbaseRunMaxl method. The existing MessagesSheetName argument is the name of a worksheet, which is added to the current view and will contain the messages generated by the execution of MaxL script that are not related to any specific statement. The StatementMessagesSheetName argument is the name of a worksheet, which will contain the messages related to the execution of a single statement. If the script contains multiple statements, then a sequentially numbered sheet will be added for the messages generated by each statement. In previous versions, the messages related to a given statement were written to the sheet containing the statement results, which is specified by the ResultsSheetName argument. #2451

New Method Argument: A TabRatio argument has been added to the SetWorkbookOptions method. The argument value controls the ratio of the width of the worksheet tabs to the width of the horizontal scrollbar as a number between zero and one. For example, if set to .75, the width of the area for worksheet tabs is 75% and the width of the scroll bar area is 25% of the total width of the view window. By default, the value is .6. #2206

New Method Arguments: For the SetUDA.RemoveFromMember method overload, new arguments have been added to support the ability to control whether the removal of the specified UDA’s continues after an error is encountered on the server when a given UDA (in the delimited string of UDA’s) is not valid for the member. #2211

New Method Argument: An OutputRangeName argument has been added to method overloads that import or copy a range. These include the following: CopyFromBinaryArtifact.Range, CopyRange.FromFile, BuildRangeFromScript.ImportRange, and BinaryArtifactOperations.ImportRange. #2348

New Method Argument: The DataCache functionality has been enhanced to allow for non-unique or duplicate key values. An AllowDuplicateValues argument has been added to all the AddDataCache method overloads. The argument controls whether the value of the first column in each row in the data cache must be unique. If not specified, the argument value defaults to False. #2343

New Method Argument: A ShareSelectorTokens argument has been added to the OpenView method. The argument controls whether the current view’s selector tokens are added as tokens to the opened view. When added, the tokens are used to set default selections, when applicable, and can be referenced in workbook scripts, SQLPassthroughDataSets, etc. as used by the opened view. #1752

Deprecated Method Argument (and New Method Argument): The EssbaseReport method IncludeAttributes has been deprecated, and a new argument, AttributePolicy, has been added. #2308

Revised Method Argument Description: The SQLPassthroughExecute method description was revised to avoid a potential issue when a statement contains a semi-colon and the StatementDelimiter is not specified as a non-semicolon character. The method description:

Fixed Issue with SetHidden Method - With the Worksheet overload, the address of the selected cell is used instead of the specified Address argument as the basis for evaluating the Hidden argument. For instance, if A1 is the active or selected cell on the sheet and is empty, and the Address argument is C3 and contains TRUE, the sheet does not become hidden when the Hidden argument is =@ACell()=TRUE.

Fixed Issue with BinaryArtifactOperations Method - With the CreateFromFile overload, a .xlsx extension is added to the specified filename, which results in an error similar to the following: Could not find file c:\Users\Administrator\Documents\MyTextFile.txt.xlsx #2537

Fixed Issue with SetSelector Method: When a view’s Auto Build tool is turned On and the view’s workbook script uses the SelectorSelectionChange event to call SetSelector to set the selection for another selector, the following error occurs: Object reference not set to an instance of an object. #2442

Fixed Issue with SetWorksheetOptions Method: When the method is used to rename a worksheet in an Essbase Excel view, any Essbase-specific functionality that is dependent on the internal representation of the Essbase data on the sheet does not function as expected. #2778

Fixed Issue with AddDataCache Method: With the EssbaseMdxQuery overload, when members in the column axis contain invalid XML characters, an error similar to the following occurs: Unable to send the request. Name cannot begin with the '0' character, hexidecimal value 0x30, Line 1, position 790. #2240