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

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.

A Live Virtual Class (LVC) is exclusively for registered students; unregistered individuals may not view an LVC at any time. Registered students must view the class from the country listed in the registration form. Unauthorized recording, copying, or transmission of LVC content may not be made.

Audience

• Application Developers
• Business Intelligence Developer
• Implementation Consultant

Course Topics 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

Course Objectives

• 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