Oracle - Course Details

OraEA1112:CMDS Oracle Essbase Studio 11.1.2: Create and Manage Data Structures

Oracle Course Description:
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.
Oracle Course Duration:
Oracle Course Target Audience:
Application Developers,Business Intelligence Developer
Oracle Course Prerequisite:
Working knowledge of Essbase,Familiarity with dimensional data modeling and data warehousing,Familiarity with relational database concepts and SQL
Course Content:
  • 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