Oracle - Course Details

OraES1111:CMDS Oracle Essbase Studio 11.1.1: 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 data warehouse, flat files, or an Essbase cube you have already built, you can use (and reuse) those sources for the next project--and the next one after that. In addition, we will show you features such as lineage tracking (showing you in an instant where an element change affects other applications) and drill-through (for the extra-cube details you need) to bring your Essbase modeling to the next level.
Oracle Course Duration:
3 DAYS
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:
  • Data Warehousing and Business Intelligence

    • Business challenges
    • Business Information Analysis
    • Business Intelligence (BI)
    • Enterprise performance management (EPM)
    • Data warehousing
    • Hyperion EPM and data warehousing
    • Essbase Studio and data warehousing

  • Essbase Studio Deployment Architecture

    • Essbase Studio architecture
    • Essbase Studio Client Overview
    • Essbase Studio directory structure
    • Essbase Studio properties files
    • Essbase Studio catalog
    • Essbase Studio Help files

  • Data Source Connections

    • Defining connection parameters
    • Creating connections to relational, Dimension Server, and text data sources
    • Working with data source connections
    • Creating connections with Connection wizard
    • Using introspection
    • Defining minischemas

  • Metadata Elements and Alias Sets

    • Creating metadata elements
    • Working with metadata elements
    • Creating folders to organize your metadata elements
    • Creating and working with alias sets

  • Working with Minischemas

    • Creating minischemas
    • Managing minischemas (open/view/save/set properties/refresh)
    • Creating logical objects
    • Adding and deleting joins between tables
    • Viewing sample data from tables or individual columns

  • Hierarchies

    • Creating standard hierarchies
    • Creating measures hierarchies
    • Creating specialized hierarchies
    • Creating calendar hierarchies
    • Defining consolidation levels

  • Cube Schemas

    • Building cube schemas with Cube Schema Wizard
    • Choosing measures and hierarchies for a cube schema
    • Setting cube schema options
    • Defining data load mappings
    • Creating Essbase models from existing cube schemas

  • Essbase Models

    • Setting model-level properties
    • Modeling standard attributes
    • Modeling varying attributes
    • Setting member properties
    • Performing alias mapping
    • Adjusting hierarchy build settings
    • Modifying transformation settings
    • Mapping properties to database columns

  • Deploying Cubes and Applications

    • Deploying cubes using Cube Deployment Wizard
    • Setting load options for deploying cubes
    • Creating and saving a rules file
    • Performing a “lights out” deployment
    • Modifying Essbase model properties
    • Managing deployed applications

  • Drill through Reporting

    • Creating drill-through reports
    • Associating reports for drill-through
    • Associating drill-through with Essbase models
    • Setting query governors
    • Testing functionality during report design
    • Utilizing drill-through reporting in Smart View

  • Lineage

    • Opening Lineage Viewer
    • Navigating through the lineage
    • Viewing the history of an element
    • Launching Administration Services Console from Lineage Viewer
    • Editing element properties
    • Editing Essbase model properties
    • Showing deployment history
    • Viewing sample data