Retour en haut de la page

Oracle Essbase 11.1.1 - Bootcamp

5 jours - 35 heures

Objectifs

Create block storage databases Create dimensions using rules files Load data using rules files Analyze data with Smart View Describe multidimensional calculation Create basic database calculations Analyze dimension attributes Analyze non-numeric data

Participants

Concepteurs de base de données Administrateurs de base de données Développeurs

Pédagogie

La pédagogie est basée sur le principe de la dynamique de groupe avec alternance d'apports théoriques, de phases de réflexion collectives et individuelles, d'exercices, d'études de cas et de mises en situations observées. Formation / Action participative et interactive : les participants sont acteurs de leur formation notamment lors des mises en situation car ils s'appuient sur leurs connaissances, les expériences et mettront en œuvre les nouveaux outils présentés au cours de la session.

Profil de l’intervenant

Consultant-formateur expert. Suivi des compétences techniques et pédagogiques assuré par nos services.

Moyens techniques

Encadrement complet des stagiaires durant la formation. Espace d’accueil, configuration technique des salles et matériel pédagogique dédié pour les formations en centre. Remise d’une documentation pédagogique papier ou numérique à échéance de la formation.

Méthodes d’évaluation des acquis

Exercices individuels et collectifs durant la formation. La feuille d’émargement signée par demi-journée ainsi que l’évaluation des acquis de fin de stage sont adressées avec la facture.

Programme

Essbase Overview

Multidimensional Analysis

Oracle’s Enterprise Performance Management System

Oracle BI Suite Enterprise Edition Plus

Essbase

Production Environment Components

Creating Reports with Smart View

Manipulating Multidimensional Data

Updating Essbase Data

Integrating Essbase Data with Microsoft Office

Customizing the User Experience

Data Storage and Calculation

Calculation Overview

Database Calculation Order

Data Block Fundamentals

Data Blocks and the Index System

Database Statistics

Data Block Creation

Database Calculation Process

Creating Calculation Scripts

Calculation Script Organization

Returning Correct Calculation Results

Troubleshooting CALC DIM Processes

Controlling the Calculation Process

Top-Down Calculation

Focusing Calculations with FIX Statements

Calculating Conditionally with IF Statements

Comparing FIX and IF Calculation Processes

Referencing Members in Calculations

Referencing Members Explicitly

Referencing Members Dynamically

Creating Calculation Variables

Analyzing Member Attributes

Attribute Dimensions Overview

Adding Attribute Dimensions to Outlines

Design Considerations

Creating Attributes with Rules Files

Analyzing Varying Attributes

Varying Attributes Overview

Creating Varying Attributes Overview

Viewing Varying Attribute Data

Analyzing Text and Dates

Typed Measures Overview

Enabling Typed Measures

Creating Typed Measures

Viewing Typed Measures

Calculations Based on Typed Measures

Designing Applications and Databases

Block Storage Implementation Process

Analyzing and Planning Implementations

Creating Applications and Databases

Creating Outline Structures

Modifying Member Properties

Designing Data Descriptor Dimensions

Data Descriptor Dimensions Overview

Designing Time Dimensions

Designing Scenario Dimensions

Outline Calculations

Designing Accounts Dimensions

Testing Outline Calculations

Optimizing Data Descriptor Dimensions

Creating Member Aliases

Dimension Types

Creating Period-to-Date Totals

Dynamic Calc Members

Enhancing Accounts Dimensions

Optimizing Data Storage

Planning Dimension Designs

Business View Dimensions Overview

Combining Business Views

Planning Dimensions with Label Outlines

Creating Basic Dimension Build Rules Files

Creating Advanced Dimension Build Rules Files

Advanced Dimension Build Rules Files Overview

Creating Shared Members

Manipulating Fields

Creating User-Defined Attributes

Loading Data

Data Load Overview

Creating Data Load Rules Files

Selecting and Rejecting Records

Capturing New Members

Getting Started with Smart View

Smart View Overview

Configuring Data Sources

Creating Ad Hoc Reports

Setting the Point of View

1223 log-543.pdf