Oracle Essbase Studio 11.1.2: Create and Manage Data Structures

Course Description

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.Learn To:Describe the Essbase Studio architecture and implementation process Connect to relational and flat file data sourcesBuild metadata elements, hierarchies, schemas, and cube modelsLoad dimension members and data to Essbase cubesDefine drill-through reports to relational tablesCopy, move, and backup your Essbase Studio catalog* This course is also suitable for customers using Oracle Essbase Studio 11.1.1.

Skills Gained

• Describe the Essbase Studio architecture
• 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

Who Can Benefit

• Application Developers
• Business Intelligence Developer

Prerequisites

• Working knowledge of Essbase
• Familiarity with dimensional data modeling and data warehousing
• Familiarity with relational database concepts and SQL

Syllabus

Essbase Studio Overview

• Enterprise Performance Management
• 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

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

• Applying introspection to your data sources
• Working with data source connections
• Creating minischemas

Enhancing Your Metadata Elements

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

Enhancing Your Hierarchies

• Building alternate hierarchies
• Adding attribute dimensions to your hierarchies
• Building Parent-Child hierarchies
• Building calendar hierarchies

Enhancing Your Cube Schemas

• Defining data load mappings
• Creating Essbase models directly from Cube Schema Wizard

Enhancing Your Essbase Models

• Adding alias sets to your models
• Adding alternate rollup settings to your models
• Adding attribute dimensions to your models

Enhancing Your Cube Deployments

• Applying data source settings
• Troubleshooting
• Setting Up Incremental Loads
• Viewing Deployment History

Viewing Lineage

• Navigating the lineage
• Viewing the history of an element
• Editing data element properties
• Editing Essbase model properties
• Showing deployment history

Working with Drill-through Reports

• Drill-through reports overview
• Creating drill-through reports
• Customizing reports
• Associating drill-through reports with Essbase models
• Drill-through reporting in Smart View

Managing the Essbase Studio Repository

• Exporting the Essbase Studio catalog
• Copying/moving/backing up the Essbase Studio catalog