CONTENUTI

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

 

 

Multiuser 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