Agenda Topics at Dodeca Summit23 with session recordings

Applied OLAP: Introduction to Dodeca

Tim Tow

Dodeca Spreadsheet Management System is our flagship product. Tim Tow will provide a brief overview, discuss use cases, and demonstrate features.

The Kroger Company: Dodeca Support for Budget and Forecast Allocations

Danny Hanck

Kroger uses Dodeca as its budget and forecasting input tool and this often involves allocations down to base level and cross cube validation. Kroger has developed many useful processes to make the process effective, repeatable and traceable. From data entry to base level intersections and multi cube standardized validation reports. Overall, Dodeca has helped reduce the time spent on administrative tasks related to allocations.

Using Blobs

Billy Ruge

Walk through the development aspects and use cases of the new Dodeca features in version 8.2.3 and newer of utilizing blobs in development efforts.

LexisNexis: Flexibility with Dodeca Input Forms

Jimmy Hellyer

This presentation delves into LexisNexis’ best practices for input forms, offering insights and strategies to enhance your Dodeca implementation. The following key topics will be explored: deleting rows, controlling security, data validations, sorting, filtering, pushing consolidated data to the base level and handling protected sheets.

Applied OLAP: Using Dodeca with PBCS / EPM Cloud

Jason Jones

The Dodeca PBCS/EPM Cloud Connector can be used to build Dodeca views and reports using your EPM Cloud applications, including PBCS, FCCS, PCMCS, and more. This presentation will discuss and demonstrate setting up the connector, adding connections to Dodeca, configuring selector lists, building views, and submitting data back to PBCS. The current features, limitations, and roadmap for the connector will also be discussed.

Principal: ‘Dodeca Does It’ at Principal

Kristi Meyer, Mary Deitrich

An overview of how Principal uses Dodeca for reporting and beyond. Principal uses Dodeca to fill a variety of global reporting needs. This session will discuss the various types of reporting including ad hoc, standard reports, validations and more. Unique needs have also been met by creating SQL tables to load and report off of in Dodeca as well. Automation and scheduling have helped Principal maximize efficiency and ensure controls are being met. Dashboards have helped solution for Power BI type needs as well as creating a user-friendly way to put reports and documentation at the user’s fingertips.

Applied OLAP: Dodeca Roadmap / Wish List / Github

Tim Tow

This session will layout the current Dodeca Roadmap and foster interactive dialog between participants about the priorities on the roadmap and get feedback from customers on their Dodeca Wishlist. In addition, we will delve into the Dodeca Github system to share how we record, prioritize, and track Dodeca development items.

The Kroger Company Key Performance Indicators

Jim Sams

This session will layout the current Dodeca Roadmap and foster interactive dialog between participants about the priorities on the roadmap and get feedback from customers on their Dodeca Wishlist. In addition, we will delve into the Dodeca Github system to share how we record, prioritize, and track Dodeca development items.

Kroger Manufacturing Budget – Dynamic Location Update

Devon Potts

Kroger is using a new Dodeca tool to help automate the Budget & Forecast process for our Manufacturing team. By creating a new user friendly tool we have allowed users to expand the scope of their budget process. We have completely eliminated any manual input and work on our end that users relied on, we now have given the power back to them.

LexisNexis Dodeca Report Solutions

Josh Baker

Discover how LexisNexis achieved a remarkably quick turnaround in their data tie-out processes by leveraging Dodeca. This presentation highlights their success story, showcasing how their solution enabled them to streamline and enhance an otherwise difficult task. Learn how they used cascades, MDX, and filtering to build their powerful application.

Applied OLAP: Dodeca Grouping with SQL

Tim Faitsch

SQL Grouping in Dodeca is an incredibly powerful but under-used feature. See how to add Excel grouping with subtotals and totals to your SQL Views.

Dodeca Summit23 was a great success!

Since 1998 Applied OLAP has been specializing in enterprise spreadsheet management. We are the only company in the Oracle EPM community that focuses exclusively on spreadsheet technology.

We are committed to supporting the greater Oracle Hyperion community. We maintain, distribute, and support the popular Next Generation Outline Extractor, OlapUnderground Essbase Outline Extractor, Advanced Security Manager, and Substitution Variable Manager utilities free of charge as a service to the community.