Dodeca Excel Add-In for Essbase

The Drop-in Replacement for the Classic Essbase Add-In for Essbase

The Dodeca Excel Add-In for Essbase is a modern, high-performance add in that brings Essbase connectivity to Excel with enterprise grade governance and speed.

Built for analysts and finance teams who are always in spreadsheets, and for IT leaders who demand security and scale. The Dodeca Excel Add-In for Essbase transforms ad hoc analysis and reporting into a governed, high trust process without forcing users to change how they work.

What you gain with the Dodeca Excel Add-In.

Discover the key advantages that make Applied OLAP the preferred choice for Essbase users. From unmatched performance to seamless Excel compatibility, every feature is built to enhance your analysis experience and streamline daily workflows.

High Performance

Enjoy lightning-fast performance comparable to the classic Essbase Add-In for Essbase for seamless analysis.

Works with All Modern Essbase Versions

Fully supports Essbase 9.3.0 and newer, including seamless integration with Essbase Cloud.

Excel Compatible

Designed to work flawlessly with Microsoft Excel versions from 2010 onward.

Full VBA & Toolkit Support

Includes complete Essbase Spreadsheet Toolkit and VBA integration for advanced customization.

Excel Familiar. Essbase Optimized.

Use the Dodeca Excel Add-in for Essbase to retrieve, pivot, from Essbase, all in an interface that feels native to Excel users.
Automate refreshes and eliminate copy/paste risk while retaining the flexibility analysts expect.

Ad-hoc Essbase operations

Instantly perform ad-hoc analyses directly within Excel, giving you total control over your Essbase data. Slice, dice, and drill down on the fly without complex setup or coding.

Options at your fingertips

Access all key Essbase tools through an intuitive ribbon interface. Every option is right where you need it to streamline workflow and reduce clicks.

Undo and redo

Experiment freely with your data knowing you can easily reverse or reapply any action. The undo/redo support lets you explore different views without risk.

Unknown members

Quickly identify and handle unknown members in your queries. The system flags issues automatically so you can correct them before they impact reports.

Status at a glance

See connection, query, and calculation statuses in real time. A clean status panel keeps you informed of every operation’s progress and result.

Essbase calculations with Run Time Substitution Variables

Leverage powerful Essbase calculations that adapt dynamically using Run Time Substitution Variables. Customize results for any scenario without editing scripts.

Calculation status

Monitor the progress of your Essbase calculations in real time. Instantly see completion rates, errors, or pending processes for better control.

Drop-and-go VBA support

Integrate Essbase functions seamlessly into your VBA macros. Automate workflows and build powerful Excel solutions without additional configuration.

Why finance and IT teams choose Dodeca

For Finance Teams

  • Familiar Excel interface, no retraining
  • Fast ad-hoc analysis and slice retrieval
  • Faster cycles, fewer errors, higher confidence
  • Pivot/POV control and member selection right in the grid

For IT Leaders

  • Centralized governance and role-based access
  • Seamless authentication (incl. SSO) and auditability
  • Scales across teams, cubes, and environments (on-prem & cloud)
  • Easy, controlled deployment and updates

Find out if The Dodeca Excel Add-In for Essbase is right for you.

Take the Dodeca Excel Add-in for Essbase Challenge:
Let’s download the software in your environment so you can try it for 30 days.

Let's Talk