Dodeca Version 5.2.0

New authentication service: The WindowsUserRolesFromSqlPassthroughDataSet authentication service supports the ability to retrieve the roles assigned to the current Windows user through a specified relational query, and allow or deny access to the application based on whether query returns any roles for the user. The user’s roles can also be used to determine which view hierarchy or hierarchies are displayed in the view selector by using the view selector’s HierarchyToRoleMapping property. (#863)

The following properties are now supported for the EssbaseUserRolesFromGroupNames and EssbaseUserRolesFromSqlPassthroughDataSet authentication services: AllowStartupForUserAssignedNoRoles, AllowStartupForUserAssignedNoRoles, and MessageCaptionForUserAssignedNoRoles. These properties provide the same functionality as described above for the WindowsUserRolesFromSqlPassthroughDataSet. (#864)

Fixed Issue: The utility was not using the path portion of the specified DeploymentUrl when naming the servlet. It was always creating a metadata servlet named "dodeca.war" regardless of whether a different path was specified.

Fixed Issue: Comments presented as Excel comments were displaying an invalid character at the end of lines when saved to Excel. (#853)

The default value for the CascadeSheetNameMaxLength property has changed from 0 to 31. SpreadsheetGear 2010 enforces the Excel sheet name length limitation, which is 31 characters. Previously, a sheet with a name containing more than 31 characters could be add to a workbook within Dodeca, but could not be opened in Excel. With the change by SpreadsheetGear, a cascaded view that previously built without any errors when a sheet name exceeded 31 characters now encounters an error. By changing the default to 31, these errors are avoided. (#865)

The Import Essbase Connections dialog, which is opened by clicking the Essbase Connection Metadata Editor’s "Import Connections--" button or the Quick Start → Import Connections button, now automatically sets the default Essbase Service URL based on the metadata service path being used by the running Dodeca instance.

Added support for JNDI connections to the Dodeca SQL connections. JNDI is used internally to lookup JDBC connections that are defined on the Java application server tier by system administrators. It allows those administrators more direct control over connection pooling and other tuning on the JDBC connection.

Fixed Issue: When a user manually entered a dialect into the Hibernate Dialect field and then attempted to update the hibernate.properties file, a blank dialect value was added to the file. (#850)

Fixed Issue: When updating the hibernate.properties file, two extraneous entries were being added to the file. These entries were not relevant to hibernate and are no longer being added. (#851)

Fixed Issue: When metadata was being created and inserted into the database, the UpdatedBy and UpdatedDate fields were left blank. If the metadata was subsequently exported without having been updated, the corresponding entry presented in the Export Metadata to Local Zip File dialog did not appear as updated (i.e. the Last Updated Date field was blank) and therefore could not be sorted based on the order in which the metadata was created. (#856)

Fixed Issue: The Page Setup dialog displayed hidden sheets in the list of sheets. (#862)

Fixed Issue: When a DataTableRange’s RetainEmptyLastDataSheetRangeRow is True and the sheet is protected, an "Operation not allowed on protected sheet" exception occurs when the empty last row is edited. (#849)

Fixed Issue: When attempting to writeback to some databases, the following exception occurs: "Unsupported feature" or "Unsupported function" The underlying cause is a limitation in certain JDBC drivers, including Oracle, DataDirect (Oracle), and MySQL, which do not support the ability to obtain parameter types.

Although almost completely compatible with respect to Excel formula support, SpreadsheetGear does not support the following Excel formulas: (#855)

The Workbook Script Editor sets the default name of the procedure in the "Run Procedure" column of the Event Links grid when the cell is activated and no procedure has been previously specified. The default name is "On<event link name>", which reflects the recommended procedure naming convention. The value is automatically selected to allow the default name to be easily changed. (#868)

Fixed Issue: When the Auto Build tool controller built a view in response to a selection change and a workbook script then called the SetSelector method to set a selection during the build, another build was being triggered by the Auto Build tool. (#854)

New Method: EssbaseRunScript runs a script on the server. The script can optionally be executed asynchronously from the client. The method supports two overloads: TextBased and FileBased.

CommandLine — Required. The command line executed on the server. The string can be tokenized, and the tokens are replaced on the client before the script is sent to the server. The value can also contain any of the following variables, which serve as placeholders and are substituted at runtime on the server with the appropriate value:

Filename — Optional. The name of the file executed on the server. For the TextBased overload, the ScriptText is written to the file with the specified name. If the file already exists, it is overwritten. If not specified, the ScriptText is written to a temporary file that is given a unique name. For both overloads, if the Filename is specified, the CommandLine should contain the %filename% variable.

Folder — Optional. The location of the file represented by the Filename argument.

ConnectionID — The Essbase connection ID used to provide the path of the dodeca-essbase servlet as well as any credentials required to run the script. For an Essbase view, the ConnectionID is optional. If not defined, the view’s EssbaseConnectionID is used. For a non-Essbase view, the ConnectionID is requried.

BackgroundExecute — Controls whether the client launches the server request synchronously or asynchronously. If True, the request is launched asynchonously and the view from which the script is executed is disabled until the script is completed and a response is returned to the client. The rest of the application is enabled, which allows the user to open or activate other views, etc.

ScriptTimeout — Optional. The number of seconds allows to ellapse before the script is timed out on the server. The default timeout is 0, which indicates that no timeout is enforced on the server.

Result PropertyName — Optional. The name of the workbook script property that receives the result, which is either True or False, returned to the client.

DetailsPropertyName — Optional. The name of the workbook script property that receives the content of either stdout (if the script succeeds) or stderr (if the script fails) on the server.

CoverDuringExecute — Controls whether the view contents are covered while the script is being executed.

ScriptText — Required. The script text to be executed on the server. The script can be tokenized.

Extension — The file extension appended to the Filename. This argument is only required when no Filename is specified and the server creates a file with a unique name. The extension may be tokenized.

For a procedure assigned to an event link or a procedure called from a workbook script tool controller, the debugger is automatically opened.

For a procedure called from an ExecuteProcedure, ForEach, or CancelEvent method, the debugger is automatically opened when the Continue tool is used to run the script or when Step Into tool is used to explicitly "step into" the method. To prevent the debugger from being automatically opened for the nested procedure, use the Step Over or Step Out tool.

When an ExecuteProcedure or ForEach method is configured with the CellByCell argument set to True, an instance of the debugger is opened for each execution of the procedure within the loop. The cell-by-cell loop can be "stepped out" of, which allows the processing to continue, but without the debugger being opened for each of the remaining executions of the procedure.

With a ForEach method, an instance of the debugger is opened for each NumberToNumber or DataCache iteration. As with the cell-by-cell loop, the for-each loop can be "stepped out" of.

The Method Arguments section presents the arguments for the method currently selected (or active) in the Procedure Methods section. Argument values and comments can be edited, and any changes can be rolled back to the original (or last saved) values. Argument values can be evaluated in place or copied to the Formula Evaluator tab.

In the Procedure Methods section, breakpoints can be added and deleted. The next method can be changed to any method in the list, including a previously executed method. The "last method executed" indicator provides a visual cue as a reference point.

Save Workbook Script — Saves the current workbook script. If any external workbook scripts are called, such as when an ExecuteProcedure’s Procedure is defined in another workbook script, any changes to the external workbook script are also saved.

Save Workbook Script As — Saves the current workbook script as the specified workbook script, which can be either a new or an existing workbook script.

Cover View — Toggles the view cover. Uncovering the view contents allows you to see the effects of the script as you are stepping through the script.

Continue (F5) — Continues executing the methods in the procedure until a breakpoint is encountered or the end of the procedure is reached. When an ExecuteProcedure, ForEach, or CancelEvent method is executed, an instance of the debugger is opened for the executed procedure(s). If the Auto Close button is On, the debugger is closed when the end of the procedure is reached.

Stop Debugging (Shift + F5) — Exits the procedure and closes the debugger. Please note that the procedure does not continue to execute.

Auto Close — When On and when the Continue button is used to run the script or the last method is executed using the Step Over button, the debugger is automatically closed after the procedure’s last method is executed. The Step Out tool ignores this setting and automatically closes the debugger after the last method is executed.

Step Into (F8) — This button is enabled when the next method is ExecuteProcedure, ForEach, or CancelEvent. Clicking the Step Into button opens the debugger for the executed procedure.

Step Over (Shift + F8) — Executes the next method. If the next method is ExecuteProcedure, ForEach, or CancelEvent, the debugger is not opened for the executed procedure. (To open an instance of the debugger for a nested procedure, use the Step Into or Continue button.)

Step Out (Ctrl + Shift + F8) — Continues executing the methods in the procedure until a breakpoint is encountered or the end of the procedure is reached. If the procedure contains an ExecuteProcedure, ForEach, or CancelEvent method is executed, the debugger is not opened for the executed procedure(s). The debugger is automatically closed when the end of the procedure is reached regardless of the Auto Close button state.

Step Out of CellByCell Loop — When the current procedure is being executed from within a ExecuteProcedure method’s cell-by-cell loop or a ForEach method’s cell-by-cell loop, continues executing the procedures within the loop, but does not open an instance of the debugger for each procedure.

Step Out of ForEach Loop — When the current procedure is being executed from within a ForEach method’s NumberByNumber or DataCache loop, continues executing the procedures within the loop, but does not open an instance of the debugger for each procedure.

Toggle Breakpoint (F9) — Adds or deletes the breakpoint for the selected method.

Clear All Breakpoints (Ctrl + Shift + F9) — Clears all breakpoints within the procedure.

Evaluate Formula — Resolves workbook script functions, and if the value is prepended with an "=", also evaluates Excel functions.

Evaluate Expression — Resolves only the workbook script functions within the value.

Evaluate as Address — Evaluates the argument value as an address.

Formula Editor — Opens the Formula Editor for the active argument’s value.

Copy to Formula Evaluator Tab — Copies the active argument’s value to the Formula Evaluator Tab and automatically activates the tab.