" rel="stylesheet">
Skip Main Navigation
Page Content

Save This Event

Event Saved

Remote TRN306 : ODI for BI APPS training (Atlanta, November 2016)

Rittman Mead

Wednesday, 30 November 2016 at 09:00 - Friday, 2 December 2016 at 17:00

Registration Information

Registration Type Sales End Price Fee Quantity
Full Attendee 25 Nov 2016 $2,100.00 $0.00

Share Remote TRN306 : ODI for BI APPS training (Atlanta, November 2016)

Event Details

 

ODI FOR BI APPLICATIONS 11G - CONFIGURATION, DEVELOPMENT, AND BEST PRACTICES

A Complete OBIA Development Guide for ODI Operators and Developers

Written for ODI 11g Developers, this course is meant to not just show developers and operators “how to”, but give them the "why" behind it.

Over three days, these users are shown how to work in ODI Studio and create load plans, as well as navigate Configuration Manager and Functional Setup Manager (domain configuration, step by step project setup).

This course has been developed for Oracle BI Applications 11.1.1.9 , but is just as relevant if your organization is on an earlier release of Oracle BI Applications 11g.

DAY 1

SECTION 1: USING CONFIGURATION MANAGER AND FUNCTIONAL SETUP MANAGER (8 HRS)

Product Overview

Objective: Attendees will be given a tour of the BI Applications core components from infrastructure to Oracle Data Integrator, including overviews of ETL phases and the different kinds of knowledge modules. After the introduction, attendees will learn about the components further by starting all of the services in the order needed to begin working with BI Applications and ODI Studio.

Using Configuration Manager

Objective: Attendees will log into the Configuration Manager and be taught how to set up a source instance (Transactional DB) and enable a BI Application offering to begin utilizing the prebuilt solutions.

Using Functional Setup Manager

Objective: This session will be used to introduce the attendee with all of the steps needed to create an Implementation Project. This will include configuring the offering selected in Configuration manager, creating an Implementation Project, navigating the tasks in the Project, assigning tasks to users, and completing tasks within the Project.

www.rittmanmead.com / info@rittmanmead.com / @rittmanmead 1

 

System Setup, Data Load Parameters, and Domain Mappings

Objective: In this session, the attendee will return to Configuration Manager to learn how to configure the System Setup parameters, understand and set Data Load Parameters. They will then learn how to navigate and manage Domain Member Mappings, and even create custom warehouse members.

Running a Load Plan

Objective: In this session, attendees will create a load plan in Configuration Manager and learn how to monitor it in ODI Console. Then attendees are introduced to ODI Studio and explore how to monitor from within this tool. The differences between ODI Console and ODI Studio will be explained and which tool is best for certain scenarios.

DAY 2

SECTION 2: FOLLOWING THE DATA (4 HRS)

Verifying Data from the Full Load

Objective: In this session, attendees will query the DB tables to see if data has indeed been populated. They will then log into OBIEE and run a very simple analysis to view the data as a user or business analyst might.

ODI Studio Deep Dive

Objective: Attendees will begin in ODI Studio by learning the Operator Navigator to see the sessions that ran and rows that were inserted, as well as the SQL statements that were generated. Then they will use the Designer Navigator to understand how all of the interfaces and models work together to build those SQL statements.

SECTION 3: CATEGORY 1 CUSTOMIZATIONS (4 HRS)

Isolating Customizations

Objective: In this session, attendees will learn how to create custom folders, duplicate out of the box code and use version control. They will understand best practices and important tips to reduce future upgrade issues with customizations.

Model Customization

Objective: Attendees will learn how to take existing models and add custom rows.

www.rittmanmead.com / info@rittmanmead.com / @rittmanmead 2

 

Interface Customization

Objective: Attendees will follow previous model changes and apply them to interfaces. They will explore how BI Application delivered interfaces are structured and follow through the different interfaces to ensure the model changes flow through the entire warehouse.

Running a Custom Load Plan

Objective: In this session, attendees will create a custom load plan in Configuration Manager and learn how to add the customized scenarios to it in ODI Studio. Attendees then will monitor the load plan in the tool of their choice.

DAY 3

SECTION 4: CATEGORY 2 CUSTOMIZATIONS (8 HRS)

Isolating Customizations

Objective: In this session, attendees will duplicate out of the box code and use version control. They will understand best practices and important tips to reduce future upgrade issues with customizations.

Model Customization

Objective: Attendees will take what they learned from the previous day and start a more advanced customization. They will learn how to create new custom models.

Interface Customization

Objective: Attendees will follow the structure from previous models and create brand new custom interfaces to bring forward the new custom models. They will learn BI Application interface best practices, follow BI Application structure and create the different interfaces to ensure the new custom models are brought forward into the warehouse.

Running a Custom Load Plan

Objective: In this final session, attendees will create another custom load plan in Configuration Manager and add the newly created advanced customized scenarios to it in ODI Studio. Attendees then will monitor the load plan in the tool of their choice.


Do you have questions about Remote TRN306 : ODI for BI APPS training (Atlanta, November 2016)? Contact Rittman Mead

Save This Event

Event Saved

When & Where


Rittman Mead America
5280 Avalon Boulevard
Alpharetta, GA 30009

Wednesday, 30 November 2016 at 09:00 - Friday, 2 December 2016 at 17:00


  Add to my calendar

Organiser

Rittman Mead

Rittman Mead specialize in the implementation of Oracle business intelligence, data warehousing and performance management systems.

Training
Rittman Mead offer a range of training courses across Oracle's BI and data warehousing technologies. 
 
Consulting
Whether you are about to embark on a new project, or are mid-way through a project and need some extra help

Support 
The service combines on-site consultation, dedicated BI & EPM consultants and the latest tracking and support tools.
  Contact the Organiser
Remote TRN306 : ODI for BI APPS training (Atlanta, November 2016)
Things to do in Alpharetta, GA Conference

Please log in or sign up

In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.