About AppliedOLAP

Join us at Kscope22!
Grapevine, TX | June 19-June 23, 2022

ao 468x60 ODTUG animation2022 r1 | Applied OLAP

New Content for Kscope22 coming soon!

Applied OLAP Content at Kscope21

Introduction to Dodeca Version 8

Mon., June 21, 1:40 PM – 2:20 PM (ET) | Video Chat Room in the Applied OLAP Titanium Exhibitor Booth
Presenter: Tim Tow, Founder and President – Applied OLAP, Inc.
The Dodeca Spreadsheet Management System turns business spreadsheets into a managed and secure analytic resource that drives enterprise success. Dodeca makes it easy for business users to get information they need in the spreadsheet format they love. With Dodeca, users can dynamically build reports from any number of corporate data sources, including Essbase, Oracle Database, Microsoft SQL Server, and IBM DB2. Join this session for a brief introduction, customer success stories, and demonstration of Dodeca Version 8.

What’s new in Essbase 21c

Tues., June 22, 1:40 PM – 2:20 PM (ET) | Video Chat Room in the Applied OLAP Titanium Exhibitor Booth
Presenters: Tim Tow, Jason Jones, and Tim Faitsch – Applied OLAP, Inc.
Join Tim Tow, Jason Jones, and Tim Faitsch for an informal discussion about Essbase 21c.
Bring your questions about Federated Partitions, MDX, Docker, Hybrid, and more.

Drillbridge: Powerful drill-through capabilities for your users — the way they want it.

Wed., June 23, 1:40 PM – 2:20 PM (ET) | Video Chat Room in the Applied OLAP Titanium Exhibitor Booth
Presenter: Jason Jones, Chief Security Officer and VP of Engineering – Applied OLAP, Inc.
Drillbridge is an innovative turn-key solution for easily providing drill-through for Oracle EPM Cloud, Hyperion Planning, Financial Reporting, and Smart View users. Drillbridge provides rich functionality for mapping from your Essbase dimensionality to the corresponding relational/transactional data and does not require changes to your automation or administration procedures.

How to save 280 days a quarter with Dodeca!

Thurs., June 24, 1:40 PM – 2:20 PM (ET) | Room: 5 | Session Number: 11696
Presenter: Victor Turner, Sr. Director Financial Systems Administration – Lexis Nexis
For Q1 of 2021, Lexis Nexis conservatively estimated a 280 day savings as a result of their implementation of over 185 Dodeca standard tools and reports. Come see how they are using Dodeca with SQL Server and on-prem versions of Hyperion Essbase, Planning, PeopleSoft and Oracle Financials to provide more data, faster and with a higher quality, allowing their Finance function to be a better partner to the business.

Applied OLAP: Dodeca Customer Panel — Accelerate into the Fast Lane with Dodeca

Fri., June 25, 1:40 PM – 2:20 PM (ET) | Room: 1 | Session Number: 11693
Presenters: The Kroger Company, Lexis Nexis, Lennox International
One thing that all companies share is the requirement for timely, accurate, and actionable information in order to optimize their business operations. Join this session to hear from Dodeca customers on how they provide just the right information to their business operations faster, easier, and less expensively than any other solution on the market. Learn how Dodeca can help your company. Participate in the Q&A session and ask questions directly to the panel.

See how Vertiv utilized Essbase and Dodeca to replace a manual Excel workforce planning process with a Global Driver Based Workforce Planning Solution

Mon., June 28, 1:40 PM – 2:20 PM (ET) | Room: 1 | Session Number: 11694
Presenters: Chris Newman, Manager, Global FP&A – HR Vertiv
Brad Gingrich, President – EssAnalytics | Dennis Hogan, Solution Architect – EssAnalytics
This presentation will cover how Vertiv implemented a global workforce planning solution utilizing Essbase and Dodeca. This solution enabled them to replace a process of disconnected spreadsheets with a solution that improved the speed of creating the forecast, created consistency in how related workforce costs are calculated, and improved overall data integrity in the process.

How to Take Advantage of the 60 day Dodeca POC

Tues., June 29, 1:40 PM – 2:20 PM (ET) | Room: 5 | Session Number: 11695
Presenters: Theresa Hyde – FP&A Business Solutions Manager – Lennox International
Kevin Cox – Sr FP&A Business Solutions Manager – Lennox International

Is your company struggling with the analysis and reporting of Hyperion, such as:

• Financial Analyst time spent on updating, troubleshooting, distributing and consolidating reporting templates
• Business Users unwittingly using superseded versions of distributed templates
• Curiously large legacy Excel reporting templates that take forever to update
• Odd and unexplained differences between analytic templates and more formal financial reports
• Macros and other automation attempts buggy and difficult to maintain
• Hyperion Support team asked by 3rd party to troubleshoot/support template created/distributed by analyst
• Analytic commentary buried/”trapped” in various spreadsheets

These were just a few issues we wanted to explore solving with Dodeca, but the budget was tight. Management didn’t want to get locked into a new contract with a solution that may have helped to some unknown degree. We will step through how we were able to take advantage of Dodeca’s 60-day Proof of Concept in order to get real solutions for our business in front of decision makers in short order
and at a minimum of risk.

Scenario Modeling with the Dodeca Spreadsheet Management System

Wed., June 30, 1:40 PM – 2:20 PM (ET) | Video Chat Room in the Applied OLAP Titanium Exhibitor Booth
Presenter: Tim Faitsch, Pre-Sales Solutions Specialist – Applied OLAP, Inc.
It has been said that the only certainty in business is uncertainty. Easily build scenario planning and what-if analyses with Dodeca. In this webinar we’ll show you how to leverage existing multiple data sources to quickly model, analyze, and provide decision makers with the information that matters.

Ask The Experts

Thurs., July 1, 1:40 PM – 2:20 PM (ET) | Video Chat Room in the Applied OLAP Titanium Exhibitor Booth
Between them; Tim Tow, Jason Jones, and Tim Faitsch have over 60 years of EPM development and implementation experience and all three have been designated as an Oracle Ace in the EPM space. Participate in a Q & A session on a variety of topics.

Moderated Discussion – The Latest Essbase Reporting Options

June 24, 2021, 12:00 PM – 12:40 PM (ET) | Kscope Mingle
Presenter: Tim Tow, President – Applied OLAP, Inc.
From Wired for OLAP to HFR Tim Tow has seen countless Essbase reporting software come and go. Join Tim as he moderates a forum to discuss the pros and cons for and against the most recent crop of Essbase tools.

Advanced MDX Capabilities

June 25, 2021, 12:40 PM – 1:40 PM (ET) | Room: 5 | Session Number: 11048
Track: Essbase Sub-Categorization: Other
Essbase Session Type: Tips, Techniques and Tuning
Technologies or Products Used: Essbase
Presenter: Tim Faitsch, Presales Solutions Specialist – Applied OLAP, Inc.
MDX is a powerful way to retrieve and manipulate Essbase data. I will do a deep dive on several advanced MDX functions. I will also discuss members on the fly, hierarchy queries, calculations and exports. Emphasis will be placed on the absolutely newest MDX capabilities in Essbase 21c including updating database data and nested select statements.

Reducing Spreadsheet Risk and Maintenance Through Better Spreadsheet Design

June 25, 2021, 4:00 PM – 5:00 PM (ET) | Room: 5 | Session Number: 11586
Track: Essbase  Sub-Categorization: Design & Optimization
Session Type: Tips, Techniques and Tuning
Technologies or Products Used: Essbase
Presenter: Tim Tow, President – Applied OLAP, Inc.
Millions of people use spreadsheets in countless ways. Due to this flexibility, spreadsheets have gained a reputation as risky and time consuming which has led to efforts to eliminate them from corporate computing. Despite those efforts, spreadsheet usage continues to grow. In fact, you could call spreadsheets “the
cockroach of the computing world” as they will exist after many other corporate systems are long gone.

As spreadsheets will be part of our lives for years to come, it may be smart to understand more about how
they store information. It is common practice to copy and rename a workbook to form the basis of another report. Perhaps you have noticed your spreadsheet file sizes seem to keep growing and you really don’t know why. Further, when it comes to Essbase reporting within Excel, there are many techniques used by spreadsheet users to layout the retrieval. While some of these techniques and design styles are good others are not so good. Join this session to explore the internals of how Excel worksheets are constructed, discuss common issues causing bloated file sizes and how to fix them, and learn about a worksheet retrieval
technique that will make your spreadsheets easier to maintain and easier to audit.


Rebuilding all of Kroger’s financial reporting (mostly)

July 1, 2021, 2:20 PM – 3:20 PM (ET) | Room: 1 | Session Number: 11185
Track: Strategic EPM Sub-Categorization: Journey to the Cloud
Session Type: Case Studies
Technologies or Products Used: Essbase, Dodeca, Cloud GL, FCCS, ARCS
Primary Presenter: Noah Sexton, Developer – The Kroger Co.
Co-Presenter: Elizabeth Ferrell, Financial and Reporting Systems Director – The Kroger Co.
Over the past 2 years, Kroger has been on a journey to revamp and modernize our accounting systems which includes our first steps into the cloud. We’ll discuss the steps along the journey and cover some of the pitfalls we encountered as well as celebrate some of our victories. Additionally, hear about how we came to realize how “modern” some of our solutions already were.



Schedule a meeting with one of our Strategic Enterprise Spreadsheet Management Specialists.

We are proud to be the Titanium Sponsor of Kscope22 and look forward to speaking with you!

For 23 years Applied OLAP has been specializing in enterprise spreadsheet management, and is the only company in the Oracle EPM community that focuses exclusively on spreadsheet technology.

We are also committed to supporting the greater 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.