ODTUG Kscope12 - Kscope12

The Data Warehouse Administration Console (DAC) plays a key role in creating and managing the Oracle BI Applications Warehouse. Understanding DAC will greatly help ETL administrators in understanding various aspects of Oracle BI Applications and will give pointers on where to troubleshoot and resolve issues. The features covered in the session will include intelligent task queue, parallelism, load balancing, index management for ETL/Query performance, and several other tips and tricks that will allow the users to build execution plans tailored to their specific needs.

Oracle Business Intelligence Applications provide significant uplift for organizations seeking to shorten time-to-value of BI investments. Maximizing the benefit of these modules requires a different approach than traditional reporting and analysis initiatives. This session will take a deep dive into the process of implementing BI applications from a business perspective, examining sample project templates to set expectations and milestones.

This presentation will examine common techniques for modeling transactional schemas as logical facts and logical dimensions in the OBIEE Business Model and Mapping Layer. Some of the common techniques that will be introduced include: presenting a physical table as both a logical fact and a logical dimension, controlling the BI Server's behavior using table aliases and logical table sources, and integrating multiple source systems' entities into the same logical table.

Aggregate navigation describes the functionality that BI systems have to use summary level data instead of detail level data for faster data access and report performance. When using Oracle Business Intelligence 11g and Oracle Database 11g, we can choose which “engine” we want to handle summary management and the navigation between different levels of granularity: the BI Server, or the Oracle Optimizer. Both methods support full summary management functionality, and either one is robust enough for an enterprise data warehouse. So which one should we choose? This presentation will walk the participants through both options, and investigate the different design paradigms that may favor one implementation over the other.

Nikos Psomas, Oracle Corporation

Take a deep dive into the details of an RTF template and see how to put data fields into the header, calculate page totals, embed barcodes, put terms and conditions on the back of pages, get data on the last page only, and other tricks to design your highly formatted documents. Oracle Business Intelligence Publisher is Oracle's strategic enterprise reporting solution for authoring, managing, and delivering all types of highly formatted documents for over thirty Oracle Applications and Products.

In this presentation, attendees familiar with OWB will be able to apply that knowledge to understanding ODI. This session will walk through the ODI architecture, drawing comparisons to comparable OWB components, and also pointing out where the two products are quite different. The session will discuss common OWB features and functionality, and demonstrate how those same tasks would be achieved with ODI, including: Mappings, Expressions, Transformations, and Process Flows.

This presentation discusses how to configure BI Server, in order to make best use of an Oracle 11gR2 database's resources. The presentation will discuss different aspects to consider, options that BI Server gives us, and how the database can be utilized for best query performance as well as workload management. With real-world example queries and workloads, learn how configuring the BI Server on system, object, and query level delivers best individual and overall performance. Advice will be given about what to discuss with DBAs in order to have them prepare their environment such that BI solutions get superior performance.

Learn about the Oracle Exalytics In-Memory Machine. This overview will complement other deep-dive sessions, and will describe Exalytics’ best-in-class hardware plus BI platform and in-memory software optimizations. How the Exalytics engineered system delivers a dynamic user interface and speed-of-thought style of visual analysis will be covered. Described also will be Exalytics’ certification for Oracle’s Analytic Applications – where out of the box support drives fastest time to value and extreme performance for ERP, CRM, EPM and industry-based solutions.

The purpose of this presentation is to provide attendees with a detailed introduction to the technical components of the Data Vault Data Model, what they are, how to build them, and why it is a perfect fit for your OBIEE environment. The examples will give attendees the basics for how to build, and design data structures when using the Data Vault modeling technique. The target audience is anyone wishing to explore implementing a Data Vault style data model as a means of developing a flexible and extensible Foundation Layer for their data warehouse architecture.

This session covers a case study of Financial Analytics for creating Financial KPI dashboards. During implementation, clients realized how easy it was to get KPIs from their existing Essbase cubes. But the need to look at the data at greater levels of detail intrigued client's interest to investigate use of Oracle OLAP cubes. The presentation will demonstrate the application through slides and will give a live demonstration of the process involved in building OBIEE rpd and reports for Essbase and OLAP cubes. The session will also cover a high level overview of configuration steps required for implementing an out-of-the-box Financial Analytics application.

Leverage the performance and scalability of your BI environment by adopting Oracle GoldenGate and Oracle Data Integrator to feed your Data Warehouse. This session explores the various components that enable fast, scalable data replication and integration. This includes the following discussion points: What is Oracle GoldenGate and what can it do?; ETL vs. ELT processes, the pros and the cons; avoiding batch windows and enabling real-time reporting; Oracle Data Integrator configuration options for GoldenGate CDC; and overcoming performance and scalability issues.

By exploring the configuration options of Oracle GoldenGate, we learn the various techniques that enable fast, scalable data replication and synchronization. This includes the following discussion points: What is Oracle GoldenGate and what can it do?; Topologies; Active-Active vs. Active-Passive; Getting the design right; Enabling parallel replication streams; Reducing data volumes and CPU utilization; Performance enhancements in OGG 11gR2; and Enabling security features.

Greg Vlahos, Analytic Vision

Learn how Clark Construction jump-started their analytical capabilities by leveraging the pre-built Oracle BI Financial App over JDEdwards, Hyperion Planning/Essbase, and custom data sources (sales acquisition system, safety statistics database). This session will cover how Clark chose OBIEE/Hyperion solution based on the business requirements, a deep dive into the technical solution, and a mapping of technical solutions to benefits gained. "How to" tips include: integrating Hyperion Planning into the OBI solution, steps to implement drilldown from planning to journal detail, and the unique seamless integration of transactional data with Hyperion Planning metrics in the same OBIEE subject area.

This session will discuss best practices and lessons learned in relation to how an Ivy League client's team partnered with performance architects to select OBIEE+, define requirements, and initiate designing the solution.

It's been just over a year since Oracle released their new mobile application for Oracle Business Intelligence 11g on iOS, so where does mobile access stand? This presentation will serve as a sequel to last year's Oracle BI & Mobility session and examine how and if mobile solutions from Oracle and other vendors have improved over the course of a year and whether mobile access still matters.

The new Oracle Exalytics hardware/software offering from Oracle combines traditional OBIEE, a TimesTen in-memory database, and a lot of hardware firepower to drive "Speed of Thought" analytics. In this session, we will look at the effect Exalytics has on the user experience for OBIEE, what "Speed of Thought" means to an end-user, and how "Speed of Thought" may introduce new dashboard design paradigms.

Two schools of thought have emerged in data visualization. In one camp, pragmatic, business-oriented dashboard designers rely on a small range of visualizations considered effective. In the other, "data journalists" and academic researchers are creating new and exciting visual representations. There is a well- established set of techniques used to clearly and effectively present information with graphics. But those techniques do not rule out innovative and attractive dashboards. This presentation will attempt to strike a balance between the clean and simple, and the wow factor.

Stephen Bowden, Peloton

One of the great challenges to adoption of executive dashboards is to get the target audience to use them. With OBIEE 11g, Oracle has expanded information delivery capabilities via the BI Mobile app. How do you get executive sponsorship for mobile BI?; What are the steps involved with going mobile?; What are the pitfalls related to devices, accounts, and connectivity? This session will explore General Dynamics' journey into mobile BI, examining commonly asked questions and sharing experiences encountered along the way.

Stephen Bowden, Peloton

How do you make the most effective use of your BI investment dollars? With Oracle Business Intelligence Applications (OBIA), organizations are empowered to focus on high-value analytical capabilities and leave the data "plumbing" to Oracle. With out-of-the-box solutions, there are always at least a few surprises. This session will explore the implementation of Financial Analytics and Project Analytics as part of a long-term roadmap towards expanded reporting and planning capabilities at General Dynamics.

This session covers several case studies applying best practices to improve performance including: system configuration settings, optimizing data model design, tips and tricks of building layouts, and bursting. Oracle Business Intelligence Publisher is Oracle's strategic enterprise reporting solution for authoring, managing, and delivering all types of highly formatted documents for over thirty Oracle Applications and Products. Learn how you can optimize your investment to create a high performance reporting environment.

Oracle Business Intelligence 11g uses Oracle Fusion Middleware and Oracle WebLogic Server to provide a distributed systems management environment through Oracle Enterprise Manager. Many BI configuration options are now managed through Oracle Enterprise Manager and can be scripted with the Oracle WebLogic Server scripting tool. This presentation provides an overview of the Oracle BI systems management environment; discusses best practices for managing a distributed, clustered environment; and looks in particular at best practices for scripting, deployment, diagnostics, logging, backup and recovery, and performing common systems management tasks.

The new Oracle Exalytics and accompanying Oracle TimesTen database makes it now possible to provide in-memory analytics on top of an Oracle data warehouse. In this session, we will look at the internals of Exalytics and TimesTen, examine how the new in-memory features work, provide performance figures and benchmarks and provide guidance on when to use Exalytics on top of an Oracle data warehouse, and OLAP, solution.

Learn about specific Essbase enhancements in Exalytics, when you can benefit from the performance improvements and what it might mean for existing Essbase implementations. See some of the latest performance results from customer and internal testing scenarios.

If your company has a data warehouse or is thinking of building one, come to this presentation to learn how Oracle EPM System, Fusion Edition helps drive value from your warehouse solution. Understand the benefit of Essbase and OBIEE+ and how they fit into your overall information delivery platform. Learn about how Essbase and the Oracle technologies combine to provide seamless integration between your applications, relational databases, and multi-dimensional databases. Join us for this informative session to learn the best way to build a warehouse for integration with Oracle EPM System, and how to get information out of your warehouse if you've already built one.

Hyperion Web Analysis is not Oracle's strategic direction for ad-hoc analysis (against cubes or otherwise). Oracle is going to be putting all their research and development into OBIEE Answers+. With the newest release of Answers+ (11g), you now have much better access against Essbase, so the question is: how do I migrate from Web Analysis to Answers? Well, there isn't a migration tool, but this session will show you how to recreate your core Web Analysis functionality in Answers. The session will also let you know what, at the moment, Answers still can't do that Web Analysis can. In one hour, you'll be well on your way to moving to OBIEE Answers+!

Joshua Kedzierski, Deloitte

In the past, reporting was typically executed in silos, resulting in a proliferation of reporting tools to meet the disparate needs of each department, with each managed and maintained separately. OBIEE 11g offers a new vision of the convergence of EBS Publisher, EPM, and OBIEE into a centrally managed platform. Today's complex world requires a comprehensive BI architecture utilizing complementary tools to deliver the best of functionality while minimizing cost and effort. The presentation will include lessons learned from real-world experience and a review of solution tools and templates to properly define a BI architecture utilizing all of OBIEE's functionality.

Nabhanil Mondal, Deloitte

For large enterprise BI implementations, it becomes difficult to monitor, sustain, and optimize application performance. Usage Tracking, one of OBIEE's out-of-the-box capabilities, can be utilized beyond tracking report count or run times to define advanced KPIs to demonstrate the value of the implementation, tune performance bottlenecks, and optimize global deployments. The solution analyzes Dashboard vs. Answers Usage, usage trends, and application performance based on Geographical Locations. Analytical reports, including Heat Maps, charts, and trends can be built on top of this data. By understanding this analysis, participants will learn how to optimize the value and performance of their BI solutions.

There are many types of users, and you'll learn to show the business what the different OBIEE users want. Originally formulated during a large state government implementation with dozens of agencies reporting needs at stake, this presentation clarified the use of OBIEE and the optimal direction to take for nearly a thousand reporting requirements.

Looking in to the possibilities of the extensive capabilities of the scripting environment of OBIEE11g, we will start to see amazing options for us to expand our implementations. Reconfiguring an embedded OBIEE system or re-arranging the system components to better fit our needs can all be achieved with some well placed 'hacks.'

With the great enhancements of the Oracle Business Intelligence Publisher functionalities in the 11g version, a lot of similarities can be found in comparison to OBIEE Answers. Can one be considered to be a direct competitor to the other? Or are these two tools mutually beneficial to us and only extend the ways in which users can exploit OBIEE?

Attendees will learn how to customize OBIEE 11g well beyond the short 'Customizing Oracle 11g Whitepaper' released by Oracle earlier this year. This has proved to be invaluable to many customers and clients in light of the dramatic changes Oracle has made in releasing OBIEE 11g. The main goal is to provide custom UI functionality available in 10g within 11g for customers looking to preserve the consistency of their application when migrating from 10g. Additional custom options will be covered as well.

This session demonstrates how asset management firm Eaton Vance partnered with Performance Architects to provide company-wide analytics using OBIEE, Essbase and DRM. The discussion includes an overview of the business opportunity, outlines the requirements process, technical architecture, and change management in relation to data governance and integration using DRM. The discussion will also address lessons learned using these tools together. The presentation will conclude with an overview of Eaton Vance’s future plans for continuing to use these tools as its enterprise-wide reporting and analytics platform, integrating both sales and assets under management (AUM) metrics and metadata.

Ron Dempesmeier,

Drawing from a session presented at OpenWorld for 2011, the presenters will take their most asked about features from the presentation and present it for Kscope users. Not only will the user walk away with an enhanced sense that they understand some of the key requirements and best practices for testing new applications, but the user will have some code examples and steps for creating their own tracking tools for installations that have gone live.