Essbase

The ODTUG Kscope17 Conference Is the Place for Oracle Essbase!

ODTUG Kscope17 brings together the most intelligent Essbase design and development experts. You’ll learn the ins and outs of the new Essbase Cloud Service (EssCS) along with all the tools needed to administrate, design, and optimize your work to build better structures for data collection. Our experts will show you design patterns for Hybrid and ASO models, show you how to manage from backups, and cover security and automation. Want to take a deep dive into Oracle’s Engineered Hardware system for BI and Analytics, Exalytics? We’ve got you covered. 

Cloud:

Learn all about the new Essbase Cloud Service (EssCS), what it is, and how cloud can benefit you. 

Hybrid & ASO:

Combine the strengths of BSO and ASO into one cube. You’ll learn all the steps necessary to create your cube, modify, set, load, and retrieve data in Hybrid mode.

Administration:

We’ll teach you how to properly administrate and manage Essbase from backups to security to automation. 

Design, Calculations, and Optimization:

You’ll learn all you need to know about cube design; calculations in ASO, BSO, or Hybrid; and CDFs.  Design, optimize, and tune your work for maximum performance.

Exalytics:

Next, you’ll learn your way around running Essbase on Oracle’s Engineered Hardware system for BI and Analytics/Exalytics to create beautiful analytics reports at the speed of thought.

API and Related Tools:

APIs have transformed how we connect to data. You’ll get a bird’s-eye view on how to use the Java API/Groovy, and using associated tools such as non-Oracle and free community utilities. 

Check out the presentations listed below.



Exalytics-Compatible: Automate Your Linux Backups
Bernard Ash , EPM Clarity
Topic: Essbase - Subtopic: Administration

Let's automate and schedule the backup of our large Essbase Linux deployments – including Exalytics. Leveraging LCM is great, but we should really back up more such as file system backups, MAXL parallel data exports, and our Essbase partition definitions that cannot currently be backed up using MAXL or LCM.

Back to Top
Hybrid Essbase in the Real World: A Production Example with Maintenance-Free Currency Conversion
Greg Beaton , TGG
Co-presenter(s): Nikhil Virmani, ATOS
Topic: Essbase - Subtopic: Essbase-related technologies

What’s Hybrid Essbase all about? What can it do, and what can’t it do? What do I need to know to both implement and use it? Should I use it? Learn how we turned a poorly performing ASO cube into a speedy Hybrid cube, adding ease of use with access to the BSO calculator while retaining fast dynamic aggregations.

Learn the advantages and disadvantages of the new Hybrid Essbase Engine from a company that has been using it in production for almost a full year. Both the Essbase Architect and Client Administrator will be on hand to discuss how Hybrid Essbase performs in the real world.

We will discuss hybrid cube design and our evolution of getting there. Learn about our 16-dimension cube with maintenance-free custom currency conversions using the BSO Calculator that aggregates instantaneously. We will touch on the benefits and pitfalls of using Hybrid and discuss our lessons learned. If you are thinking of going Hybrid, this session will reveal some of the secrets you need to know.

Back to Top
Essbase Dashboard Smackdown!
John Booth , METAVERO
Topic: Essbase - Subtopic: Essbase-related technologies

Confused about which solution to pursue for Essbase visualization? We compare Web Analysis vs. Tableau vs. Oracle BI vs. other contenders in performance, prettiness, and power. Which tools make sense to embrace?

Back to Top
Programming (Flexible) Automation to Use Processing Cubes (and Other Automation Tricks)
William Bradstreet , Bradstreet Business Services
Topic: Essbase - Subtopic: Other Essbase

Essbase must be automated, but most Essbase automation consists of a MaxL script within a .cmd/.sh file. But that’s crude, inconsistent, and a maintenance nightmare. A better approach is a parameter-driven automation framework that dynamically spawns batch streams, applies the same processes consistently, and – because the actual code base is small – centralizes maintenance. As a bonus, this ease of development streamlines the migration from development to quality to production. Join Bill Bradstreet as he describes, demonstrates, and dives into a programming methodology and the code behind it to show how you can bring the power and flexibility of this approach to your system today.

Back to Top
Empowering Management Reporting via Oracle Essbase
Dave Collins , The Hackett Group
Topic: Essbase - Subtopic: Design

Microsoft XL remains the leading business tool for analysis, management reporting, and even ETL! Why? Well, XL is easy and everyone knows how to use it – or do they? In today's ever-changing world, speed-of-thought analytics ensure success. Data modeling via OLAP is certainly one way to empower users. During this session, you will see how easy it is for business users to model, update, and perform analyses with XL and more formalized reporting tools. You will also learn the best-practice approach for enabling both self-service and structured reporting.

Back to Top
Advanced Calculation Techniques: Going Beyond the Calc Dim
Topic: Essbase - Subtopic: Calculation

Join us as we take a deep dive into some of the ways the Essbase calculation engine can be used to solve complex business problems, all derived from real-life examples learned from the school of hard knocks. Techniques include combining spreadsheets and calc scripts to compute variances for hundreds of member combinations, designing recursive calculations to analyze a product’s components, and building a structure that allows user input to any level of a hierarchy. We’ll review the different methods of writing allocations, ways to optimize your parallel calculations, and block creation techniques and calculation features you are told “never to use” but might want to use anyway. This presentation is intended for intermediate Essbase developers, but all are welcome.

Back to Top
I've Got an MDX Script for That
Gary Crisci , General Electric
Topic: Essbase - Subtopic: MDX

With the release of Essbase 11.1.2.4.010, it is now possible to get clean MDX output from a MaxL script. This opens many doors and possibilities for developers and power users, and makes knowing how to write a solid MDX script a must-have skill for Essbase professionals.

In this session, EPM Principal Technologist and Oracle ACE Gary Crisci will discuss the fundamentals of writing MDX scripts. He will introduce the new delimited output options and discuss different ways to leverage this new feature. Gary will show attendees how they can use their MDX scripts to create advanced reports for users and how to format data for ingestion to other systems. Gary will also discuss how to use the Query & Load (Q&L) method to leverage MDX scripts as an alternative to ASO calc scripts. Don’t miss this informative session from a noted MDX expert.

Back to Top
Using VBA to Enhance the Smart View Expereince
Daniel Gagnon , Huron Consulting Group
Topic: Essbase - Subtopic: Other Essbase

Have you ever taken a look at the Smart View developers guide and seen all of the VBA functions that are available to you? They are endless, and the power they pack can be lost behind the sometimes-complex syntax that is required. Come spend an hour learning what they do, how they can benefit you, and possibly even how to accomplish tasks otherwise out of reach.

Back to Top
Essbase Cloud – How You Do It (Live Demos) and Expanded Q&A
Tim German , Qubix
Co-presenter(s): Cameron Lackpour, ARC EPM
Topic: Essbase - Subtopic: Other Essbase

You won’t want to miss this opportunity to see Oracle Essbase Cloud Service up close and personal. Cameron Lackpour and Tim German will expand on their Essbase Cloud session, demonstrating how to accomplish a variety of real world tasks and use-cases in Essbase Cloud Service. An Oracle representative will be on hand to weigh in on Q&A discussions.

Back to Top
Essbase CDFs Demystified: Pulling Back the Curtain and Opening a World of Possibilities
Robert Gideon , interRel Consulting
Topic: Essbase - Subtopic: Calculation

Unique challenges often arise during Essbase and Planning projects that require thinking outside of the box, or the calculator engine, as the case may be. Essbase Custom Defined Functions (CDFs) enhance the calculation functions included with Essbase. Essbase CDFs unleash the power of Java and open a world of possibilities. This session will demystify CDFs, show how to deploy them, and demonstrate how they can be used if the need arises.

Back to Top
Essbase and Crystal Ball: Adding risk related data to a Financial Model
Philip Hulsebosch , Trexco b.v.
Topic: Essbase - Subtopic: Essbase-related technologies

In real estate development risk assessment and risk management are key elements for the financial model of a project. Common financial models only let you do a best case, worst case and most likely scenario. They lack information on the probability of occurrence of this most likely scenario. Also, information on the variance within this most likely scenario is often missing. This results in decisions based on inadequate information.

In this case study we will show an Essbase model and how to add risk related information. In a matter of hours we were able to extend the existing Essbase model with Oracle Crystal Ball statistical functionality and generate this important information.

This case study is about drilling a geothermal energy well and the green energy produced will be delivered to nearby apartments, houses and small businesses. The risk influencing factors were energy price, interest rate and maintenance costs. The case study can serve as a kind of blue-print on how risk related information can be added to a project plan.

Back to Top
Essbase on Exalytics – It’s magical if you chant the spells right
Adrian Istani , Ingersoll Rand
Topic: Essbase - Subtopic: Exalytics

Essbase on Exalytics may / may not automatically translate better stability or performance without additional tweaking – in our case it did not. Here were our experience with Exalytics X3-4 since we acquired it in early 2015, moving from much smaller windows intel box to now rock solid implementation with Exalytics.

Back to Top
King/Queen of CDFs has arrived
Celvin Kattookaran , Intekgrate
Topic: Essbase - Subtopic: Calculation

The King or The queen of CDFs has arrived. This session talks about the latest CDF offering from Calc Manager which can be used to write CDFs from Calculation scripts itself.
What if you want to execute a SQL procedure from Calc script? What if you want to run a select statement?
All that and beyond is now possible with @CalcMgrGroovyString and @CalcMgrGroovyNumber functions. This session will include sample codes for all the topics covered above

Back to Top
Essbase Cloud is Here. Now What?
Cameron Lackpour , ARC EPM
Co-presenter(s): Tim German, Qubix
Topic: Essbase - Subtopic: Other Essbase

Essbase Cloud is finally among us. But what does that really mean? How does it fit into our existing EPM environments? What does Essbase Cloud actually do that’s better than before? What paths are not taken? In short, does Essbase Cloud live up to its promise? Join Tim German and Cameron Lackpour as they explore and explain Essbase Cloud’s’: architecture, functionality, use cases, cost, and performance. This comprehensive review of the essence of Essbase in the cloud gives you the answers and direction you need to go forward with Essbase now and in the future.

Back to Top
Analyst Seeks Analysis Tool: An Introduction
Steve Liebermensch , Mensch Consulting
Topic: Essbase - Subtopic: Other Essbase

An introduction to Essbase, you could consider this an Essbase 101 session. In this presentation attendees will learn about the why's and how's of Essbase including very basic design concepts, navigating a couple of the common user interfaces, as well as some the basics for query and reporting.

Back to Top
Oracle Analytics - Advanced Data Visualization with Essbase
Philippe Lions , Oracle
Topic: Essbase - Subtopic: Other Essbase

Summary to come

Back to Top
How to Get the Most Out of Essbase in the Cloud
John Maloney , TopDown Consulting
Co-presenter(s): Paul Hoch, TopDown Consulting
Topic: Essbase - Subtopic: Essbase-related technologies

Essbase in the Cloud has been eagerly anticipated and now that it is finally here we will explore how Essbase in the Cloud can replace, enhance or serve the same role as your current on-premise Essbase environment. This session is a thorough look at Essbase in the Cloud, including a look at the differences between on-premise Essbase and the Cloud offering, what you’re getting and what you’re giving up, best practices for working with Essbase in the Cloud, particularly if you are running a Hybrid EPM Solution, plus tips and tricks for how to make the most of Essbase in the Cloud. This session will also include a review of features like calculations, currency conversions, sandboxes, and other key things you need to know to get started. It will also include real-world examples. You will leave with a solid understanding on how to work with Essbase in the Cloud so that you can start taking advantage of all it has to offer.

Back to Top
IT Made Me Virtualize Essbase and Performance Sucks: Making Essbase Fast In Any Environment
Brian Marshall , US-Analytics
Topic: Essbase - Subtopic: Optimization

We can’t all have an Exalytics box for our Essbase environment. In fact, if you haven’t made it to the Cloud, then you are most likely already on a virtualized environment or being "encouraged” heavily to go to a virtualized environment. This presentation will focus on making sure that your transition is as smooth as possible. We'll discuss specific settings in the virtual environment, the operating system, and Essbase to get the most out of your server. We'll also compare specific benchmarks around different hardware configurations related to CPU, Memory, and Storage. Attendees will receive the new EssBench application for standardized benchmarks to see how your system stacks up. This application is deployable to any Planning server to test various aspects of your server’s performance to identify areas for improvement.

Back to Top
Extreme Essbase Calculations: New Frontiers in What-if, Goal-seeking and Sensitivity Analysis
Ron Moore , TopDown Consulting
Co-presenter(s): Ludovic DePaz, TopDown Consulting
Topic: Essbase - Subtopic: Calculation

Doing what-if isn’t new. As long as I can remember everyone talked about it and the goal-seeking functionality using LOOP has been around for decades. But do most of our calculations use causal drivers or are they “type it in and agg it up” type databases? And how much "what-if-ing" can you really do if the database takes an hour to aggregate?

Today more and more companies are using driver-based designs and recent improvements such as Hybrid Aggregation, new calculation functions, and bigger hardware mean that there are new possibilities. Profit opportunities don’t usually follow simple linear patterns. Well-designed driver-based models capture complex patterns and help identify risks and opportunities that would otherwise be missed. Goal-seeking can significantly reduce the time it takes to set and distribute targets. Sensitivity analysis can help set priorities by identifying the most important drivers. It can also help compare a range of options to identify sweet spots.

First we will examine the business logic behind some useful what-if calculations that help uncover financial dynamics that make a difference in business results. Then we will examine the outline and business rule considerations and options. Then we will dig into the code.
We will show examples of outlines and business rule code for:
• Pushing down top-side budget adjustments
• Driver based what-if calculations
• Goal-seeking for target setting
• Prioritization and range comparison with sensitivity analysis

Last we will show some examples of using these techniques in real-world applications.

Back to Top
Solving the Labyrinth – Advanced Essbase Reporting with OBIEE
Michael Nader , Huron Consulting Group
Topic: Essbase - Subtopic: Design

The Oracle Business Intelligence Foundation Suite contains two world-class modeling and reporting engines – Essbase and the Oracle BI Server. Integrating the two engines has, over the years, been complex. Often, the Essbase user community feels like they are losing capability. The reality is very much to the contrary; OBIEE provides opportunities for greater analysis.

This session provides two client case studies and tips and tricks for reporting on Essbase with Oracle Business Intelligence. This session contains live demonstrations of RPD modeling techniques for working with Essbase models, reporting tricks for dynamic filtering of Essbase reports, and leveraging advanced OBIEE capabilities for asymmetric reporting. In addition, the session provides recommendations for Essbase design to support the OBIEE reporting environment.

Back to Top
Eliminating the Eliminations Problem in Essbase
Martin Neuliep , General Electric Company
Topic: Essbase - Subtopic: Calculation

For as long as there has been Essbase, people building financial applications have wanted to perform intercompany elimination calculations. Unlike HFM, Essbase up to now has not had this capability built in. So what to do, especially if eliminations are a key part of your reporting or planning requirements? Various approaches have been taken over the years and interestingly, there may be no one ideal solution even today.
This session will compare four techniques for calculating eliminations: three purely within Essbase and a fourth using an adjunct relational database. We’ll examine each according to these criteria, so you can choose an approach best suited to your needs:
- Ease of implementation
- Amount of ongoing maintenance required
- Flexibility
- Performance
Code samples will be provided.

Back to Top
Break the Shackles of Planning with Hybrid Essbase
Peter Nitschke , Mpower Solutions
Co-presenter(s): Cameron Lackpour, ARC EPM
Topic: Essbase - Subtopic: Design

Planning is Essbase, Essbase is Planning. This powerhouse multi-dimension database enables Planning but then shackles it with BSO’s long aggregation time and ASO’s poor procedural calculations. Hybrid Essbase breaks these architectural constraints by combining the calculation power of BSO with the aggregation performance of ASO and as a result fundamentally transforms how we design Planning applications.

Join Peter Nitschke and Cameron Lackpour as they demonstrate the value of Hybrid Essbase through its impact on real world Planning design. You’ll see multiple Plan Type applications collapsed into one, Plan Types literally small enough to fit on a USB stick, real world performance benefits, and calculation techniques that take best advantage of Hybrid while working around its current limitations. The best use case of Hybrid Essbase is Planning and if you’re a Planning practitioner you should be using Hybrid Essbase. To do that, you need to attend this session and bring our real world Hybrid Essbase experience to your application today.

Back to Top
Apples to Apples Query and Calc/Aggregation Performance Measurement and Optimization
Daniel Pressman , nTuple
Topic: Essbase - Subtopic: Optimization

Learn how to make a true apples-to-apples test of your design decisions by learning about the interactions of Essbase and Operating system caches, in both BSO and ASO. Learn how to use RAMMAP to understand the IO behind your queries. Follow a detailed optimization of an ASO cube using these techniques, and see in detail how a number of successful -- and unsuccessful --design changes affect query performance.

Back to Top
Essbase Cloud Service -- Architectural Evolution
Kumar Ramaiyer , Oracle
Topic: Essbase - Subtopic: Design

Essbase Cloud Service:  How did it come about?  What are its architectural foundations?  Why does that matter?

To think that EssCS is an evolution of the Essbase we've known and loved since 1992 is to vastly underestimate its power and importance.  Moving to the cloud was an opportunity to completely remake Essbase from the ground up -- design, functionality, management, and hardware have all changed and for the better.    Understanding the conceptual, architectural, and technical forces that drove this fundamental shift will enable you to extract the true value of this transformation in your current and new applications. 

Join Kumar Ramaiyer, Vice President of Development at Oracle, as he explains how the confluence of development innovations and Essbase resulted in a database unlike any you've seen before.

Back to Top
Essbase Optimization from the Experts Panel Session
Edward Roske , interRel Consulting
Topic: Essbase - Subtopic: Optimization

BSO, ASO, hybrid, Essbase Cloud, Exalytics, virtual machines... with all these Essbase technologies, is there a standard for optimization anymore? In this panel, some of the top Essbase experts of today, tomorrow, and yesteryear will gather to share their wisdom and debate whose wisdom is more correct. Fireworks will definitely ensue as competing optimization tips fly around the room. Relationships may be strained, feelings may be hurt, and brains may be impacted, but rest assured that you will come away having learned that in the world of Essbase, while there is no right answer, there sure are a whole lot of wrong ones.

Back to Top
Tips and Tricks: Debugging a Broken Calc
Chris Schulze , The Hackett Group
Topic: Essbase - Subtopic: Calculation

Have you ever had a perfectly good calc script or calc manager rule fail to write the numbers you expected? This debugging guide will give you a reliable, reusable approach to resolve that pesky bug. You will walk out of this session with a simple list of things to try that will identify most of the bugs you’ll encounter. You’ll get done faster, and through the process, substantiate unit testing proof to satisfy your customer.

Back to Top
EssCS: The New Old Essbase
Glenn Schwartzberg , interRel Consulting
Topic: Essbase - Subtopic: Essbase-related technologies

Remember when Essbase could be installed from a floppy disk? You could get a cube running up and running and a couple of days. Well, those days are back with the new Essbase Cloud Service (EssCS). Essbase in the cloud takes us back to simpler times where you can build an Essbase database with a simple Excel spreadsheet template. All you need is Excel and Essbase on the Cloud. Join us for the session where we will walk you through Essbase Cloud Service and how to build Essbase applications in the 21st century. Don't miss this chance to get to know (reacquainted with) the new old Essbase.

Back to Top
Essbase Placeholder
Veronica Snow , Your Conference Connection
Topic: Essbase - Subtopic: Other Essbase

Essbase Placeholder for Oracle

Back to Top
Migrating to Essbase Cloud: Why, When, & How
Ronnie Tafoya , interRel Consulting
Topic: Essbase - Subtopic: Essbase-related technologies

Essbase is finally in the cloud! So should you consider migrating to the cloud? Join us for the session where we will introduce and demo Essbase cloud services. We will show you all the features and functions available in EssCS, show you what is the same between on prem and the cloud, and what is different. We will review how the steps to migrate your Essbase applications to the cloud and what roadblocks and pitfalls to look out for. We will then show you how to maintain your Espace applications in the cloud. - dimension builds,data integrations, automations, and more. Essbase in the cloud is not for everyone just yet – come to the session to learn when and why it would make sense for you.

Back to Top
Introduction to Java and the Essbase Java API
Tim Tow , Applied OLAP, Inc.
Topic: Essbase - Subtopic: Other Essbase

Many Essbase customers and partners have requirements that extend beyond the 'out-of-the-box' capabilities shipped with the product. Thankfully, Essbase is a platform that features a very robust Java API that provides nearly endless possibilities allowing customers the ability to leverage their Essbase investment. Attend this session to learn the basics of how to get started with the Java programming language and with the Essbase Java API.

Back to Top
We Make Energy Happen: Oracle EPM Client Success Story at Williams
David Wells , Williams
Co-presenter(s): Arijit Chanda, Williams
Topic: Essbase - Subtopic: Essbase-related technologies

After an enterprise-wide reorganization, the FP&A group was faced with growing business requirements, slow and outdated systems, missed deadlines, and frustrated users. Learn how Williams super-charged its EPM environment using Planning, Essbase ASO, and Dodeca to cut processing times from 4 hours to 15 minutes and increase data capacity by over 10 times. With the system bottlenecks removed, the Finance organization is not only meeting deadlines, but performing more-comprehensive analyses and other projects neglected previously due to system restraints.

Back to Top
Handling Textual Data in Planning and Essbase: A Starbucks Case Study
Jordan Wilcox , TopDown Consulting
Co-presenter(s): Rhonda Brigham, Starbucks Coffee Company
Topic: Essbase - Subtopic: Essbase-related technologies

Handling text data in a Hyperion Planning application is relatively easy and straightforward. Planning metadata is stored in a relational database. This textual information is accessible via web forms, HFR, and Smart View out-of-the-box. On the other hand, managing and reporting on text data is not quite as simple in the Essbase technology. Essbase handles dates and smart lists but can’t handles freeform text values. The situation is further complicated by the fact that your smart lists need to be synchronized between Planning and Essbase for the data transfer to be accurate. In this session, Jordan Wilcox, TopDown Consulting, and Rhonda Brigham, Starbucks, will discuss how they used a creative approach to get text data in three different forms–smart lists, dates and freeform text data–to flow from Planning to Essbase. They will discuss the overall project goals, technologies, POCs, and the reason for choosing the solution they did, including design and results.

Back to Top
Essbase Does it, but Dodeca Makes It Easy! (The Sequel)
Stuart Yasukochi , St. Jude Medical, Inc.
Co-presenter(s): Doug Pearce, Analysis Team
Topic: Essbase - Subtopic: Essbase-related technologies

St. Jude Medical identified three key technical hurdles to converting their worldwide planning applications to a single ASO database. Learn how Currency Translation, Workforce, and Supporting Details’ complex functionality was achieved using core Essbase functionality with Dodeca’s versatility. Seamless integration between relational input views and Essbase provided for employee-level workforce planning and generalized supporting details inputs. Simple operations in BSO are not so simple in ASO such as currency conversion. Join us to learn how SJM was able to surmount these obstacles with increased efficiency and reduced complexity.

Back to Top