Oracle BI 11g (OBIEE): Building Repositories – OBI400
OBIEE 11g Building Repositories – OBI400 – 3 Days Request a Class Date
This course provides step-by-step procedures for building and verifying the three layers of an Oracle BI repository.
Mutli-Enrollment Discounts Available at Check-Out
- Instructor
- Julie Johnson
This OBIEE training course provides step-by-step procedures for building and verifying the three layers of an Oracle BI repository. Students begin by using the Oracle BI Server Administration Tool to construct a simple repository to address a fictitious company’s business requirements. Students import schemas, design and build logical business models, and expose business models to users in Oracle BI Analyses Editor. In the process of constructing the repository, students learn how to build physical and logical joins, simple measures, and calculation measures. Students also learn how to validate their work by building queries and verifying query results using Oracle BI Analyses Editor and the query log.
Students then extend the initial repository and learn how to model more complex business requirements, such as dimension hierarchies, multiple logical table sources, aggregate tables, partitions, and time series data. Students also learn to use Administration Tool wizards and utilities to manage, maintain, and enhance repositories.
Course ID: OBI400 Duration: 3 days
Audience: This course is designed for people who will be building the OBIEE repository for reporting purposes. This includes developers and data Warehouse administrators and optionally power users. Application developers, reports developers, Oracle BI developers, data warehouse developers, data warehouse administrators, and business analysts.
Oracle BI 11g (OBIEE): Building Repositories
Training Course Topics
Chapter 1:Introduction to OBIEE
- What is OBIEE?
- OBIEE 11g New Features
- OBI Analysis – A Quick Glimpse
- Subject Areas
- OBI Queries
- Data Sources
- The BI Domain
- BI Domain Architecture
- OBIEE System Components, Logging, and Configuration
- Enterprise Manager Fusion Control (EM)
- BI Integration with Other Products
- Finding OBIEE Documentation
- Starting and Stopping BI Services
- Starting and Stopping BI Components
- Logging in to BI Analytics
- Lab Exercises
Chapter 2: The Repository and Sample Application
- The BI Administration Tool
- Opening the Repository File (RPD) – Offline Mode
- Opening the Repository File (RPD) – Offline Mode – cont’d
- Opening the Repository – Online Mode
- The OBI Layers
- Swapping the Repository
- The OBIEE Sample Application
- The Sample App – The Dashboard Pages
- The Sample App – The Simple Demo
- The Sample App – Reverse Engineering It
- The Sample App – Installed Users
- Reverse Engineering the Sample App Repository
- Creating a New Repository
- Your New Repository
- Creating a New Catalog
- Lab Exercises
Chapter 3: Working with Data Sources
- Database Objects
- Creating a Database Connection Pool
- Using Variables with Connection Pools
- Connection Scripts
- Configuring a Connection Pool for Write-Back
- Using TNSNAMES.ORA
- Importing the Metadata
- Creating Database Objects, Connection Pools and Physical Objects – in One Step!
- Using XML as a Data Source
- XML Connection Properties
- Physical Tables Based on XML Data Sources
- Using Wildcards in the XML Data Source
- XML Schema and Data Types
- Lab Exercises
Chapter 4: The Physical Layer
- Introduction to the Physical Layer
- The Physical Layer Diagram
- Diagram Display Options
- Physical Schemas and Catalogs
- Dynamic Schema Names
- Working with Physical Tables
- Table Aliases
- Table Alias Behavior
- Opaque Views
- Table Properties
- Obtaining Row Counts
- Viewing Table Data
- Table Hints
- Physical Table Columns
- Physical Primary Keys
- Physical Foreign Keys
- Creating Physical Joins through the Table Editor
- Creating Physical Joins through the Diagram
- Creating Physical Joins through the Joins Manager
- Working with Many-to-Many Relationships – Bridge Tables
- Working with Display Folders
- Lab Exercises
Chapter 5: Logical Tables and Joins
- Overview of the Business Model and Mapping Layer
- Creating a New Business Model
- Creating the Subject Area (Presentation Layer)
- Duplicating a Business Model
- Seeing the Layer Relationships
- Viewing the Keys and Logical Joins
- About Logical Joins
- Using Driving Tables
- Adding Logical Columns
- Enabling Write-Back on Columns
- Adding Logical Display Folders
- Labs
Chapter 6: Logical Dimensions
- About Logical Dimensions
- Dimension Types
- Level-Based Hierarchies
- Creating a Level-Based Dimension
- The Grand Total Dimension Level
- Adding Dimension Levels
- Associating Attributes with Levels
- Setting the Keys
- Dimensions are Associated with Logical Tables!
- The Preferred Drill Path
- Level-Based Measure Calculations
- Time Dimensions
- Parent-Child Dimension Hierarchies
- Parent-Child Relationship Tables
- Adding the Parent-Child Relationship Table to the Model
- Time Series Functions
- AGO, TODATE, and PERIODROLLING – Examples
- Lab Exercises
Chapter 7: The Presentation Layer
- About the Presentation Layer
- Subject Areas
- Splitting up Subject Areas
- Presentation Columns and Naming
- Implicit Fact Columns
- Presentation Table Properties
- Presentation Hierarchies
- Setting Permissions
- Identity Manager
- Permission Reports
- Folders and Subfolders
- Lab Exercises
Chapter 8: Multi-User Development and Source Control
- Multi-User Development (Before 11.1.1.6)
- The New Source Control Management System – New in 11.1.1.6
- Setting Up Your System for SVN
- Setting up Users and Groups
- Save your RPD as MDS XML
- Create Source Control Configuration File
- Using SVN with Source Control
- Lab Exercises
Chapter 9: Managing Variables
- Introduction to Variables
- Session Variables
- System Session Variable Reference
- Setting Non-System Session Variables
- Creating New Variables
- Initialization Blocks
- Associating Variables with Initialization Blocks
- Viewing Current Variable Values
- Testing Session Variables From Filters
- SQL-Based Non-System Session Variables
- Referencing the Session Variable
- Repository Variables
- Example – Dynamic Repository Variable
- Testing Repository Variables with Filters
- Presentation Variables
- Predefined Presentation Variables
- Referencing a Presentation Variable from a Title View
- Prompts and Presentation Variables
- Testing the Analysis Prompt
- Presentation Variables in Conditional Formatting
- Referencing a Variable with Conditional Formatting
- Column Prompts
- The Prompts Editor
- Column Prompts in Action
- Lab Exercises
Chapter 10: OBIEE Security Concepts
- Authentication and Authorization concepts
- Application Policies and Application Roles
- Users, Groups, and Roles
- Default Application Roles
- Creating a New Application Role
- Application Role Policies
- Creating Application Groups
- Associating Application Groups with Roles
- Associating Users with Application Groups
- Testing Your New User
- Setting Object Permissions