Excel Add-In Version 7.7.0

The Dodeca Spreadsheet Management System (DSMS) supports the ability to perform a standard retrieve operation on a named retrieve range without requiring the user to select the range. This capability also allows for multiple retrieves to be performed on a single worksheet by simply clicking the Retrieve button. Similarly, a send operation can be performed on a named send range or multiple send ranges on the same worksheet.

The DSMS also allows for a specific Essbase database to be associated with a given named retrieve or send range, which allows for retrieving from or sending to multiple Essbase databases on the same worksheet. For this capability, the Essbase connection information must exist in the Dodeca Metadata Repository.

To provide better integration between the DSMS and the Dodeca Excel Add-in for Essbase, the ability to leverage this functionality within the Add-In is being introduced in this release. When a DSMS user saves a view to Excel, opens a view in Excel, or exports a view to Excel from the Dodeca client, the workbook is enabled to automatically allow for the retrieves and sends to be performed using the named retrieve and send ranges that conform to the Dodeca client naming conventions.

Any named retrieve or send range that has an associated Essbase connection metadata ID, stored in the workbook as a named constant, is recognized by the Dodeca Add-In and the connection information is obtained from the appropriate tenant in the metadata repository. The tenant is the same as the tenant associated with the Dodeca application from which the Excel file was saved, opened, or exported. The tenant is automatically stored in the workbook as a workbook-level named constant, Essbase.Connection.Tenant.

In addition to standard retrieve and send operations, other retrieve operations, including zoom in and out, keep and remove only, and pivot can be performed within a named retrieve range. The named retrieve range is automatically adjusted to accommodate the newly retrieved data; however, other data, including other ranges, on the sheet may be affected, since cells are added or removed to resize only the named retrieve range within which operation is being performed.

For customers who currently only use the Dodeca Add-In, the ability to perform multiple retrieves or sends on the same worksheet from or to the same database is also supported and represents a significant enhancement.

To enable this capability for a workbook that was not saved from a DSMS client, named retrieve and send ranges can be added to the workbook. The names of ranges must conform to the DSMS naming convention, and must be defined as a sheet-level name.

For a named retrieve range, the required format of the name is Ess.Retrieve.Range.<ID>, where the ID uniquely identifies the named range within the same scope. Similarly, the format of the name of a send range is Ess.Send.Range.<ID>.

The Retrieve Sheets with Named Retrieve Ranges button supports retrieving all worksheets which contain named retrieve ranges. Other worksheets are skipped. If the connection information for a given retrieve range is not stored as a named constant in the workbook, the active or default Essbase connection is used.

#1933, #1961