Wednesday, June 5, 2013

What Kscope13 sessions am I looking forward to, part two

Introduction

I’ve already covered the Essbase side of the house in part one of this series. I lurv Essbase more that is likely healthy for my psyche. Or social life. But I seem to spend an awful lot of my professional life using a wrapper around Essbase. A wrapper called “Planning”. And that wrapper is a pretty powerful application in the EPM space, now with lots and lots of brand extensions.

One thing that I find interesting about Planning and all of the Financial Planning products is that many of these sessions are either focused on latest features or tips and tricks sessions with a few how-to’s thrown in. I suppose this is the nature of an application as opposed to a database, which tends to have a more theoretical bent. Or maybe I am just evincing that somewhat monomaniacal love for Essbase I wrote about above.

Whoops, before I continue, I should mention that I am friends with, or at least am acquainted with most of the people below. Am I just shilling for them? Nope, these are good sessions. Of course you pick and decide what you want to attend – this is what I am interested in.

Note – you will notice that the name Cameron Lackpour is absent from the below sessions. This is not some kind of false modesty as I do think that the Planning session I am copresenting is at least worth considering. I will cover that later in the week – this block is for everyone not named Cameron.

Planning sessions (stolen right off of Kscope13.com) with my comments

Planning at Transaction Levels while Maintaining Performance

Chris Boehmer , The Hackett Group
Co-presenter(s): Danny Frasco, Kimco Realty Corporation
When: Jun 26, 2013, Session 12, 9:45 am - 10:45 am
Topic: Planning - Subtopic: General Planning
Would you like to obtain greater detail in your planning or forecasting process - e.g., to plan for greater product or customer granularity, more periods, etc.? But you're afraid that your Planning application just won't be able to cope with these requirements? In this session, you will hear how an organization's desire to forecast a large number of detailed items for a long period of time led to some innovative solutions built to enhance their Hyperion Planning application.

Hmm, this is interesting – sort of the anti-driver approach to Planning. Of course I’ve been on projects like that myself. It’s all very well to say, “Enter a few items, and let the magic of Planning allocate and aggregate the results,” and quite another to actually have a client do that. I’m interested to see what their techniques are. Could it be a paired BSO/ASO approach with partitions or maybe a reporting cube or maybe something completely different? Dunno, but this is intriguing.

Calc Manager: Go Beyond Basics and Unleash the Power of Oracle Hyperion Planning

Ludovic De Paz , TopDown Consulting
Co-presenter(s): Terrance Sundar, Shutterfly
When: Jun 26, 2013, Session 15, 3:00 pm - 4:00 pm
Topic: Planning - Subtopic: General Planning
With Hyperion 11.1.2.3., Calc Manager is the only option to develop and deploy Business Rules. This is a fantastic opportunity for developers to leverage its latest advancements. This session will examine key features and functionality in Calc Manager and demonstrate how to successfully achieve your goals while improving quality. It will also include best practices, tips, tricks, and techniques that consultants, administrators, and end users can leverage to make completing projects and daily tasks easier.

I’m using Calculation Manager on my current project. I am not in love with the endless objects and drawings. I even had a client ask me, “Does it have to be all broken up like this?” But maybe we’re not giving the more GUI-ish nature a fair shot. For sure we aren’t using really advanced features. Could oh could oh could that be tied to treating Calculation Manager like a glorfied Essbase calc script editor. Why yes it could, so I am going to try to attend this session to see the error of my ways.

Planning Experts Panel

Natalie Delemar , Ernst & Young
When: Jun 25, 2013, Session 10, 3:30 pm - 4:30 pm
Topic: Planning - Subtopic: No Subtopic
TBD

Not a lot to go on, is it? I moderated this panel last year and it was a lot of fun. I’m not involved in the panel this year but I am looking forward to shooting a bunch of tough questions at whoever the panel is.

Dynamic Integrations for Multiple Hyperion Planning Applications

Ricardo Giampaoli , TERACORP
Co-presenter(s): Rodrigo Radtke de Souza, Dell
When: Jun 26, 2013, Session 15, 3:00 pm - 4:00 pm
Topic: Planning - Subtopic: General Planning
This session will cover how to use Oracle Data Integrator and Oracle Hyperion Planning metadata repository to build dynamic, flexible, and reliable processes to maintain metadata, load, and extract data from any number of applications with a single generic component.

If it has ODI as a component of the presentation, I am interested. I almost like ODI more for its ability to tie together completely heterogeneous technologies without a ton of scripting than I do for its base purpose, which is ETL. ODI rocks! Actually, I’m more of a classic jazz fan, but I’ll try to bebop my way to this session.

Automating Hyperion Planning Tasks

Kyle Goodfriend , Rolta Solutions
When: Jun 25, 2013, Session 9, 2:00 pm - 3:00 pm
Topic: Planning - Subtopic: General Planning
Maintaining Hyperion Planning environments can be so time-consuming that there is little time for development. We are constantly being asked to do more with less. Understanding some of the utilities and options to automate redundant operations can significantly improve your ability to react to change. It allows more time for new development, eliminates human error, and increases productivity and system stability. Find out what options are available, how to use them, and see real world examples you can take home.

Kyle must be a lazy programmer. Why do I write that? And no, I am not trying to insult him, as I too am a lazy programmer. What’s at least one definition of a lazy programmer? A lazy programmer is someone who sees a task that is manual or semi-scripted, does the task once and says, “There is no way I am ever doing that again.” He then sets off to write an automated whatever. ‘Coz he’s got better things to do. I suppose a really lazy programmer doesn’t even go through the pain once. I don’t know Kyle so I can’t determine if he falls into the moderately or intensely lazy camp.

NB -- Lazy = smart.

Oracle Project Financial Planning -- The Owner's Manual

Josephine Manzano-Stettler , ADI Strategies
When: Jun 26, 2013, Session 11, 8:30 am - 9:30 am
Topic: Planning - Subtopic: Project Planning
Oracle Project Financial Planning is the newest packaged application to be rolled out with the Oracle Hyperion Enterprise Planning Suite (v.11.1.2.3). This pre-built solution ties project financial planning to corporate financial planning activities within a single application, as well as, supports financial planning throughout the complete project management lifecycle. Want to find out more?...a LOT MORE? This presentation will dive deep into the new Oracle Project Financial Planning solution. The following will be covered: 1) Highlights of key out-of-the-box features, functionality, and analytical tools 2) Integration with the Workforce and Capex Planning Modules, ERP, and Project Management systems 3) Implementation considerations for a successful deployment 4) Minimizing customizations...Are your company's business needs the right fit for the packaged solution? Maximize your success for integrating Oracle Project Financial Planning into your Enterprise Planning tool set.

If Josie does it, it’s good. ‘Nuff said.

Managing Your Project Budgets: Introduction to the New Hyperion Project Planning Module

Tracy McMullen , interRel Consulting
When: Jun 24, 2013, Session 2, 9:45 am - 10:45 am
Topic: Planning - Subtopic: Project Planning
Hyperion Planning 11.1.2.3 adds a new pre-built module to the existing suite of Workforce and Capital Expenditure planning. This new module, Project Planning, fills the gap of how to budget for projects both short- and long-term before they become capitalized assets. Whether you want to budget IT projects from initial proposal through implementation, capital projects to expand facilities, or development projects out in the field, the new Project Planning module can handle them all.

Guess what? If Tracy does it, it’s good. ‘Nuff said, part two.

Did you know (or care) that in a previous professional life I once turned down dancing with Josie and Tracy? On a ship? In the middle of the Gulf of Mexico? I must have been out of my mind. :) I did have a cold. But still.

Introduction to Predictive Planning in Hyperion Planning

Troy Seguin , interRel Consulting
When: Jun 26, 2013, Session 12, 9:45 am - 10:45 am
Topic: Planning - Subtopic: General Planning
Version 11.1.2.3 of Hyperion Planning is including Crystal Ball's predictor feature. Predictor utilizes established time series procedures to help with forecasting upcoming time periods. This presentation will walk you through how to effectively use predictor as part of your budgeting and forecasting duties as well as an intuitive explanation of the concepts working behind the scenes.

I have to say I am somewhat on the fence about this one. No, no, not about Troy, or his presentation skills, or anything like that. It’s about statistics in the hands of your average Planner. Face it, people love to gamble. Face it again, the house (casinos, state lottery boards, Nathan Detroit’s The Oldest Established (Permanent Floating Crap Game In New York), etc.) always wins over time; those institutions must if they are to survive. And yet people gamble in the “sure” knowledge that they will win. But casinos, and state lotteries, and even incredibly charming minor organized crime figures with great singing voices understand how statistical probability works, and in their favor. Wait, I just figured out who needs to go to this session. I hope Frank Sinatra is there (at least spiritually) as well.

Turbocharge Your Hyperion Planning Input Forms with Predictive Planning

Jake Turrell , US-Analytics
When: Jun 26, 2013, Session 13, 11:15 am - 12:15 pm
Topic: Planning - Subtopic: General Planning
One of the most exciting new enhancements to Planning 11.1.2.3 is its new Predictive Planning tool. This new feature allows users to plot their projections alongside those created by Predictive Planning, giving users another data set against which they can compare their results. This live demo will walk users through the process of setting up Predictive Planning and will provide several real-world examples. The session will cover: - When to use Predictive Planning and when to avoid it - Basic statistical concepts used by Predictive Planning - How to best configure input forms for Predictive Planning - A walk through of the Predictive Planning user interface - Running predictions. - Using Comparison Views to review the results of various scenarios - How to tweak your results with filters and reports Users will leave this session with the tools, knowledge, and confidence to implement Predictive Planning in their own environments.

If Troy’s presentation above is the theory, then Jake’s session is the application. So that makes Troy a physicist and Jake an engineer.

Lower your TCO With Oracle Planning and Budgeting Cloud Service (PBCS)

Shankar Viswanathan , Oracle Corporation
When: Jun 24, 2013, Session 5, 3:00 pm - 4:00 pm
Topic: Planning - Subtopic: General Planning
PBCS takes the best of breed Hyperion Planning solution to the Cloud with a compelling offering for companies looking to lower TCO by deploying their applications on the Cloud using the top Planning solution in the market. This session will introduce participants to the upcoming Planning Cloud offering from Oracle. Participants will hear the details of the offering and get a sneak preview of Oracle's Planning on the Cloud offering.

Oracle? Again? Do you want to hear about how Oracle’s cloud service works? Would the Planning product manager be the person to tell you all about it? Why yes, you should and he is. See, this is what makes Kscope so great – we the great unwashed get to interact with the people that make the products we use.

What's New in Planning?

Shankar Viswanathan , Oracle Corporation
When: Jun 25, 2013, Session 8, 11:15 am - 12:15 pm
Topic: Planning - Subtopic: General Planning
The latest Release 11.1.2.3 of Oracle Hyperion Planning takes Enterprise Planning to the next level by providing some valuable agile enablers within Planning. This session will discuss and showcase some of these key features in this release, and provide several good considerations for customers to help choose this release as the go-to release for deployment and upgrade.

I have but one question – Planning ASO, is it any good? This is where I will hear about it for the first time. I hope.

Are you crying Uncle yet?

That is 11 different Planning sessions. Is that the sum total of Planning sessions at Kscope? Absolutely not. In fact there are 31 on offer. And that is just a subset of all the EPM sessions. Kscope has content, content, content.

The next blog post will be The Truth About Hyperion EPM Foundations and Data Management at Kscope.

Be seeing you at Kscope13.


Saturday, June 1, 2013

What Kscope13 sessions am I looking forward to, part one

Introduction
This is always a tough one because there are so many good sessions at ODTUG’s Kscope conferences. If you’ve read my posts in years past on the conference, you will know that I have ranted and raved about the unparalleled knowledge sharing, the training, the networking, the vendor expo (you would be amazed at what’s out there and I am a full member of the does-not-have-contract-signing-ability crowd and I still find it useful), the fun, etc., etc., etc. If you aren’t convinced by this point you either don’t read this blog (in which case I have to ask how you come to read this sentence) or you really don’t pay attention.

And because there is so much good stuff I am going to split my review (yet another sort-of tradition in this blog) of sessions I want to attend across multiple posts. There is just too much cool stuff going on and I want to give these sessions the due they deserve. And not write the Kscope equivalent of Gibbons’ The History of the Decline and Fall of the Roman Empire, at least from a length perspective.

With that, let’s kick off with my very favorite technological product: Essbase.

Whoops, before I continue, I should mention that I am friends with, or at least am acquainted with most of the people below. Am I just shilling for them? Nope, these are good sessions. Of course you pick and decide what you want to attend – this is what I am interested in.

Note – you will notice that the name Cameron Lackpour is absent from the below sessions. This is not some kind of false modesty as I do think that my sessions are at least worth considering. I will cover what I am presenting later in the week – this block is for everyone not named Cameron.

Essbase sessions (stolen right off of Kscope13.com)

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.

You’ve seen Jason pop up on this blog a few times – he is a real developer. I am not, sob. And I suspect most of you (apologies to those who are full time Computer Scientists) are not either. So let’s learn from a guy who has written real honest to goodness commercial software.

Using Calculation Manager with Essbase ASO

Josephine Manzano-Stettler , ADI Strategies
Co-presenter(s): Olivier Jarricot, ADI Strategies
When: Jun 26, 2013, Session 12, 9:45 am - 10:45 am
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!

In a previous life, I worked on one of Josie’s projects. She is all kinds of awesome. Also, I was on a project last year that screamed ASO as its solution. I had everything working except those !@#$ing level zero rate calculations and it was an interactive (budgeting) application. The client was an 11.1.1.3 environment so we were out of luck, to put it mildly and BSO it was. I am super curious to see what BusyGal (her online moniker) has come up with.

Big Data and Analytics-led EPM

Al Marciante , Oracle Corporation
When: Jun 24, 2013, Session 1, 8:30 am - 9:30 am
Topic: Essbase - Subtopic: No Subtopic
What data is important to analyze in order to sign off on consolidated financial data or for accurately creating forecasts and budgets? How do users efficiently identify the key drivers and model possible financial outcomes based on uncertainty? This session will highlight the synergies between Enterprise Performance Management and Business Intelligence, and will showcase how the two together allows customers to propel their performance.

An Oracle presentation? Aren’t they just great big advertisements for Oracle? Not at Kscope they aren’t. Big Data, Big Data, Big Data, Big Data – it’s everywhere. Does it fit in EPM? I am super curious about this.

Optimizing ASO Models Using Procedural Calculations

Michael Nader , Blue Stone International
Co-presenter(s): Martin Slack, Ernst & Young
When: Jun 26, 2013, Session 16, 4:15 pm - 5:15 pm
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.

Did you read the above session by Josie Manzano-Stettler? This is the other side of calculations in ASO Essbase. I am, again, very, very, very interested in this subject.

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.

This is one of those rare sessions that is a repeat from last year. Reruns? At Kscope? What, you want your money back? Trust me, this is worth repeating, both for those of us who attended last year and for the people who were foolish enough not to attend. Why? Because Dan has deconstructed the ASO kernel better than anyone whose email address doesn’t end in @oracle.com. It is a brilliant presentation.

Performance Optimization and Measurement: New Thoughts and Test Results for BSO and ASO

Daniel Pressman , nTuple
When: Jun 26, 2013, Session 14, 1:45 pm - 2:45 pm
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.

I am somewhat familiar with the tests Dan has conducted. He has a very interesting take on what makes Essbase databases fast.

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.

Oracle again? If you are interested in where Essbase is going, this is your best bet to hear all about it from the Oracle Product Manager himself. Will he deny everything he says the minute he steps out of the room? Probably. Will many of these projected roadmap items show up at Open World as publicly committed-to features? It has happened. :)

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.

Glenn is my older brother from completely different parents. Of course he denies any actual familial relationship. Just like an older brother. You decide who has a firmer grasp on reality.

Clawing my way back to relevancy, Studio is a product that I seem to be drifting closer and closer to with the increasing level of SQL and ETL that I do on each project. Glenn’s sessions are always interesting and entertaining.

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.

I reviewed the first draft of this presentation – again, Glenn has an unusual mind (shades of Young Frankenstein?) and always comes up with how-the-h-e-double-hockey-sticks techniques.

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.

I’ve been on the beta (and have been a terrible beta participant, sorry Tim, but Kscope has eaten my life) for the NG extractor. This is the tool that we will all use going forward.

I for one am looking forward to running the NG OE on my Fat Mac.

Are you crying Uncle yet?

That is ten, count ‘em ten, different Essbase sessions. Is that the sum total of Essbase sessions at Kscope? Absolutely not. In fact there are 38 on offer. And that is just a subset of all the EPM sessions. Kscope has content, content, content.

The next blog post will be The Truth About Hyperion Planning at Kscope.

Be seeing you at Kscope13.

Popular Posts