Oracle BI 12c: Build Repositories

Basic SQLData warehouse designDatabase designDimensional modelingOracle BI 11g R1: Create Analyses and Dashboards

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

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