Requirement for Hyperion Trainer

Data Warehousing Concepts

· Starting this course with a brief over data warehousing concepts.

· Introduction of Data-Warehousing Concepts

· Schema Models

· OLAP Models and brief explanation on ROLAP and MOLAP

· Identification of Dimensions and Facts and create the Model to build cubes based on Real-Scenarios

· Introduction to Hyperion Tools and Advantages

· Essbase Architecture and Flow of Development Life Cycle of Essbase Cubes

· Essbase Installation and Configuration Procedure

Essbase Storage Properties

· This module talks about the database design and storage properties.

· Essbase Terminology and Family Tree Relationships

· Introduction of Database Design

· Data Storage Properties

· Time Balance and Expense Reporting Properties

· UDAS and Attribute and Alternate Hierarchies

· Introduction to ASO and BSO Options

· Creating Essbase Applications and Databases

· Understanding the Time

· Scenario and Measures Dimension Concepts

· Creating and building the dimensions rule files using Essbase Administration Services Console

· Loading the data in Different Methods, Consolidation Operators and Duplicate Member Name Support

Essbase Cube Implementation From Scratch

· In this module, you will learn how to create account hierarchies and ETL operations.

· Creating Standard and Attribute Hierarchies

· Creating Accounts Hierarchies

· ETL Operations while Rule File Building

· Dimensional and Data Loading using Interface tables and Flat Files

BSO Cube Implementation

· All about block structures are explained in this module.

· Dense and Sparse Concept

· Block Structure

· Data Storage Properties

· Calculation Scripts Hour-Glass Method Importance

· Design and Optimization Technique

· Partitions and there types

ASO Cube Implementation

· All about ASO cube is explained in this module.

· Aggregations

· ASO Physical Structure

· Table space and Restructuring

· MDX Scripts

· Design and Optimization

ASO Cube Implementation

· All about ASO cube is explained in this module.

· Aggregations

· ASO Physical Structure

· Table space and Restructuring

· MDX Scripts

· Design and Optimization

Security And Administration

· Learn all about shared services, server and application log files and much more in this module.

· Introduction to Shared Services Console

· Creating Users and Groups

· Assign Cube and Filter Access to Groups

· Essbase Config Server and Application Log Files

· Locks and Sessions

· Backup and Recovery Methods

· Introduction to Life Cycle Management and Usage

Introduction To Excel-Adding And Smart View

· Woking with Essbase excel add-in, in this module.

· Accessing Cubes using Essbase Excel-Addin and generate Reports

· Performing Adhoc Analysis using Smart View Tool

· Various Options that is available in Essbase Excel-Addin and Smart-View Tools

Data Warehousing Oracle Hyperion

Project ID: #33437697

About the project