​Formation OBIEE Administrateur - Avancé
Construire le répertoire en langage d'Affaires
(Oracle BI 11g R1: Build Repositories)
 

Repository Basics

  • Exploring Oracle BI architecture components OBIEE

  • Exploring a repository's structure, features, and functions OBIEE

  • Using the Oracle BI Administration Tool OBIEE

  • Creating a repository

  • Loading a repository into Oracle BI Server memory OBIEE

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 OBIEE

  • 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 OBIEE

  • Exploring Presentation layer objects

  • Creating Presentation layer objects

  • Modifying Presentation layer objects

  • Examining Presentation layer object properties

Testing and Validating a Repository OBIEE

  • 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 OBIEE

  • 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 OBIEE

Modeling Many-to-Many Relationships

  • Using bridge tables to resolve many-to-many relationships between dimension tables and fact tables

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 OBIEE

  • 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 OBIEE usage at the detailed query level

  • Using usage tracking statistics to optimize query performance and aggregation strategies

  • Analyzing usage results using Oracle BI Answers  OBIEE and other reporting tools

Multiuser Development

  • Setting up a multiuser development environment

  • Developing a repository using multiple developers

  • Tracking development project history

Performing a Patch Merge

  • Comparing repositories

  • Equalizing objects

  • Creating a patch

  • Applying a patch

  • Making merge decisions

Présentation de la table des matières :
Formation OBIEE avancé Québec – Panorama Technologies

 

  • Migration des utilisateurs

  • Installation du suivi d’utilisation OBIEE « Usage Tracking »

  • Analyse d'impact OBIEE - OBIEE Data Lineage

  • Les données du Catalogue OBIEE et référentiel OBIEE

  • Générer le dictionnaire de métadonnées  OBIEE ( metadatadictionary )

  • Migrer les utilisateurs avec leurs catalogues  d’un ancien serveur de production  sur un nouveau serveur de production

  • Créer un rôle

  • Liens URL d’analyse

  • Moniteur de performance

  • Gérer les sessions

  • Page d’aide

  • Gérer les privilèges administrateur

  • Les fichiers de configuration et les fichiers log et les emplacements sur le serveur 

  • Installation Bi Office,  des plug-ins  Excel et Office et SmartView

  • Changer le logo sur la machine OBIEE

  • Migration .rpd  vers 11.1.1.7.

  • Migration catalogue vers 11.1.1.7.

  • Installation patch

  • Installation des patch mobile OBIEE (android, ipad, iphone et Black Berry)

 

 

Voir aussi:

 

 

© 2003- 2013 par Panorama Technologies

  • LinkedIn Metallic
  • RSS Metallic