“We’re excited about joining the technical community for the Kaleidoscope conference in our home state of Texas this year,” said Jon Rambeau, Director of Consulting at US-Analytics. “There’s no better place to hear world renowned speakers in business intelligence and data servers and share your expertise with others.”
“We’ve become well-seasoned veterans to the Kaleidoscope conference in the past few years, and believe it's one of the most informative and beneficial conferences for the Oracle Hyperion and Essbase community,” said Wayne Conrad, Vice President of US-Analytics. “We're looking forward to sharing our expertise in our presentations this year."
The consulting firm will cover the following:
Large-scale ASO, Making Essbase Silky Smooth with Terabytes of Data
Brian Marshall, US-Analytics >> Monday June 25, Session 5, 4:15 pm - 5:15 pm
So you have a giant cube with giant dimensions and giant data sets. No problema! ASO can do that. Drawing from experience with real clients, learn some simple tricks and some advanced techniques to maximize your ASO database performance. Do you have millions of members? Do you have billions of rows of source data? Do you have a huge server with lots of resources and vast Essbase potential? If so, this presentation is for you. From changing configuration settings to changing outline settings, if you want to get the most out of your large-scale ASO database, this is a must-see session.
Data-driven Rules in HFM
Keith Berry, US-Analytics >> Tuesday June 26, Session 8, 11:30 am - 12:30 pm
Data-driven rules are rules that generate focused transactions in response to specific data in HFM. Data-driven rules can be faster, safer, and easier to write than more standard approaches. As data volumes rise with the introduction of 64-bit HFM, the technique should be an essential part of every HFM developer's toolkit. The presentation will cover the benefits and pitfalls of data-driven rules and how to identify where they should be used. The majority of the session, however, will be spent learning the key functions of data-driven rules and working through practical examples.
HFM vs. Essbase BSO: A Comparative Anatomy
Keith Berry, US-Analytics >> Tuesday June 26, Session 9, 2:15 pm - 3:15 pm
So, you're working on a joint HFM/Planning implementation and want them both to perform with lightening speed. What makes Essbase fast should work in HFM, right? Well, maybe! This presentation will compare in detail the inner workings of HFM and Essbase BSO and highlight the different strategies used by each system to process data. The session will discuss where familiar Essbase concepts such as dense/sparse, block size, dynamic calc, etc. apply to HFM and where they don't. The session will highlight the different design principles needed to optimize each system and touch on other issues (shared hierarchies, data integration) designers face on joint HFM/Planning/Essbase implementations.
Opening Pandora's Box: The Planning Repository
Brian Marshall, US-Analytics >> Wednesday June 27, Session 12, 8:30 am - 9:30 am
Hyperion Planning provides an excellent platform for deploying enterprise-scale budgeting and forecasting solutions. However, the Hyperion administrator's options for reporting on the underlying metadata repositories are limited. This task is further complicated by the de-normalized nature of the tables. This presentation will expose many of the secrets of the Planning Repositories and provide a set of pre-built queries ready to deploy. Attendees will receive printed and digital copies of all queries along with explanations of specific functionality and a live demo of the content.
Hyperion Planning Approvals and Data Validation
Jake Turrell, US-Analytics >> Wednesday June 27, Session 14, 11:15 am - 12:15 pm
With the release of Hyperion Planning 11.1.2, Workflow and Data Validations are tightly integrated. This presentation will walk attendees through the process of configuring Approvals. A detailed live demo will highlight each of the three Approvals templates and show how Data Validations can be inserted into the workflow process.
Running Hyperion Planning on Your Laptop
Jake Turrell, US-Analytics >> Wednesday June 27, Session 15, 1:45 pm - 2:45 pm
Hyperion Planning and its related applications represent an increasingly complex and frequently changing set of tools. The associated learning curve is significant, and staying up-to-date can be difficult. Developers who want to master these tools need an environment where they can learn and experiment without affecting a "real" environment. A personal EPM Sandbox environment is a critical tool for any serious developer or administrator who wants to gain a deeper understanding of Hyperion Planning. This presentation will provide attendees with a step-by-step guide to getting Hyperion Planning up and running on a laptop.
Essbase/Planning Metadata Management with ODI Across Environments
Terry Ledet, US-Analytics >> Wednesday June 27, Session 15, 1:45 pm - 2:45 pm
As an Oracle Essbase/Oracle Hyperion Planning administrator, do you need to compare outlines between development, test, and production to quantify the differences? Do you need a method to know all members with a certain UDA, Attribute, etc? This hands-on session will demonstrate how to utilize Oracle Data Integrator (ODI) to extract the Essbase outline to a relational database table which can be queried. The session will then demonstrate a similar technique for Planning. ODI will then be utilized to determine differences in outlines between environments based on the context selected in ODI.
US-Analytics encourages enthusiasts to join them at ODTUG Kaleidoscope this year by registering online.