OBIETTIVI

Costruire tutti gli strati di un repository: Fisico, Modello di Business, Cartografia e Presentazione

Compilare ed eseguire analisi per testare e validare un repository

Costruire misure semplici e calcolate per una tabella dei fatti

Creare gerarchie dimensione logica e il livello a base di misure

Modellare tabelle aggregate per accelerare l’elaborazione delle query

Creare partizioni e facets per migliorare le prestazioni delle applicazioni e la loro usabilità

Utilizzare le variabili per snellire le attività amministrative e modificare il contenuto dei metadati in modo dinamico

Usare le funzioni di serie storiche per supportare il confronto temporale di analisi storiche

Impostare la sicurezza per autenticare gli utenti e assegnare autorizzazioni appropriate e privilegi

Applicare tecniche di gestione della cache per mantenere e migliorare le prestazioni delle query

Impostare la registrazione di query per test e debug

Impostare un ambiente di sviluppo multiutente

Utilizzare i wizard e i tools dello Strumento di amministrazione per gestire, mantenere e migliorare i repository

Consentire l’utilizzo del tracking per monitorare query e utilizzo del database e per migliorare le prestazioni delle query

Eseguire il patching in uno scenario di produzione

Configurare Oracle BI per supportare ambienti multilingue

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