HYPERION ESSBASE AND PLANNING ONLINE TRAINING

HYPERION ESSBASE

Part 1: Data Warehousing Concepts

1. Introduction of Data-Warehousing Concepts
2. Schema Models
3. OLAP Models and brief explanation on ROLAP and MOLAP
4. Identification of Dimensions and Facts and create the Model to build cubes based on Real-Scenarios
5. Introduction to Hyperion Tools and Advantages
6. Essbase Architecture and Flow of Development Life Cycle of Essbase Cubes
7. Essbase Installation and Configuration Procedure

Part 2: Essbase Storage Properties

1. Essbase Terminology and Family Tree Relationships
2. Introduction of Database Design
3. Data Storage Properties
4. Time Balance and Expense Reporting Properties
5. UDAS, Attribute and Alternate Hierarchies
6. Introduction to ASO and BSO Options
7. Creating Essbase Applications and Databases
8. Understanding the Time, Scenario and Measures Dimension Concepts
9. Creating and building the dimensions rule files using Essbase Administration Services Console
10. Loading the data in Different Methods
11. Consolidation Operators
12. Duplicate Member Name Support

Part 3: Essbase Cube Implementation from Scratch

1. Creating Standard and Attribute Hierarchies
2. Creating Accounts Hierarchies
3. ETL Operations while Rule File Building
4. Dimensional and Data Loading using Interface tables and Flat Files

Part 4: BSO Cube Implementation

1. Dense and Sparse Concept, Block Structure
2. Data Storage Properties
3. Calculation Scripts
4. Hour-Glass Method Importance
5. Design and  Optimization Technique
6. Partitions and there types

Part 5: ASO Cube Implementation

1. Aggregations
2. ASO Physical Structure
3. Table space and Restructuring
4. MDX Scripts
5. Design and Optimization

Part 6: Scripts

1. Automation of Cube Loading using MaxL Scripts
2. Report Scripts

Part 7: Security and Administration

1. Introduction to Shared Services Console
2. Creating Users and Groups
3. Assign Cube and Filter Access to Groups
4. Essbase Config, Server and Application Log Files
5. Locks and Sessions
6. Backup and Recovery Methods
7. Introduction to Life Cycle Management and Usage

Part 8: Introduction to Excel-Addin and Smart View

1. Accessing Cubes using Essbase Excel-Addin and generate Reports
2. Performing Adhoc Analysis using Smart View Tool
3. Various Options that is available in Essbase Excel-Addin and Smart-View Tools

Part 9: Essbase Studio Tool

1. Essbase Studio Overview
2. Adding data Sources
3. Modeling data sources -Mini schemas
4. Modeling data sources -Organizing Meta data elements
5. Modeling data sources -Dimension Elements and Hierarchies
6. Modeling data sources -Cube Schemas
7. Deployment of Cube from Essbase Studio to Essbase Administration Services Console
8. Drill -THROUGH Reports
9. Data Lineage

Hyperion Planning

Part 1: Introduction to Hyperion Reporting

1. Introduction to Planning Tool
2. Applications and Plan Types Defined
3. Planning Dimensions
4. Advantages of Planning tool
5. Planning Architecture

Part 2: Workspace and Planning Application

1. Introduction and Navigating to Workspace
2. Introduction to Planning Web Client in End User Perspective
3. Creating Classic Planning Application
4. Creating Inbuilt and user-defined Dimensions
5. Introduction to Outline Load Utility
6. Loading Metadata to Planning Application from Flat files using Outline Load Utility
7. Deploying Planning Application to EAS Console
8. Loading Fact Data using Rule Files in EAS Console

Part 3: Data Forms

1. Data Forms Introduction
2. Create a Data Form
3. Create a Composite Data Form
4. Manage the Data Form
5. Custom Menus
6. Assigning Menu to a Data Form

Part 4: Creating Business Rules Business Rules Overview Calculation Manager Overview Business Rules Creation Process Calculation Manager Security Setting Up Business Rules Validating, Deploying, and Launching Business Rules Creating Variables and Runtime Prompt Variables Creating Formulas Adding Conditional Statements Creating Member Ranges

Part 5: Manage Security

1. Create a Native Group and User
2. User Authentication and Authorization for Planning Applications
3. Refresh Security to Essbase
4. Assigning Provisioning to Groups

Part 6: WorkFlow Management and Task Lists

1. Work Flow with Live Example
2. Creation of Task Lists with Real-Time Scenarios

Part 7: Administration and Advanced Topics

1. Planning Administration
2. Introduction to EPMA and deployment of EPMA Application to EAS Console
3. Introduction to Workforce and Capex Planning
4. Design and Optimization of Planning Applications (Performance Issues)