EIS vs. EAS vs. Essbase Studio: Which One Should We Use? Charles Chew, U.S. Forest Service
Don’t miss this session where Charles Chew will review the alternatives for Essbase maintenance and show the good, bad, and ugly of each tool. Many struggle with this same decision and this session outlines his decision and the factors that played into it (and how the answer would be different in Essbase 11x). You’ll leave this session with a better understanding of the maintenance methods for Essbase including new options like Essbase Studio and EPM Architect.
The presentation will cover techniques for implementing aggregate storage applications. Topics covered will include: design challenges and how to overcome them, building dimensions, loading data, performing aggregations, formula performance, ongoing care, and feeding.
Essbase ASO: The Best Thing Since Sliced Data Gary Crisci, Morgan Stanley
While the Essbase Aggregate Storage Option may not be the best things since sliced bread, it is the best thing since people started slicing and dicing data for analytics. Join Gary Crisci, Oracle ACE, in this introductory session to the Essbase Aggregate Storage Option. Fundamental concepts will be discussed around designing, building, and tuning an ASO database. Appropriate contrasts will be made with the Essbase Block Storage Option.
Top 10 Tips for a Successful Essbase Implementation Natalie Delemar, ISA
Most Essbase presentations focus on the technical side of an implementation. In this session, you’ll learn about some of the management decisions you’ll need to make to ensure your project completes on time and under budget. If you want users who are ecstatic about the system you’re building, be sure to learn our top ten tips to make your Essbase implementation a successful one.
Unparalleled Benefits of using the Perl Module in the Essbase Implementation at Shopzilla Inc. Jullin Egbuji, Shopzilla Inc
At Shopzilla, implementing the Perl module has allowed flexibility in the cube build process with great impact on our SLA. In addition, it is used to build a rich source of analytical data that contributes to the planning and scalability of Essbase cubes within the company, which is visible on our OBIEE dashboards. Implementations include: parameterized Perl scripts for cube build, delivering running 7, 30, 90 date hierarchy, messaging, data validation, cluster and load balancing, logging, and much more.
Hyperion SmartView Automation with VBA Robert Gideon, Wells Fargo Home Mortgage
This presentation will introduce Essbase developers and users to Visual Basic for Applications (VBA) and the SmartView spreadsheet toolkit. The presentation will show how to convert from the classic Essbase add-in toolkit to SmartView VBA functions; automating data refresh and submit tasks for budgeting; and examples of other functions and their usefulness. An overview of other SmartView VBA functions will round-out the presentation.
Managing Essbase and Dodeca Support and Development Matthew Holt, Kroger Co.
The focus of this session will be to look at one solution for consolidating support and development of Essbase and Dodeca, which is currently spread across multiple lines-of-business, and reorganize it into a single department, or center-of-excellence, using only existing resources. In addition, discuss how we brought Essbase out of the shadows and defined the partnership between the business units and IT, which allows each group to do what they do best.
Introduction to Development with the Essbase Java API Jason Jones, The Kroger Company
Assuming no prior knowledge, learn how to use the Essbase Java API to develop Java programs that extend the functionality and usefulness of your Essbase capabilities.
Building Essbase Cubes with Essbase Studio Alan Lee , Oracle Corporation
This presentation includes an overview of Essbase Studio, outline advantages and best practices for Essbase Studio, as well as demos of the latest release and new features.
What's New in Essbase
Alan Lee, Oracle Corporation
The recently released version of Oracle Essbase offers a wide range of new functionality that covers areas including product innovation, usability, integration, and enterprise readiness. This presentation will describe and demonstrate new features that include powerful new APIs, native failover capabilities, and enhancements to Essbase Studio.
Essbase Custom-Defined Functions - The Hidden Gem Brian Marshall , US-Analytics
Learn how to take advantage of Essbase custom-defined functions in the real world with how to tips, integration with Cloud data, and custom calculation algorithms.
Essbase Optimization at Cash America: Speeding up Essbase Cubes by More than 90 percent Scot Martin, Cash America
You’ve been to a bunch of Essbase optimization sessions and learned some helpful theories. You may have even read the incorrect optimization recommendations in the DBA Guide. What works in the real world? In this session, Cash America will walk you through the optimization of their Performance Accountability Essbase cube. They’ll review key tips when designing and optimizing Essbase databases, showing you what worked and what didn’t.
Inner Workings of Essbase: ASO and BSO Secrets Revealed Tracy McMullen, interRel Consulting
Would you like to know some of what the Essbase developers know about the underlying Essbase storage, calculation, and retrieval engines? Join Tracy McMullen, Oracle ACE Director for Essbase, for an informative session designed to give you a thorough understanding of what actually happens when you are creating BSO and ASO cubes. Go beyond “laboratory theory” and learn what Tracy has gathered from fifteen years of experience with Essbase customers around the world. She’ll cover topics including how data is compressed, cached into memory, calculated, and accessed. For a true “insider’s view,” don’t miss this session!
Essbase Calculations - A Visual Approach Ron Moore, MTG
Thinking about calculations in many dimensions can be a real brain teaser, especially for beginners. But here is a methodical approach that will help you formulate Essbase calculations in almost any situation. This approach significantly increases the scope of work beginners can accomplish. It also illuminates some of the most confusing aspects of Essbase calculations. This session starts at the basics and moves quickly through cross-dimensional operators, relationship functions, @XREF, and simple allocations.
The New Hyperion Calc Manager Chad Norton, American Family
Don’t miss this session to learn more about the new totally-free Calc Manager and how it can dramatically reduce your development time while allowing your end users to maintain their own business logic. Calc Manager provides a single user interface for constructing the logic of HFM, Planning, and Essbase applications. Attend this session if you want to learn the newest way of developing business rules (and calc scripts).
Using Essbase 11 Text Measures to Pump Up Your Analytic Capabilities Doug Pearce, Analysis Team, Inc.
The presentation will discuss various options considered and tested when solving for a high-dimensionality problem around large retail promotions tracking and analysis, leveraging various capabilities unique to Oracle Essbase System 11.
Configure it Out Edward Roske, interRel Consulting
Essbase users are confused by the myriad of configuration settings available to them. The number of variety of settings has expanded significantly through the versions of Essbase, with EPM version 11 having more options than ever before. This session reviews different settings, when to use them, and what settings are used in conjunction with other settings. The session will explore simple settings every config file should have, to the specialty settings used in unique situations.
Load Rules Basics to Advanced Glenn Schwartzberg, interRel Consulting
This session has a little bit for everyone. From the very basics of dimension building and data loading to more advanced features like substitution variable in rules, data maniplation, SQL interface, and advanced settings. We will cover some of the lesser used features so you can expand the versitility of rules.
MDX is the direction of the future, but how do you actually code in it? This session will walk through some of the basics with real world examples. How do you do multiple crossjoins (and why), what is the syntax for getting descendants, the first child, what can you do in MDX that you couldn't in Calc scripts?
