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 environmentsSetting 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 ServerCreating 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
