Kscope13 Presentations

Check out the presentations listed below.



MDX and ASO: A Dynamic [Calculation] Love Story - Dynamically Calculated Investment Returns
John Anderson , Cervello
When: Jun 26, 2013, Session 12, 9:45 am - 10:45 am
Topic: Essbase - Subtopic: MDX

Showcase the power and flexibility of MDX within ASO as a "calculation" engine by using MDX to dynamically calculate annualized investment returns for any given user-selected time horizon.

Back to Top
Fixing What's Broken in the Essbase JAPI and Reaching New Heights with Groovy
Joe Aultman , AutoTrader.com
When: Jun 25, 2013, Session 9, 2:00 pm - 3:00 pm
Topic: Essbase - Subtopic: Other Essbase

There has been some buzz around the Essbase world in recent years, much of it promulgated by the presenter of this session, about automation using the Java API with the Groovy language. Now that people know about Groovy, and are learning a few things about putting it to use, it's time to start sharing code. This presentation will talk about the oddities and absurdities of the JAPI and what we can do about them. With Groovy metaprogramming, we can fix them and make the JAPI easier to work with than ever before. Come see the code and the techniques being used to tame the JAPI more and more and to do some truly exiting automation work, from metadata extracts to UDA manipulation to full system backups. Learn how to use the code yourself to do powerful operations simply.

Back to Top
Essbase and Planning Calculation Basics
John Booth , Blue Stone International
When: Jun 24, 2013, Session 1, 8:30 am - 9:30 am
Topic: Essbase - Subtopic: Calc Scripts

Don't know your @ABS from your @Xwrite? This session will clarify the calculation basics starting with the simplest calculation margin, and building on it to really explain what calculations really do. @children, @descendants, limiting syntax, the difference between dense and sparse calculation are all discussed and more. You will come away from this session with a more in-depth understanding on how and why you would want to write calculations certain ways. This session is also great for Planning users to understand their calculations.

Back to Top
Experts Panel: Essbase Block Storage Optimization
John Booth , Blue Stone International
When: Jun 26, 2013, Session 11, 8:30 am - 9:30 am
Topic: Essbase - Subtopic: Optimization

Join Essbase exports for an open forum on Essbase BSO Optimization.

Back to Top
Analytics Unleashed - Moving Beyond the Reports, Dashboards, and Spreadsheets
David Collins , MarketSphere Consulting
When: Jun 25, 2013, Session 10, 3:30 pm - 4:30 pm
Topic: Essbase - Subtopic: Optimization

This session will discuss and demonstrate the value of an analytic platform, such as Oracle Exalytics, as compared to the more static views delivered via reports, dashboards, and spreadsheets. The real value of data modeling lies in the three what's - what happened, what about, and what if. True modeling allows for both a driver basis and flexible query.

Back to Top
Exasizzle: Lesson from WellPoint's Proof of Technology with Oracle Exalytics In-Memory BI Appliance
Jonathon Eastman , WellPoint
When: Jun 27, 2013, Session 18, 9:45 am - 10:45 am
Topic: Essbase - Subtopic: No Subtopic

Looking into bringing an Exalytics machine in house? In this presentation, Jonathon Eastman, director of EPM at WellPoint, will guide you through his experiences from the data center to Essbase performance. The session will detail their hands-on experiences with exalytics, their performance benchmarks, and lessons regarding performance tuning. Hear how WellPoint went from top-line AIX servers to blisteringly awesome performance with Exalytics and the steps you should follow to make sure your Exalytics proof of technology goes extremely well.

Back to Top
Hands-on Training: Intro to Calc Manager for HFM
Eric Erikson , PQR Company
When: Jun 26, 2013, Hands-on Training F, 1:45 pm - 4:15 pm
Topic: Essbase - Subtopic: Hands-on Training

In this hands-on session, you will learn how to use Calculation Manager with HFM. You will also learn how to navigate the software and build common HFM rules, including how to use variables, objects, and rulesets. Once built rules will be deployed to HFM and backed up. Lastly, converting from Classic script to Calculation Manager will be covered.

Back to Top
MDX Simplified - A Methodical Approach
Jennifer Hanks , Kforce
When: Jun 26, 2013, Session 11, 8:30 am - 9:30 am
Topic: Essbase - Subtopic: MDX

Have you ever needed to write a complex Essbase member formula in an ASO cube? Have you struggled with getting the MDX right for the formula to work? This session will go over the types of MDX formulas available, some of the more commonly used MDX formulas, and discuss when each one should or could be used. A framework will be provided on how to methodically approach building an MDX member formula to ensure you get accurate results and allow you to build a super complex (and hopefully efficient) member formula to be used in your ASO database.

Back to Top
You Want to Change What? -- How One Company Adapted to Changing Requirements
Jennifer Hanks , Kforce
When: Jun 27, 2013, Session 19, 11:00 am - 12:00 pm
Topic: Essbase - Subtopic: Design

Change is a good thing. But what happens when business requirements change and the cube no longer fills the necessary requirements?Sometimes the change is as simple as a few outline updates. Sometimes, it is back to the drawing board and you are redesigning your existing cube. This session outlines what one company did to drastically redesign a cube to meet changing needs, while still maintaining and updating the existing history. See a way to harness the power of Essbase in your validation process of millions of updated rows of data. Find out how you too can take on a major rebuild to realize synergies within the business and add additional value to your business owners.

Back to Top
Pairing BSO and ASO Cubes
Michael Henderson , MJ Henderson LLC / Tethys Corp
When: Jun 24, 2013, Session 4, 1:45 pm - 2:45 pm
Topic: Essbase - Subtopic: Design

Block storage cubes are great for calculations; aggregate storage cubes roll up large dimensions in a heartbeat. Use BSO cubes for input and calculation and see the rolled up results in the BSO cube in real time. This session will present design considerations for pairing BSO with ASO to get the best of both worlds.

Back to Top
Power Tools: Using VAR + LOOP for If-Then Procedure Logic and ARRAY for Speed
Michael Henderson , MJ Henderson LLC / Tethys Corp
Co-presenter(s): Michael Henderson, Michael Henderson, LLC
When: Jun 26, 2013, Session 15, 3:00 pm - 4:00 pm
Topic: Essbase - Subtopic: Calc Scripts

Perhaps you've wanted to have a portion of your calculation selectively run or not depending on other conditions? The combination of VAR and LOOP can be used to do exactly that. Come see how. In addition, learn how to use the ARRAY calc script function. ARRAY is one of the most underused and powerful tools in the Essbase developer's bag of tricks. The speed and power of ARRAY can be put to work in any situation where a one or two-dimensional set of factors is used to calculate values such as currency translation, location-specific taxes, allocation of fixed costs to products or profit centers, and many more. ARRAY reads a list of values into a rapid-access array; repetitive fetches from disk are eliminated. This presentation will teach by example and demonstrate factor-of-ten performance improvements.

Back to Top
Travel the Path to MDX Mastery
William Hodges , The Hackett Group
When: Jun 26, 2013, Session 13, 11:15 am - 12:15 pm
Topic: Essbase - Subtopic: MDX

MDX may seem like a foreign language, but Essbase and Smart View enthusiasts are just steps away from the path to becoming MDX experts. The central message of this presentation is that one can effectively write MDX and increase productivity with a very small inventory of keywords and patterns. These can be learned quickly, especially if one is not distracted by things that are irrelevant to the task at hand. This presentation organizes the content into layers, first building a foundation and then becoming increasingly sophisticated. Build your MDX vocabulary from the ground up by following an easy to navigate path to MDX mastery.

Back to Top
The Best Reporting Solution You Already Own
Theron Jaquez , World Vision
When: Jun 27, 2013, Session 17, 8:30 am - 9:30 am
Topic: Essbase - Subtopic: Other Essbase

The company needed an inexpensive Essbase reporting solution. The presenter investigated the Report Writer included with the Essbase license. Combining Report Scripts, MAXL, MDX, DOS, and VB, the solution produces 3,500+ unique, fully-formatted reports (1 to 400+ pages) in 1 hour (10 mins to create reports and 50 mins to format).

Back to Top
Practical Essbase Web Services
Jason Jones , Key Performance Ideas, Inc.
When: Jun 24, 2013, Session 5, 3:00 pm - 4:00 pm
Topic: Essbase - Subtopic: Other Essbase

This session will give an introduction to using the new Essbase Web Services feature that has recently been added to the Essbase stack. Attendees will be given an overview of functionality available and practical methods of using the available technology effectively. This presentation will be geared towards users that are familiar with basic programming concepts.

Back to Top
A BSO Developer's Introduction to ASO Essbase
Cameron Lackpour , CL Solve
When: Jun 26, 2013, Session 13, 11:15 am - 12:15 pm
Topic: Essbase - Subtopic: Design

Many of us still live much of our Essbase professional life in the BSO world. Blame inertia, Planning, or fear, but regardless of cause, ASO is still terra incognita. What's it like on the other side? How do we understand what's there? This session will include a step-by-step conversion of that deceptively easy and definitely familiar sample. Basic BSO stalwart to Essbase will act as a mechanism to illustrate and explain ASO good practices. The final converted database will calculate the same values, but in a very different way.

Back to Top
The Power of UDAs, Substitution Variables, and Attribute Dimensions
Alice Lawrence , Walmart International
When: Jun 25, 2013, Session 8, 11:15 am - 12:15 pm
Topic: Essbase - Subtopic: Design

This presentation will show you how powerful UDAs, substitution variables, and attribute dimensions can be in the Essbase world. UDAs can be used to customize security, calc scripts, export scripts, and much more. Explore the differences between attribute dimensions and UDAs and when you may want to use one vs. the other. Examine multiple uses for substitution variables and see how combining these techniques can empower you to create parametrized scripting and simplify your maintenance.

Back to Top
Exalytics Now and Next
Steve Liebermensch , Oracle Corporation
When: Jun 26, 2013, Session 15, 3:00 pm - 4:00 pm
Topic: Essbase - Subtopic: No Subtopic

This session will explore the features and functionality released in Exalytics. Additionally it will describe some of the features we are currently working to develop for future iterations of the solution. There will be a definitive slant towards Essbase functionality throughout the session.

Back to Top
Optimizing Essbase on Exalytics
Steve Liebermensch , Oracle Corporation
When: Jun 27, 2013, Session 17, 8:30 am - 9:30 am
Topic: Essbase - Subtopic: No Subtopic

With the release of 11.1.2.3 of the EPM suite and the Exalytics engineered system launch several configuration settings and other commands were introduced. This session intends to describe them and their application in order to achieve optimal performance.

Back to Top
Using Calculation Manager with Essbase ASO
Josephine Manzano-Stettler , ADI Strategies
Co-presenter(s): Olivier Jarricot, ADI Strategies
When: Jun 26, 2013, Session 14, 1:45 pm - 2:45 pm
Topic: Essbase - Subtopic: Other Essbase

Get a sixty-minute cram session on using Calculation Manager with Essbase ASO. This session will navigate you through the key features within the Calculation Manager, specifically for Essbase ASO. The session will then guide you through the steps of creating calculation rules for ASO using the graphical interface and allocation and custom calculation components. Finally, the session will offer best practices and "insider" tips to shorten your learning curve and get you off to a turbo fast start!

Back to Top
Essbase Analytics Link - The Magic Decoder Ring
Brian Marshall , US-Analytics
When: Jun 27, 2013, Session 17, 8:30 am - 9:30 am
Topic: Essbase - Subtopic: Other Essbase

Essbase Analytics Links (EAL) provides a great mechanism for extracting data from Hyperion Financial Management (HFM) into Essbase. In addition, it now has the ability to extract data directly to a relational database. This session will explore real world uses of the three extract methods using EAL. Whether you simply need to replicate HFM exactly in Essbase or have a more complex need like blending HFM and Hyperion Planning data together in one Essbase model, this session will cover it. Live demonstrations of all that EAL has to offer will be provided including some undocumented ways of automating processes.

Back to Top
Hands-on Training: MDX Beyond Basics: Putting MDX to Work
Ron Moore , Marketing Technologies Group (MTG)
When: Jun 27, 2013, Hands-on Training G, 8:30 am - 12:00 pm
Topic: Essbase - Subtopic: Hands-on Training

So you've learned the basics of MDX and you are ready to take the next step. What are the next challenges as you begin to put MDX to use in real projects? In this hands-on lab we will cover practical application of intermediate to advanced functions, calculation order and optimization using real world examples of some of the most frequently used calculations such as: * Intermediate to advanced ratio analysis * Rolling calculations * User defined members and sets * Complex period-to-period comparisons * Balance forward calculations * Analytical functions We will make use of member formulas and queries. We will also make use of Smart View's Smart Query feature to illustrate how MDX can be used in end user reporting applications. We will also address some tricky calculation order issues and demonstrate optimization techniques.

Back to Top
Optimizing ASO Models Using Procedural Calculations
Michael Nader , Blue Stone International
Co-presenter(s): Martin Slack, Ernst & Young
When: Jun 24, 2013, Session 1, 8:30 am - 9:30 am
Topic: Essbase - Subtopic: Optimization

As analytic data sets grow, Essbase deployments are more and more focused on the ASO technology to take advantage of speed and scale. However, performing intricate calculations at run-time often leads to poor reporting performance. This session focuses on leveraging ASO procedural calculations and allocations to extend analysis and expedite reporting.

Back to Top
Hands-on Training: Essbase Studio for Beginners
Michael Nader , Blue Stone International
When: Jun 25, 2013, Hands-on Training D, 2:00 pm - 4:30 pm
Topic: Essbase - Subtopic: Hands-on Training

Join us for some Essbase Studio fun as we walk you through the basics and some intermediate concepts of the latest version of the Essbase Studio. Learn why Studio is the best way to create your Essbase applications and why its time to put EIS to bed. During the lab you will deploy an Essbase cube built from a relational source, learn how to update its properties and define drill-through reports to relational tables.

Back to Top
How ASO Works and How to Design for Performance
Daniel Pressman , nTuple
When: Jun 25, 2013, Session 9, 2:00 pm - 3:00 pm
Topic: Essbase - Subtopic: Optimization

Why are some cubes fast and some are slow? When is it OK to use MDX and when should (or what types of) MDX be avoided? How do Solve Order, Dynamic, and Stored Hierarchies interact? By understanding how Essbase goes about resolving a query, many of these questions will answer themselves. Much of this understanding comes from the cryptic Bitmap Statistics dialog in Cube Properties. All of this is summarized in 12+1 rules. These 12+1 rules are discussed and used to illustrate how they should be used when designing your cubes. In particular, there are implications and options for the design of alternative hierarchies. These options will be discussed in terms of the trade-offs of cost (in storage size) vs. performance (in retrieval time). Concrete examples will be demonstrated.

Back to Top
Performance Optimization and Measurement: New Thoughts and Test Results for BSO and ASO
Daniel Pressman , nTuple
When: Jun 26, 2013, Session 12, 9:45 am - 10:45 am
Topic: Essbase - Subtopic: Optimization

Have you ever wondered why some loads are fast and others are slow? Why the same query performs differently at different times? Why your queries and loads are not as fast as they should be? Then this is the session for you. Starting with a discussion of how data file IO is handled in Windows and Unix, techniques to ensure apples-to-apples testing are presented. Then using the results of over three hundred load, and calculate/aggregate tests using very large BSO (9gB input level 175gB Calculated) and ASO cubes (1.4 billion cells 84GB aggregated). The testing spans Windows and UNIX; ASO and BSO; varying cache settings; sort order and file formats are presented. These variables are evaluated and ranked with several new and surprising conclusions. Conclusions, that in some cases, run contrary to existing best practices. Finally, expanding on the chapter "How ASO Works and How to Design for Performance" in Developing Essbase Applications, the speaker will discuss surrogate keys, MDX, multi-attribute queries. All of this will be discussed in light of real world experience where multiple cubes are running and data is prepared and hardware supplied by other parts of the organization with differing practices and priorities. In short: real techniques you can implement when you return from the conference.

Back to Top
Everything You Know About Essbase Optimization is Incomplete, Outdated, or Just Plain Wrong
Edward Roske , interRel Consulting
When: Jun 25, 2013, Session 6, 8:30 am - 9:30 am
Topic: Essbase - Subtopic: Optimization

Hourglass configurations, optimal block sizes, dense/sparse configurations, correct cache settings, FIX vs. IF, all those things you learned in Essbase Bootcamp, read in the Database Administrator's Guide, heard Edward Roske preach, or learned at conferences... were created years and years ago. They were designed for 32-bit hardware under old versions of Essbase and sadly, no one has ever gone back and corrected them UNTIL NOW. This session will retest every optimization tip you know as gospel, and show what they should be under modern versions of Essbase running on high-end hardware. If you want to learn the top ten things that will shock you that you're doing wrong, don't miss this session. It may blow your mind, but it will be the most valuable session you ever attend on Essbase BSO optimization as we debunk everything you thought you knew.

Back to Top
Essbase New and Upcoming Features
Gabby Rubin , Oracle Corporation
When: Jun 24, 2013, Session 2, 9:45 am - 10:45 am
Topic: Essbase - Subtopic: No Subtopic

Over the last two years, Essbase footprint in the Oracle product portfolio had increase dramatically. In addition to being an application platform for many customer as well as Oracles own EPM applications, Essbase is a key part of Oracle BI Foundation, Exalytics and Fusion applications. These changes in the Essbase ecosystem along with other market trends such as cloud, require Essbase to adapt and evolve; But how do you prepare for the future while protecting your past? Join this session to learn about Oracles vision for Essbase and the product roadmap.

Back to Top
Advanced Essbase Studio Tips and Tricks
Glenn Schwartzberg , interRel Consulting
When: Jun 24, 2013, Session 5, 3:00 pm - 4:00 pm
Topic: Essbase - Subtopic: Other Essbase

Essbase Studio has been around since the beginning of version 11.1.X and there is still a lot of mystery around its usage. Come explore some of the more advanced features now that you have gotten your feet wet creating your first Studio model. This session will go over settings, optimizations, tips, and tricks that can make you more successful with Studio.

Back to Top
Thinking Outside the Box -- Optimizing Performance in Essbase and Planning
Glenn Schwartzberg , interRel Consulting
When: Jun 25, 2013, Session 10, 3:30 pm - 4:30 pm
Topic: Essbase - Subtopic: Optimization

There are standard optimizations that developers do to improve performance, then there are those developers who think outside the box and create unique optimizations that can affect calculations, data loads, data transfers, etc. Come to this session to see some unique solutions and truly outrageous ways to improve performance.

Back to Top
All About Allocations-Calculating Customer/Product Profitability and Transfer Pricing Using Essbase
Deanna Sunde , The Hackett Group
When: Jun 26, 2013, Session 16, 4:15 pm - 5:15 pm
Topic: Essbase - Subtopic: Design

See how an Oracle ERP customer, Herbalife, and other Oracle Hyperion Planning and Essbase customers have implemented profitability, transfer pricing, and allocation models to improve efficiency and effectiveness and to provide transparency to users instead of the process being a "black box." Using a case study approach, see how you can use Oracle Hyperion Financial Reporting and Smart View to drill from the receiver to the sending entities/cost centers with the associated allocation methodology; build Excel templates with Essbase to dynamically build allocation methodologies; create journal entries; and use Planning forms to make adjustments.

Back to Top
Advanced Essbase Java API Tips and Tricks
Tim Tow , Applied OLAP
When: Jun 24, 2013, Session 2, 9:45 am - 10:45 am
Topic: Essbase - Subtopic: Other Essbase

Essbase is a key component in the Oracle Fusion Applications strategy. As the Oracle Fusion Applications are written in Java, it is clear the Essbase Java API plays an important role in Oracle's future. Attend this session and learn Essbase Java API tips and tricks from one of the world's experts in the Essbase Java API. The session will cover some of the common issues developers encounter when writing Java API applications, as well as tips on how to build and maintain dependable software that utilizes Essbase.

Back to Top
Introducing the Outline Extractor NG (Next Generation)
Tim Tow , Applied OLAP
When: Jun 24, 2013, Session 3, 11:30 am - 12:30 pm
Topic: Essbase - Subtopic: Other Essbase

Although the OlapUnderground Essbase Outline Extractor has been downloaded by over 10,000 unique users, the technology used is quickly becoming outdated. The new Dodeca Essbase Outline Extractor is a complete redesign and rewrite of the popular Essbase Outline Extractor technology and adds the ability to output in Hyperion Planning Outline Load Utility format and to relational databases. It also adds the ability to run on 32-bit and 64-bit operating systems including Windows, Unix, Linux, and even MacOS. Attend this session to learn how to leverage this free utility in your company.

Back to Top
Introduction to Java and the Essbase Java API
Tim Tow , Applied OLAP
When: Jun 24, 2013, Session 4, 1:45 pm - 2:45 pm
Topic: Essbase - Subtopic: Other Essbase

With the emergence of Essbase as a key technology within the Oracle Fusion strategy, the Essbase Java API has become the lead API used by Oracle to develop robust applications. Attend this session to learn how to get started with Java and with the Essbase Java API. This session will cover the basics of creating an Essbase Java project, connecting to Essbase databases, and running simple tasks. The session will also review the types of functionality available within the Essbase Java API.

Back to Top
Hands-on Training: Working with the new Workflow
Rudy Zucca , 123OLAP
When: Jun 25, 2013, Hands-on Training C, 10:45 am - 12:15 pm
Topic: Essbase - Subtopic: Hands-on Training

Build out Workflow from scratch * Setting up Workflow. Hierarchies and assigning to planning units * Workflow from end user perspective * Setting up Workflow across multiple dimensions * Validation rules and workflow * Administration tips for Workflow Build out Workflow from scratch * Setting up Workflow. Hierarchies and assigning to planning units * Workflow from end user perspective * Setting up Workflow across multiple dimensions * Validation rules and Workflow * Administration tips for Workflow

Back to Top
Hands-on Training: Planning Form Design Tips and Tricks
Rudy Zucca , 123OLAP
When: Jun 26, 2013, Hands-on Training E, 8:30 am - 11:15 am
Topic: Essbase - Subtopic: Hands-on Training

Create forms exploring various Tips and Tricks * Substitution variables for making forms dynamic adjust months/years represented * Rolling forecasts * Dynamic variables * Business rules to spread inputs based on user selected options -- 445, even, historically based * Using validation rules and formulas * Composite forms

Back to Top
Find us on Facebook
Follow Us