Scheda corso
NovaNext Training / Oracle / Development Tools / Oracle Essbase Studio 11.1.2: Create & Manage Data Structures (11.1.2.2)

Oracle Essbase Studio 11.1.2: Create & Manage Data Structures (11.1.2.2)

Codice
D63981GC20
Durata
3 Giorni
Prezzo
1.800,00 € (iva escl.)
Lingua
italiano
Modalità
Virtual Classroom
Corso in aula
       

 

Schedulazione
Luogo Data Iscrizione
A Richiesta

 

Prerequisiti

Il corso è rivolto a:
  • Sviluppatori di applicazioni
  • Consulente implementazioni
Conoscenze richieste:
  • Working knowledge of Essbase
  • Familiarity with dimensional data modeling and data warehousing
  • Familiarity with relational database concepts and SQL
Prerequisiti suggeriti :
  • Oracle Essbase 11.1.2 Bootcamp
  • Oracle Essbase 11.1.2: Deploy Aggregate Storage Databases

 

Obiettivi

In today's competitive business world, Essbase developers must be able to build applications quickly and efficiently, often using a variety of data and metadata sources. Essbase Studio provides Essbase professionals with a development tool that consolidates cube construction activities into a single interface, with consistent performance for outline building and data loading.

This course gives you the information you need to build your Essbase models quickly from many sources, giving you more time to interpret results and modify your models as required. Whether you are sourcing from a relational database, data warehouse, EPMA dimension server, or flat files, you can use the elements, hierarchies, and models you build in Essbase Studio in your next project--and the next one after that. This course shows you how to connect to the most commonly used data sources, how to build and catalog dimensions and hierarchies, and how to set Essbase properties to produce Essbase outlines and load data--all from a single user console. In addition, you learn features such as lineage tracking (for change control) and drill-through (for the extra-cube details you need) to make your Essbase modeling fast and efficient.

* This course is designed for customers using Oracle Essbase Studio 11.1.2.2. This course is not suitable for customers using Oracle Essbase Studio 11.1.2.1 or earlier.

You will be able to:
  • Describe the Essbase Studio implementation process
  • Describe the Essbase Studio implementation process
  • Build metadata elements, hierarchies, schemas, and cube models
  • Load dimension members and data to Essbase
  • Define drill-through reports to relational tables
  • Copy, move, and backup your Essbase Studio catalog

 

Contenuti

Essbase Studio Overview
Benefits of Essbase Studio
Essbase Studio Architecture
Essbase Studio Workflow
Creating Data Source Connections

Creating Connections with Connection Wizard
Defining Connections to Text file Data Sources
Defining Connections to Relational Data Sources
Creating Metadata Elements

Creating metadata elements
Managing metadata elements
Building Hierarchies

Creating Standard Hierarchies
Creating Measure Hierarchies
Building Parent-Child hierarchies
Creating Cube Schemas

Building cube schemas with Cube Schema Wizard
Choosing measures and hierarchies for cube schemas
Creating Essbase Models

Creating Essbase models from cube schemas
Setting Essbase model properties
Setting dimension and member properties
Validating your Essbase models
Deploying Essbase Cubes

Deploying cubes using Cube Deployment Wizard
Setting load options for deploying cubes
Enhancing Your Data Source Connections

Managing data source connections
Creating minischemas
Enhancing Your Metadata Elements

Creating date elements
Creating derived text measures
Creating editing, and managing alias sets
Enhancing Hierarchies

Building alternate hierarchies
Adding attribute dimensions to your hierarchies
Building calendar hierarchies
Creating varying attribute hierarchies
Enhancing Cube Schemas

Defining data load mappings
Creating Essbase models from Cube Schema Wizard
Enhancing Essbase Models

Enhancing model, dimension, and member properties
Enhancing Cube Deployments

Deferring deployments
Troubleshooting
Setting up incremental loads
Viewing deployment history
Viewing Lineage

Navigating the Lineage Viewer
Viewing the history of an element
Editing data element properties
Editing Essbase model properties
Showing deployment history
Viewing sample data
Working with Drill-through Reports

Drill-through reporting overview
Creating drill-through reports
Customizing reports
Associating drill-through reports with Essbase models
Performing drill-through reporting in Smart View
Managing the Essbase Studio Repository

Exporting the Essbase Studio catalog
Copying, moving, and backing up the Essbase Studio catalog
Integrating Essbase Studio with Oracle Business Intelligence

Connecting to OBIEE
Creating OBIEE dimensions and cube schemas
Generating key and caption bindings for OBIEE