Last week saw the release of the latest version of CALUMO for SQL Server Analysis Services, CALUMO 11.4. This release has rolled up all the features of the CALUMO 11.3 cumulative updates as well as delivering a set of new features and performance improvements.
Highlights
- Text Writeback architecture update
- Publishable Drop Lists and Date Pickers
- Excel VBA API
- New Installers
- Windows 7 and Windows Server 2008 R2 Compatible
Text Writeback Architecture Update
This feature is a key differentiator within CALUMO 11 and in our recent work we took a good look at the existing architecture and reworked it for performance and scalability.
Publishable Drop Lists and Date Picker
Our standard CALUMO drop lists have been enhanced to also support data write back. Now drop lists can be used to enter data from a standard selection list.
Fig 1: CALUMO Drop Lists
The date picker simplifies selection of dates. For example, when budgeting the start date of a new employee using the date picker, a date is written back. Budgets salary and on-costs will calculate and budget from this date.
Fig 2: CALUMO Date Picker
Excel VBA API
These API allow automation and control of certain features of CALUMO from VBA macros within Excel.
New Installers
CALUMO installation is already a very easy process. For example, users can install or upgrade the CALUMO Excel client with a one button click from the status bar, thereby synchronising their version with the CALUMO Server. Adding to this, our new CALUMO installers are now smaller, faster and more reliable and can be automatically built at any time for any revision of the CALUMO codebase. This enables us to deliver patches to the software as robust installers instead of as manually applied patches.
Other Features worth Noting
- Administrator can set a default start page a default view for a Cube.
- Administrator and Users can set default subsets for hierarchies.
- Sort and top/bottom count filters available in cube browse.
- We include a web based calculation engine supporting most Excel functions in CALUMO published web pages.
- Conditional formatted cells in CALUMO published web pages