There are no translations available.
This training provides step-by-step procedures for building and verifying the three layers of an Oracle BI repository.
Repository Basics
- Exploring Oracle BI architecture components
- Exploring a repository's 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