The Dodeca Discovery Lab

A room dedicated to Dodeca Spreadsheet Management System Content | All sessions held in Room 306


Sponsored by Applied OLAP.png


Open to all ODTUG Kscope20 attendees

New this year! Applied OLAP is offering over 20 hours of Dodeca content in our lab, a live Dodeca environment. We have sessions for beginners, intermediate, and advanced users.

For beginners, we have a session that provides an introduction to Dodeca Spreadsheet Management System for end users. This session gives everyone the opportunity to try Dodeca hands-on from the end user point of view. Come by and see for yourself why our customers love Dodeca. For intermediate users, we have sessions on workbook scripting, commentary, and SQL view creation. For advanced users, we have sessions on MDX, drill-through, and security management. We are also planning an open mic session where you can show off the cool stuff you have built in Dodeca, ask how-to questions, and challenge us to find solutions to your ugliest spreadsheet problems.

You won't want to miss this amazing training opportunity where you will have a chance to learn from the experts in a live Dodeca environment.

 

Monday 11:00 a.m. - 12:00 p.m.

Introduction to Dodeca Spreadsheet Management System for End Users

Tim Tow, Applied OLAP

In this session we’ll introduce what Dodeca is, why we built it, and how it’s used by tens of thousands of people every day.

Monday 12:15 - 12:45 p.m.

Building Your First Dodeca Report

Tim Tow, Applied OLAP

Learn by doing in this lab session. We will walk you through the creation of a report in Dodeca. Use this as a stepping stone to create powerful reporting applications.


Monday 2:00 - 3:00 p.m.

Workbook Scripting - Build Range from Script

Tim Faitsch, Applied OLAP

One of the challenges many users face is ever-changing hierarchies. In this lab session we’ll show you how to create reports that require no maintenance and still guarantee to show the very latest hierarchies in your Essbase cube.

 

Monday 3:15 - 3:45 p.m.

Workbook Scripting - Logic and Looping/Debugging

Tim Faitsch, Applied OLAP

In this session we’ll introduce powerful Dodeca capabilities that allow you to customize reports. We will show you how to automatically take actions based upon criteria on a report. We will also teach you how to troubleshoot complicated formulas.

Monday 4:15 - 5:15 p.m.

Dodeca Spreadsheet Design Best Practices

Tim Tow, Applied OLAP

In this session you’ll reap the benefits of over 25 years of spreadsheet building experience from Tim Tow. He will show you how to avoid pitfalls while demonstrating strong spreadsheet design concepts.


Monday 5:30 - 6:00 p.m.

Bring Your Dodeca/Reporting Questions

Tim Faitsch, Applied OLAP

Bring your most challenging Dodeca and reporting questions to this open mic session. Our panel of experts will be on hand to give you ideas on how best to approach your problems and solve them with time-tested Dodeca reporting methods.






Tuesday 8:30 - 10:15 a.m.

MDX Training

Tim Tow, Applied OLAP

MDX is a powerful multidimensional reporting language. Dodeca has the capability to leverage MDX in a number of different ways. We will walk you through how to create an MDX script in Dodeca and then how to use that script to create lightning-fast reports.


Tuesday 10:45 - 11:45 a.m.

Dodeca Customer Panel - Accelerate into the Fast Lane with Dodeca

Dodeca Customers

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 at a lower cost 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.


Tuesday 1:30 - 2:30 p.m.

Commentary

Tim Faitsch, Applied OLAP

Essbase is great at storing numerical data, but adding text and commentary usually takes a lot of work. See how easy it is to add commentary to your Essbase reports using Dodeca. We will show you several ways you can use Dodeca to make Essbase better with comments, explanations, dialog, and descriptions for your data.

 

Tuesday 4:15 - 5:15 p.m.

Toolbars and Buttons/DSMS Drill-Through

Kevin deJesus, Applied OLAP

In this session we will teach you how to create custom toolbars and buttons in Dodeca. We’ll leverage these tools to create a drill-through from Essbase to a relational database. See for yourself how easy it is to create custom drill-through paths in Dodeca.


Tuesday 5:30 - 6:30 p.m.

Selectors and Selector Lists

Tim Faitsch, Applied OLAP

Selectors drive content in Dodeca reports. We will show you several ways to populate selectors with various content such as Essbase member names and a list of data from relational databases.






Wednesday 8:30 - 9:30 a.m.

Introduction to Dodeca Spreadsheet Management System for End Users

Tim Tow, Applied OLAP

In this session we’ll introduce what Dodeca is, why we built it, and how it’s used by tens of thousands of people everyday.


Wednesday 9:45 - 10:15 a.m.

Building Your First Dodeca Report

Tim Tow, Applied OLAP

Learn by doing in this lab session. We will walk you through the creation of a report in Dodeca. Use this as a stepping stone to create powerful reporting applications.

 

Wednesday 1:00 - 2:00 p.m.

SQL View Creation

Tim Faitsch, Applied OLAP

Business users love spreadsheets for just about everything they do, but most business data is stored in SQL tables. Unfortunately spreadsheets and SQL can be difficult to integrate. Dodeca overcomes this disconnect by seamlessly integrating the two. We will walk you through the creation of SQL reports in this session.


Wednesday 2:15 - 3:15 p.m.

Implement Drill-Through in 60 Minutes with Drillbridge

Jason Jones, Applied OLAP

Drillbridge allows you to drill-through from various Oracle EPM products to relational data. In this session we will walk you through an example of how this works.


Wednesday 3:30 - 5:15 p.m.

DSMS Security Management

Jason Jones, Applied OLAP

In this session we will cover several aspects of Dodeca Security Management. Topics will include integrating Essbase security, authentication services, roles, and single sign-on.