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

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

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

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