Do You Use Oracle Essbase?
Dodeca Combines the Best of Hyperion Financial Reporting, Planning & Smart View Features into a Single Spreadsheet Management Platform

Why Companies that Use Essbase and Own Smart View, HFR or Hyperion Planning Love Dodeca

Business users love spreadsheets because they’re familiar, flexible and ubiquitous. However, spreadsheets frustrate managers because it makes governance of shared drives full of Excel files difficult. Also, spreadsheets’ increased risk-of-error oftentimes leads to poor data quality and inevitably to productivity losses.

Dodeca Will Save You Time & Money, While Reducing Spreadsheet Risk. Schedule a Demo to Learn How.

  • LexisNexis realized annual savings of 13,000 hours, or 50%, producing management reports
  • Wells Fargo estimates savings of $14,000,000 for CCAR reporting to the federal government
  • Kroger estimates retail operation cost reductions of $200,000,000 over 3 years
  • HBO shortened a monthly close task from days to minutes

Request a Dodeca Demo

Oracle Essbase Users Can Automate Their Reporting, Planning and Analysis Business Processes with Dodeca

Oracle Essbase reporting is simplified by Dodeca. Your company will no longer have to change your business processes to fit Essbase – Dodeca makes it possible to make Essbase fit your reporting & analysis processes.

pentagon graphic3 | Applied OLAP

Dodeca provides the flexibility to build applications that fit the needs of your business without being forced to compromise requirements. Dodeca is used for many types of applications:

  • Financial Reporting
  • Revenue & Expense Planning
  • Workforce Planning
  • Capital Planning
  • Merchandise Planning
  • Cash Flow Analysis
  • Regulatory Reporting
  • Variance Analysis
  • Sales Analysis
  • Labor Reporting
  • Forecasting
  • Annual Budgets

Manage Reports & Spreadsheets Containing Oracle Essbase, HFM, SQL & Other Data Sources in a Single Platform that Functions Like Excel

Request a demo from one of our Dodeca experts to learn how we save companies across industries money, time and resources by providing Oracle Essbase users a familiar spreadsheet based platform to manage, report and drill through data from Oracle Essbase and other data sources, such as SQL databases.

For users of Oracle Essbase, the Dodeca Spreadsheet Management System combines the best features of Smart View, Hyperion Financial Reporting & Hyperion Planning into one spreadsheet management platform that looks and feels like Excel.

Dodeca Spreadsheet Platform Benefits | Applied OLAP

Features of The Dodeca Spreadsheet Management System

Features of the Dodeca Spreadsheet Management System include:

  • Simplified navigation
  • Point of view selectors
  • Live Essbase hierarchies
  • Excel functions and formatting
  • Essbase read/write capabilities
  • Drill through data functions
  • Audit logging
  • Configurable toolbars
  • Comments and annotations
  • Relational Database Read/Write Capabilities

Dodeca is different because it provides Oracle Essbase users with the following benefits:

  • Automates sophisticated business processes
  • Reduces spreadsheet risk
  • Reduces spreadsheet count
  • Increases spreadsheet quality
  • Eliminates Excel lockups and crashes

Dodeca adds functionality for companies currently using Oracle Essbase, Smart View, Hyperion Financial Reporting & Planning because it:

  • Tailors applications to exact business requirements
  • Provides the best aspects of Excel
  • Removes the worst aspects of Excel
  • Focuses on customer success
  • Features superior technical support
  • Increases user productivity saving time and money
  • Reduce spreadsheet risk and improve data quality

How does Dodeca improve productivity, reduce spreadsheet risk and increase ROI on Oracle Essbase?

Fast and easy interaction with Essbase and SQL

The Dodeca Spreadsheet Management System allows for quick interactions with with Oracle Essbase and SQL based data sources. Our new EssJet technology built into Dodeca allows users to read and write large volumes of data without dealing with the frustrating lock-up issues often experienced when using Excel add-in solutions for Essbase reporting and data analysis processes.

june2020 features2 | Applied OLAP

Write-back to both Essbase and SQL

Essbase and Relational Read Write Dodeca | Applied OLAP

With the Dodeca Spreadsheet Management System, users can write back to both Oracle Essbase and SQL data sources using a single interface, significantly simplifying reporting, data analysis and other data intensive business processes. The ability to write back to Essbase and SQL sources enables users to enhance their Oracle Essbase reports with external data in an efficient manner, saving the organization time and money.

Concurrent Essbase Retrievals with EssJet Technology

Dodeca V8 introduces EssJet technology, which allows Dodeca to run multiple Essbase retrieves, or sends, at the same time. Dodeca can now simultaneously run multiple queries from a single sheet or from multiple sheets in a workbook, which greatly enhances performance.

Read more about how our new EssJet technology in Dodeca Version 8 allows for concurrent Essbase retrievals, resulting in faster processing of Essbase queries.

EssJet Whitepaper Figure 1a | Applied OLAP

Asynchronous Environment allows background processing

Asynchronous Background Procesing Essbase Dodeca scaled | Applied OLAP

Allows most processes, including Essbase data and metadata queries, commentary queries, and startup functionalities, to run in the background freeing the user-interface for more interaction while providing the option to cancel processes.

Dodeca uses the native Excel file format, but operates independently of Excel. The building of a view and retrieval of data does not prevent the user from continuing to use the software. A user can start a build, then start a second and third build returning to the initial view at their leisure. Therefore, long running queries can be executed while a user continues to work on other tasks.

Commentary to gather, organize, and store variance analysis

Dodeca users can attach commentary to their reports to provide deeper explanations of data points and trends. Users’ comments are attached to the data and written back to Essbase, so that the commentary isn’t lost and provides insight when viewed in other modules and applications that pull data from Essbase. The commentary feature is especially useful in budgeting and forecasting reports. If there is a variance between the actual expense and the budget, an explanation or annotation can be inserted.

june2020 features2 | Applied OLAP

Drill-through Essbase and SQL Data Reports

Drill Through Essbase Data with Dodeca | Applied OLAP

Drill-through your Essbase and SQL data in Dodeca to easily analyze data at a more granular level without running separate reports. Dodeca provides intelligent navigation so users can quickly and easily drill down to the data they want, such as general ledger and other transactional systems, regardless of where the data is located.

Audit Logging to provide true accountability

Audit logging shows who changed what number and when it was changed. This feature results in a system of authoritative collaboration, thus reducing spreadsheet risk. Audit logging has proven to be an invaluable tool for providing accountability in financial reporting.

Audit Logging for Essbase Activity Log Dodeca | Applied OLAP

Access multiple data sources in a single report

Dodeca Spreadsheet Platform Benefits | Applied OLAP

Import data held in Oracle Essbase external data sources, such as SQL databases, into Dodeca, simplifying the reporting processes that require analyzing data held outside of Oracle Essbase. General ledger, financial, and operational data detail in other platforms and applications can be brought together with Essbase data. Dodeca can also pull information directly from SQL when that is used as a data source without an EPM platform or other business application. Dodeca’s ability to combine data from multiple sources, including SQL databases, makes performing data validations much quicker and easier.

Workbook Analyzer and Cleaner

The Dodeca Workbook Analyzer can analyze and clean Excel workbooks. This gives an administrator the ability to clean old workbooks which often contain unnecessary artifacts such as dead Excel links, #REF range names, extraneous styles, and unused Smart View data streams.

Workbook Analyzer Cleaner Prevent Excel Errors Essbase Dodeca | Applied OLAP

HFM Connector

Dodeca can retrieve data from Hyperion Financial Management databases allowing integration with Essbase and Relational data, such as SQL databases.

 Expandable shared member hierarchies

Shared members can be expanded in the Treeview Selector to show the descendants of the base member.

Single Sign-On (SSO) Support

Dodeca supports Single Sign-On using the SAML2 protocol, including the option for Multi-Factor Authentication (MFA), provided by Identification Providers such as Okta, Ping, and JumpCloud.