Oracle BI Suite EE 10g R3: Build Repositories Training  

Repository Basics

• Oracle BI architecture components
• Repository structure, features, and functions
• Using the OracleBI Administration Tool
• Creating a repository
• Loading a repository into Oracle BI Server memory

Building the Physical Layer of a Repository

• Importing data sources
• Setting up connection pool properties
• Defining keys and joins
• Examining physical layer object properties
• Creating alias and select tables

Building the Business Model and Mapping Layer of a Repository

• Building a business model
• Building logical tables, columns, and sources
• Defining logical joins
• Building measures
• Examining business model object properties

Building the Presentation Layer of a Repository

• Exploring Presentation layer objects
• Creating Presentation layer objects
• Modifying Presentation layer objects
• Examining Presentation layer object properties

Testing and Validating a Repository

• Checking repository consistency
• Turning on logging
• Defining a repository in the initialization file
• Testing a repository using Oracle BI Answers
• Inspecting the query log

Adding Multiple Logical Table Sources

• Adding multiple logical table sources to a logical table
• Specifying logical content

Adding Calculations to a Fact Table

• Creating new calculation measures based on existing logical columns
• Creating new calculation measures based on physical columns
• Creating new calculation measures using the Calculation Wizard

Creating Dimension Hierarchies and Level-Based Measures

• Creating dimension hierarchies
• Creating level-based measures
• Creating share measures
• Creating rank measures

Using Aggregates

• Purpose of aggregate tables in dimensional modeling
• Modeling aggregate tables to improve query performance
• Testing aggregate navigation
• Using the Aggregate Persistence Wizard

Using Partitions and Fragments

• Purpose for segmenting data into partitions and fragments
• Partition types
• Modeling partitions in an Oracle BI repository

Using Repository Variables

• Session variables
• Repository variables
• Initialization blocks
• Using the Variable Manager
• Using dynamic repository variables as filters

Modeling Time Series Data

• Using time comparisons in business analysis
• Using Oracle BI time series functions to model time series data

Modeling Many-to-Many Relationships

• Using bridge tables to resolve many-to-many relationships between dimension tables and fact tables
• Using helper tables to model many-to-many relationships for team-based hierarchies in a dimension

Configuring Oracle Business Intelligence data and metadata to support multilingual environments

Setting an Implicit Fact Column

• Adding fact columns automatically to dimension-only queries
• Ensuring the expected results for dimension-only queries
• Selecting a predetermined fact table source
• Specifying a default join path between dimension tables

Integrating Third-Party Reporting Tools with Oracle BI Server

Creating Repositories Using Multidimensional Data Sources

• Adding a multidimensional data source an Oracle BI repository
• Displaying data from multidimensional sources in Oracle BI Answers requests and Oracle BI Interactive Dashboards

Security

• Creating users and groups
• Setting permissions for users and groups
• Authenticating using a external database
• Authenticating using database authentication
• Setting query limits and timing restrictions
• Setting filters to personalize information

Cache Management

• Restricting tables as non-cacheable
• Using Cache Manager
• Inspecting cache reports
• Purging cache entries
• Modifying cache parameters and options
• Seeding the cache

Setting Up and Administering Usage Tracking

• Tracking and storing Oracle BI Server usage at the detailed query level
• Using usage tracking statistics to optimize query performance and aggregation strategies
• Analyzing usage results using Oracle BI Answers and other reporting tools

Multi-user Development

• Setting up a multi-user development environment
• Developing a repository using multiple developers
• Tracking development project history

Using Administration Tool wizards and utilities to manage, maintain, and enhance repositories

• Employing techniques to optimize Oracle BI query performance
• Applying Oracle BI repository design principles