ODTUG Kscope12 - Kscope12

Learn more about Oracle's Performance Management and Business Intelligence Suite in this overview of the products and how they are used. This session will show examples of what's new in those modules and where your company should start.

Come explore the world of Essbase load rules. Learn how to use load rules for both dimensions and data. Explore the various load rule methods and how to optimize your data for loading. Common problems and how to solve them will also be discussed.

Go beyond the default calculations and learn how to use commands and functions in formulas and calculation scripts to enhance your cube and give you better performance. Topics to be discussed are how calculations work, the effect of dense and sparse settings, limiting data to be calculated (Fixes and Ifs), and a whole lot more.

This presentation will introduce the attendee to Calculation Manager. Calculation Manager is the new tool to create business rules and business rule sets to run against Hyperion Planning and Oracle Essbase. By attending the presentation, the attendee will learn about differences between Calculation Manager and Hyperion Business Rules, as well as see a live demo of the tool to develop and deploy business rules to a Hyperion Planning application.

New to Essbase? This session will guide you through thinking multi-dimensionally. It will explain the different types of Essbase cubes and what you need to consider when building your cubes. It will cover topics such as: dimensions, structures, alternate hierarchies, and attributes.

One of the exciting new features of Oracle Essbase 11x is the new Oracle Essbase Studio. You may have heard the buzz about this new Oracle Essbase design and management tool. Attend this session to learn the details of this big enhancement. Oracle Essbase Studio enables you to connect to several sources and build Oracle Essbase models more efficiently. Oracle Essbase Studio also adds new features such as XOLAP and expanded drill-through to sources beyond just relational databases (drill to anywhere). Oracle Essbase Studio will eventually replace both Oracle Essbase Integration Services and Oracle Essbase Administration Services, so start the learning process now.

This presentation will include ten to fifteen steps to become an FR Studio Expert. Users with no Financial Reporting Studio experience will benefit from this presentation the most. At the end of the presentation, participants will understand the benefits of using FR Studio, learn the pros of FR Studio vs. using Excel reports, and see that FR Studio could be mapped to various database resources. Participants will also get to see a demonstration of building a Profit and Loss Variance Report using FR Studio.

This session is ideal for the brand new Essbase developer who wants to understand this new technology. One of the key challenges early on is being able to draw correlations between Essbase and other technologies you are used to (maybe SQL Server, or DB2, or Oracle Databases) working with. Working from a long history of training and mentoring new developers, this session will draw on real-life examples and techniques for assisting the user in understanding what Essbase is and how it fundamentally works.