Support for PDF
We have added native capability to write data in a grid or Excel based Dodeca view directly to a PDF file. The output PDF file is PDFA-1b compliant. Additionally, the generated PDF file can be opened locally in a Dodeca WebBrowserView or externally in the default PDF viewer. We have also added programmatic support for PDF by way of the SaveWorkbookAsPdf method (or "action") and the BeforeSaveAsPdf and AfterSaveAsPdf event links.
|Dodeca SQL Excel View Rendered as PDF (click to enlarge)|
|CopyComments Workbook Script Method (click to enlarge)|
Support for Adding and Removing UDAs
User Defined Attributes are often used to mark Essbase members for special usage in an Essbase application. This new functionality provides a new workbook script method, SetUDA, with both AddToMember and RemoveFromMember overloads. The workbook script method allows an adminstrator to include functionality in an application to add, or remove, one or more UDAs from one or more Essbase members in a single call to the server. Of course, with any workbook script, the functionality may be attached to a toolbar button, menu item or context menu item to make it easy for users to complete the task.
Improvements Working with Stored Procedures
In a Dodeca SQLPassthroughDataSet object, the select, insert, delete, and update statements defined for the object can be defined to execute a stored procedure. Here is an example of a typical stored procedure:
Inside Dodeca, we take the SQL statements, parse them, and create prepared statement objects. In this process, we also modify insert SQL on the fly to eliminate columns for which there is a parameter defined,
but which do not have a parameter passed for the record. We did this to allow for database default column values to be returned after an insert statement. Nice feature and I had just bunches of fun writing that one! It works very well except, for stored procedures, arguments are typically required (vs. SQL which is very flexible). We have changed the behavior of an insert when we detect a stored procedure to not modify the SQL.
Other New Workbook Script Events
BeforeDataTableRangeAddRow / AfterDataTableRangeAddRow - Occurs before / after a row (or rows) is added to a DataTableRange either by a user adding/inserting a row(s) or when an empty row is automatically added.
BeforeDataTableRangeDeleteRow / AfterDataTableRangeDeleteRow - Occurs before / after a row (or rows) is deleted from a DataTableRange.
Other New Workbook Script Methods
SaveDataTableRangeRow supports saving the changes to a specified row within a DataTableRange. The row can be an added (or inserted) row or a modified existing row.
Other New Workbook Script Functions
The DataTableRangeRowHasChanges function returns True or False based whether a row within a DataTableRange contains unsaved changes, which includes a new row and a modified existing row.
The DataTableRangeRowState function determines whether a row was Added, Modified, or Unchanged.
This is a summary of some of the new things in the Dodeca 5.3.0 release. We have worked hard to get this release out the door. Next on our agenda, we expect to release a 5.3.1 version with some functionality that didn't meet the deadline for 5.3.0. We are also working in the background on our next big release; we hope to start talking about the contents of that release in the not too distant future.