Oracle Essbase Studio 11.1.1: Create and Manage Data Structures (1)

Overview

Please note that Oracle courses running at London training centres are subject to a 10% surcharge.

In today’s fast-paced world of business intelligence, Essbase developers must be able to build applications quickly and efficiently, often using a variety of data and metadata sources. Essbase professionals need a tool that consolidates cube construction activities into one single interface, with consistent performance for data loading and outline building. Essbase Studio is that tool, providing unified deployment and management of the cube factory from one interface.

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.

Learn To:

• Describe the Essbase Studio implementation process
• Describe the Essbase Studio architecture
• Create logical star schema data marts from E-R dimensional database schemas and flat files
• Build metadata elements, hierarchies, schemas, and cube models
• Load dimension members and data to Essbase cubes
• Define drill-through reports to relational tables

Audience:

• Business Intelligence Developer
• Application Developers

Prerequisites

Required Prerequisites:

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

Suggested Prerequisites:

• Oracle Essbase 11.1.1: Bootcamp
• Hyperion Essbase 9.3.1: Deploy Aggregate Storage Databases

Delegates will be able to

• Create logical star schema data marts from E-R dimensional database schemas and flat files
• Build metadata elements, hierarchies, schemas, and cube models
• Load dimension members and data to Essbase
• Define drill-through reports to relational tables
• Describe Essbase Studio architecture
• Describe the Essbase Studio implementation process

Course outline

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