Hardcore Hyperion Symposia Information has been Posted!
Hyperion Financial Management System Messages: Revealed! Christopher Barbieri, Ranzal & Associates
Chris Barbieri will explain where Hyperion Financial Management stores its system messages, and will show you how to decode the messages. During this session, you will learn how to use the HFM Event Viewer utility, and more importantly, how to respond to the variety of errors and informational messages, using several real world application logs.
This informative session will cover some of the advanced topics and tools for Hyperion Financial Management. Examples of topics include: learning how EPM Architect can simplify your application maintenance and deployment, how custom dimensions can simplify metadata, rules, grids and reports, and how Financial Data Quality Management (FDM) can provide improved integrations with your source systems. He’ll cover how to use Hyperion Data Relationship Management to improve the sharing of master data across your financial systems. This presentation will even get into some of the more hardcore tips such as customizing the entire HFM application—right down to the JSPs. Use the information presented in this session to not only impress your friends, but also to build efficient financial consolidation applications in HFM.
Enhancing Web Data Forms through JavaScript in Hyperion Planning Al Gutierrez, Textron
Textron will describe their Hyperion Planning shared data center and center of excellence. One of the key value-added features involves enhancing Web data forms with increased functionality through Java Script. See how this benefits one of the world’s leaders in the manufacture of automotive plastic fuel tanks . See how “the magic” helps improve performance in this world-wide application.
Oracle EPM 11 System Administration – Under the Covers! Eric Helmer, Linium Knowing the basic fundamentals of the Hyperion EPM architecture is a must for any type of user to help in troubleshooting every day issues and prepare for the unthinkable. Oracle Ace Director Eric Helmer shows you what you need to know as an Oracle EPM system administrator new or considering Hyperion EPM. Topics include Architecture, product intercommunication, ports, logs, health checking, diagnosing, and backups.
HAL is Dead, DIM is Dying, and ODI is Rudely Healthy. How Do You Make ODI Work in Your EPM System? Cameron Lackpour, Independent Consultant
You’re ready to take the plunge into ODI, but have heard that the learning curve is more like a cliff face. This presentation will give you the quick hits you’ll need to get ODI up and running. A brief overview of ODI’s infrastructure will be followed by an in depth look at automated sample metadata and data loading techniques with error trapping, e-mailing, and scheduling.
Hacking Hyperion Planning: Undocumented and Unsupported Tracy McMullen, interRel Consulting
Come with Tracy McMullen as she goes behind the scenes of Hyperion Planning to modify all those things that you’ve wanted to modify, but that are basically undocumented. Have you ever wanted to change the colors of the Planning interface? Modify the graphics that appear? Change the wording of items throughout Planning including names of workflow terms like promote and reject? Add custom code to the JSP (Java Server Pages) to modify anything and everything a user might see? In this session, you’ll learn these tips and more as you hack the entire Planning user interface. She will also cover the layouts of some of the underlying relational tables in case you ever need to modify them directly. While everything in this class is completely unsupported by Oracle, this is your one opportunity to get beneath the covers and customize Hyperion Planning to be unique to your company.
Convert Legacy Add-in Solutions in VBA to Smart View VBA or .Net Matt Milella, Oracle Corporation
Moving custom spreadsheet solutions built with the legacy (Essbase) add-in can be intimidating. This session will get you comfortable with the idea of moving these solutions to Smart View. This session will focus on the following: VBA equivalents in Smart View; new options in Smart View VBA, not in the classic add-in; creating .NET add-ins with VSTO (Visual Studio Tools for Office); and a development approach for successful conversions.
First Look - Smart View Extensions
Matt Milella, Oracle Corporation
This session will cover the Smart View extension framework and some of the new extensions that will be available for Smart View. Participants will get a look at extensions that add many ease-of-use features like Essbase calculations, substitution variables, quick options, and will also see an extension for advanced MDX style queries. This session will also cover the extension architecture and information on installing and deploying an extension.
Essbase ASO Performance – When NOT to Depend on MDX Dan Pressman, nTuple, LLC
Have you ever wondered what those bit/byte statistics are on the statistics page? This session will discuss what they are and implication to decisions on cube design and performance. Using this knowledge, you will be able to balance decisions on when to code functionality with pure MDX, and when to use alternate hierarchies and a little MDX. Specifically, this session will provide performance statistics on alternate methods of producing MTD, QTD, YTD, and rolling calculations.
Essbase ASO Tuning and Optimization for Mere Mortals Edward Roske, interRel Consulting
Don’t miss this important session where Edward Roske will share some of the best practices for designing and optimizing Essbase aggregate storage databases. He’ll discuss ways to optimize dimension and hierarchy design, understand when to use stored and when to use dynamic hierarchies, when to use the accounts and compression, and more. He’ll review the ASO caches, optimizing MDX formulas, ways to speed up data loads, and end-user retrievals. Join us for one hour of dedicated ASO optimization and tuning talk.
Hacking Essbase: Undocumented and Unsupported Edward Roske, interRel Consulting
This session goes beyond the documented side of Essbase to explore what’s going on behind the scenes. The first “Hacking Essbase” session covered how to hack substitution variables, data load rules, and passwords (shockingly). In this session, Edward Roske will dive even further into the inner-workings of Essbase to teach you all of those things that Oracle doesn’t document. Warning in advance, there is usually a reason Oracle doesn’t document these things, so use the tips you learn in this session at your own peril.
Advanced Essbase Studio: Tips and Tricks Glenn Schwartzberg, interRel Consulting
In this session, Glenn Schwartzberg goes beyond the basics of Essbase Studio, providing tips and tricks to help you fully take advantage of this new Essbase management console. Topics include: how to build more complex account dimensions, how to order the members within the outline and set member properties, how to build detailed drill through reports, and more. He’ll also cover those important “gotchas” and “missing features” to watch out for. Don’t miss this important session to help jump the hurdles of implementing Essbase with Essbase Studio.
5 Things You Can’t Do in Hyperion Planning (and how to do them . . . ) Jake Turrell, US-Analytics
Every packaged application has a defined set of functionality that the product addresses, but few customers are ever satisfied with these predefined limits. Technical experts who have worked with these packaged applications over many years often develop a “bag-of-tricks,” and are able to address many of these customer requests. This presentation will cover five commonly requested features in Hyperion Planning that aren’t available out-of-the-box, and how to address them.
Introduction to Custom JavaScript within Hyperion Planning
Jake Turrell, US-Analytics
Hyperion Planning provides developers with pre-built “stubs” where they can insert custom code to affect the functionality of a Web input form. This presentation will walk developers through the process of creating their first JavaScript customizations, and will provide several useful examples, tips, and tricks for creating more advanced customizations.
Using Hyperion Financial Management's SDK Christian Wetterwald, Oracle Corporation
This session will cover how to use Hyperion Financial Management’s SDK to maintain application maintenance functions (like data and meta data load and extract, process control automation, and journal handling) using batch jobs and customized front ends.
