Oracle BI 11g R1: Build Repositories Training  

Repository Basics

• Exploring Oracle BI architecture components
• Exploring a repositorys structure, features, and functions
• Using the Oracle BI 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 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
• Executing analyses to test a repository
• Inspecting the query log

Managing Logical Table Sources

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

Adding Calculations to a Fact

• 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 measures using functions

Working with Logical Dimensions

• Creating logical dimension hierarchies
• Creating level-based measures
• Creating share measures
• Creating dimension-specific aggregation rules
• Creating presentation hierarchies
• Creating parent-child hierarchies
• Using calculated members

Using Aggregates

• Modeling aggregate tables to improve query performance
• Setting the number of elements in a hierarchy
• Testing aggregate navigation
• Using the Aggregate Persistence Wizard

Using Partitions and Fragments

• Exploring partition types
• Modeling partitions in an Oracle BI repository
• Using the Calculation Wizard to create derived measures

Using Repository Variables

• Creating session variables
• Creating repository variables
• Creating 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

Localizing Oracle BI Metadata and Data

• Localizing repository metadata
• Localizing Oracle BI data

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

Importing Metadata from Multidimensional Data Sources

• Importing a multidimensional data source into a repository
• Incorporating horizontal federation into a business model
• Incorporating vertical federation into a business model
• Adding Essbase measures to a relational model
• Displaying data from multidimensional sources in Oracle BI analyses and dashboards

Security

• Exploring Oracle BI default security settings
• Creating users and groups
• Creating application roles
• Setting up object permissions
• Setting row-level security (data filters)
• Setting query limits and timing restrictions

Cache Management

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

Enabling Usage Tracking

• Setting up the sample usage tracking repository
• 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 multiuser development environment
• Developing a repository using multiple developers
• Tracking development project history

Configuring Write Back

• Enabling write back in a repository
• Creating a write back template
• Granting write back privileges
• Enabling write back in an analysis

Performing a Patch Merge

• Comparing repositories
• Equalizing objects
• Creating a patch
• Applying a patch
• Making merge decisions