Oracle Business Intelligence, Hyperion Reporting, and Data Warehousing
Implement Right-Time Data Loading with Oracle Warehouse Builder David Allan, Oracle Corporation
In this session, you will learn real tips and tricks on how to leverage the newest features in OWB for right-time data loading. You will learn how to leverage the file un-loaders and code templates to do fast-batch loading. You will learn how to leverage different code templates and some of the newest ETL features to run change data capture and real-time mappings within the same OWB product.
Back to Top
In-Database Fraud and Anomaly Detection Using Oracle Data Mining Charles Berger, Oracle Corporation
This presentation and demo will show several use cases of Oracle Data Mining's fraud and anomaly detection capabilities. How do you find needles in haystacks? How can you detect rare events, fraud, anomalies, and network intrusions in your corporate databases and operations? Find suspicious expense report submissions, find non-compliant tax submissions, combat fraud in healthcare claims, and save huge amounts of money in fraud and abuse using ODM.
Back to Top
New Data Warehousing Features in 11gR2 Stewart Bryson, Rittman Mead
Oracle Database 11gR2 brings extensive enhancements to the database server, which also improves and extends data warehousing functionality in this release. This session will investigate several new data warehousing features including modifications to parallel query, materialized view enhancements, and new SQL analytic functions. The session will include general explanations of these new features, architectural discussions of how they work, and live demonstrations of how they are implemented and used.
OBIEE 11g Integration with Oracle ADF Business Components Palaniappan Chidambaram, Oracle Corporation
With Oracle Middleware getting smarter and robust, it’s time to update the data source of OBIEE from relational database to Fusion ADF Business Model Components (light-weight Java View Objects). This is an efficient way to add pervasive BI to the enterprise applications built using Fusion ADF. Learn the new OBIEE 11g and Fusion ADF integration with added metadata on security, UI hints, and much more.
In-Depth (1/2 day): Data Warehouse Performance Best Practices Maria Colgan and Jean-Pierre Dijcks, Oracle Corporation
Have you wondered whether your data warehouse is getting the best performance it can? Or whether you've made the right decisions to keep your multi-terabyte system highly available? Attend this session to learn best practices for deploying a data warehouse on Oracle Database 11g. Using detailed examples and live demonstrations, this session will cover schema design, hardware considerations, data loading, partitioning strategies, parallel query, workload management, and more. Last but not least, you will learn how to monitor, diagnose, and correct performance issues. Using both the old reliable tools such as explain plan and AWR as well as an introduction to the latest and greatest SQL monitor tool. After this session you will be able to effectively design a data warehouse and administer and diagnose any issues that may arise.
Best Practices for Performance, Scalability, and Reliability with Oracle BI Enterprise Edition Mike Durran, Oracle Corporation
The initial setup and configuration of an Oracle BI system can reap benefits in terms of ongoing performance and reliability. This session describes the creation of a system that can scale to your enterprise from the initial install, configuration for optimum performance, ongoing monitoring, and troubleshooting tips.
Pushing the Envelope With Oracle Warehouse Builder Holger Friedrich, sumIT AG
Extremely important for DWH development is the knowledge about how the chosen tool can be put to work best. This presentation provides best practices for Oracle Warehouse Builder ranging from basic concepts like the deployment setup and configuration, up to advanced best practices and features. These include historization support, re-use of code with pluggable mappings and design automation using experts and scripting, as well as OWB's security framework for seamless development in a team.
Oracle OBIEE Metadata Modeling Best Practices and Tips for Concurrent Development Alan Fuller, Oracle Corporation
In this session, a senior member of the OBIEE product management team will cover best practices for metadata modeling in OBIEE including: using the power of the enterprise semantic layer for performance tuning and query optimization, rapid development processes, managing frequently encountered stumbling blocks, and making it easy for end users. Also covered will be tips for concurrent development of metadata across multiple developers.
Integrating Essbase and OBIEE: Implementing in the Real World Tracy McMullen , interRel Consulting
In "Integrating Essbase and OBIEE: An Overview," you learned what Essbase and OBIEE do from a conceptual standpoint. In this presentation, you'll learn how to actually implement the two products together. Edward Roske will cover when to build an Essbase cube and when to build a model through OBI Server. Most importantly, he'll cover how to implement the two simultaneously to get the best overall bang for your buck. Getting Essbase and OBI Server to work together can be challenging and admittedly, integrating the two can be frustrating. Join Edward as he gives you all the tips and tricks for using the two in conjunction to build a strong business intelligence solution. If you want to be implementing OBIEE and Essbase together, don't miss this presentation.
Oracle Business Intelligence Applications Essbase Integrator Matt Millela, Oracle Corporation
Oracle has a number of powerful business intelligence technologies in its portfolio, and we are rapidly integrating these technologies to provide more value and lower TCO for customers. In this session, Alaric Thomas will discuss how the Oracle BI Applications – Essbase Integrator will bring together the capabilities of the Oracle BI Applications and Oracle Essbase to further leverage a common applications information model delivering value to both IT and end users.
Essbase and Oracle Business Intelligence Application Integration - Real World Case Study Shyam Nath, IBM
This session will showcase technologies like Essbase, Oracle Business Intelligence Application / OBIEE, and Hyperion Strategic Finance and a real world case study of integrating these as part of a financial transformation project. Attendees will learn how to use the best of BI and EPM to design a solution that provides features like top-down budgeting and planning (HSF); maintenance of complex account and organizational hierarchy and summary data via Essbase; and detailed transactions and out of box reporting via OBIA/OBIEE.
Oracle Data Integrator 11g - New Features and Directions Francois-Xavier Nicolas, Oracle Corporation
This session will include introduction to Oracle Data Integrator, a presentation and a demonstration of Oracle Data Integrator 11gR1 new features. This session will uncover Oracle's future directions for data integration.
Inside the OBIEE BI Server Mark Rittman, Rittman Mead
The Oracle BI Server is the heart of an OBIEE system, and provides the query generation, security, caching and data integration capabilities of the product suite. The BI Server has an analogy in the Oracle Database in that it has various components (the Navigator, Cache Services, Execution Engine, Load Balancer, Session Management) that handle a query when it comes in, ensures query performance and handles large, concurrent groups of users.
This presentation looks at the internal processes and elements within the BI Server, examines how they handle incoming queries and varied data sources, looks at how memory is used and what diagnostics and tracing is available. Looking to shed some light on what goes on within the BI Server, and with a look to what is coming with the 11g release (subject to the information being made available from Product Development), this session takes an under-the-covers look at what drives performance and federation capabilities within the OBIEE suite.
OWB 11gR2 New Features Deep Dive Mark Rittman, Rittman Mead
Join Mark Rittman, Stewart Bryson, and Holger Friedrich for an in-depth, deep dive into the new features in Oracle Warehouse Builder 11gR2. In this demo-heavy, three-hour session, we will explain how new features such as code templates, integration with OBIEE, change data capture, and Web service integration works, and will take questions from the audience on what new features in this release are the most useful on projects. Join us for this extended deep-dive session and get the low-down on this important new release of OWB!
Integrating Essbase and OBIEE: An Overview Edward Roske, interRel Consulting
While Essbase and the Oracle Business Intelligence server are powerful apart, they are even more powerful together. In this session, Essbase users will learn what is OBIEE (Oracle Business Intelligence Enterprise Edition). OBIEE users will learn the value of Essbase. Edward Roske will then cover how to use the two product areas together to have amazingly fast reporting and analysis while having one common presentation and semantic layer. This is intended to be an introductory session to get all the OBIEE and Essbase users up to a common level of understanding. For tips on how to bring Essbase and OBIEE together as part of your implementation, you'll also want to attend "Integrating Essbase and OBIEE: Implementing in the Real World."
For those working with a financial application, Oracle Essbase or Oracle Business Intelligence Suite Enterprise Edition Plus, Oracle Hyperion Smart View for Office brings access to data and report templates and the ability to author reports in the Microsoft Office framework. This session gives an overview of this product and demonstrates new features. It also shows how to use it with Oracle Hyperion Planning, Oracle Hyperion Financial Management, Oracle Business Intelligence Suite Enterprise Edition Plus, and Oracle Essbase.
Web Services and Application Integration with Oracle Business Intelligence EE Suite
Toufic Wakim, Oracle Corporation
A variety of techniques can be used to build novel applications which extend the core capabilities of the OBIEE Suite. Approaches include URL-based integration, Web services leveraging SOAP methods, portal and WebCenter integration, and custom applications built in Oracle’s Application Development Framework (ADF) using Oracle JDeveloper - Oracle's main development tool for Java-based SOA applications. Each of these approaches and a few real-world examples will be discussed.
