Hyperion Online Training

 >>  Hyperion Online Training

Hyperion Online Training


 (4.9) | 350 Ratings


Introduction


Hyperion Online Training Details
Track Regular Track Weekend Track Fast Track
Course Duration 30 Hrs 8 Weekends 5 Days
Hours 1hr/day 2 Hours a day 6 Hours a day
Training Mode Online Classroom Online Classroom Online Classroom
Delivery Instructor Led-Live Instructor Led-Live Instructor Led-Live


Course Curriculum

Hyperion online Training Modules

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

Scripts

  • Scripts are explained in detail in this module of training.
  • Automation of Cube Loading using MaxL Scripts
  • Report Scripts

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

 

Exam & Certification

0

Course Review

(4.9)
5 stars
4 stars
3 stars
2 stars
1 stars

Course Curriculum

Hyperion online Training Modules

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

Scripts

  • Scripts are explained in detail in this module of training.
  • Automation of Cube Loading using MaxL Scripts
  • Report Scripts

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

 

    Click here for Help and Support

    Click here for Help and Support: info@sacrostectservices.com     For Inquiry Call Us:   +91 996-629-7972(IND)

  +91 996-629-7972(IND)
X

Quick Enquiry

X

Business Enquiry