Hyperion ESSbase Training

 >>  Hyperion ESSbase Training

Hyperion ESSbase Training


 (4.9) | 750 Ratings


Introduction


Hyperion ESSbase 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

Module 1: Essbase Overview

Topics: Understanding Multidimensional Analysis, OLAP And Multidimensional Databases, Dimensions and Members, Essbase Architecture, Designing of Application and Databases, Estimating the Size of Essbase Database, Creating Applications and Databases, Linking Objects to Essbase Data, Oracle Bi Foundation Suite, Production Environment Components

Module 2: Designing Applications And Databases

Topics: Analyzing and Planning Implementations, Creating Applications and Databases, Essbase Implementation Process, Creating Outlines

Module 3: Overview Of Data Loading And Dimensions Building

Topics: Understand the Data Load and Dimensions Building, Creating Rules Files, Using a Rule File For Performing the Operations, Performing and Debugging Data Loads, Understanding Advanced Dimensions Building Concepts, Loading Data Using Free Forms, Loading Data with a Rule, Creating Attribute Dimensions

Module 4: Designing Data Descriptor Dimensions

Topics: Designing Time Dimensions and Account Dimensions, Outline Calculations, Testing Outline Calculations, Designing Scenario Dimensions

Module 5: Optimizing Data Descriptor Dimensions

Topics: Dimension Types, Creating a Period to Date Totals, Creating Member Aliases, Enhancing Accounts Dimensions, Optimizing Data Storage, Dynamic Calculations Members

Module 5: Developing Dimension Designs

Topics: Attributes in Database Design, Business View Dimensions Overview, Combining Business Views, Developing Label Outlines

Module 6: Creating Dimension Build Rules Files

Topics: Overview of Rules Files, Creating Dimension Create Rules Files, Manipulating Fields, Configuring Dimension Maintenance Settings, Creating Shared Members, Creating Attribute Dimensions With Rules Files, Creating User-Defined Attributes, Overview of Advanced Dimension Build Rules Files

Module 7: Loading Data

Topics: Data Load Overview, Selecting and Rejecting Records, Loading Actual Data with Load Rules, Capturing New Members, Creating Data Load Rules Files, Tips and Tricks For SQL Interface, Best Practices in Design

Module 8: Smart View

Topics: Navigating Smart View, Updating Essbase Data, Creating Ad Hoc Grids, Integrating Essbase Data with Ms Office, Setting the Point of View, Creating Shared Database Perspectives, Associating Data Sources with Worksheets, Connecting to Data Sources, Creating Custom Reports, Creating Free-Form Grids

Module 9: Data Storage And Calculation

Calculation Overview, Data Block Fundamentals, Database Calculation Order, Interpreting Database Statistics, Referencing Members in Calculations, Data Block Creation, Data Blocks and the Index System, Mastering the Calculation Process,Database Calculation Process, Controlling Scripts, Developing and Testing Complex Calculation Scripts

Module 10: Normalizing Data

Topics: Allocating Data, Normalizing Rates and Drivers, Planning Data Normalization, Copying and Clearing Data

Module 11:Analyzing

Topics: Varying Attributes Overview, Creating Varying Attributes, Viewing Varying Attributes Data, Typed Measures Overview, Enabling Typed Measures, Creating Date Measures, Creating Text Measures, Calculations Based on Typed Measures, Viewing Typed Measures.

Exam & Certification

0

Course Review

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

Course Curriculum

Module 1: Essbase Overview

Topics: Understanding Multidimensional Analysis, OLAP And Multidimensional Databases, Dimensions and Members, Essbase Architecture, Designing of Application and Databases, Estimating the Size of Essbase Database, Creating Applications and Databases, Linking Objects to Essbase Data, Oracle Bi Foundation Suite, Production Environment Components

Module 2: Designing Applications And Databases

Topics: Analyzing and Planning Implementations, Creating Applications and Databases, Essbase Implementation Process, Creating Outlines

Module 3: Overview Of Data Loading And Dimensions Building

Topics: Understand the Data Load and Dimensions Building, Creating Rules Files, Using a Rule File For Performing the Operations, Performing and Debugging Data Loads, Understanding Advanced Dimensions Building Concepts, Loading Data Using Free Forms, Loading Data with a Rule, Creating Attribute Dimensions

Module 4: Designing Data Descriptor Dimensions

Topics: Designing Time Dimensions and Account Dimensions, Outline Calculations, Testing Outline Calculations, Designing Scenario Dimensions

Module 5: Optimizing Data Descriptor Dimensions

Topics: Dimension Types, Creating a Period to Date Totals, Creating Member Aliases, Enhancing Accounts Dimensions, Optimizing Data Storage, Dynamic Calculations Members

Module 5: Developing Dimension Designs

Topics: Attributes in Database Design, Business View Dimensions Overview, Combining Business Views, Developing Label Outlines

Module 6: Creating Dimension Build Rules Files

Topics: Overview of Rules Files, Creating Dimension Create Rules Files, Manipulating Fields, Configuring Dimension Maintenance Settings, Creating Shared Members, Creating Attribute Dimensions With Rules Files, Creating User-Defined Attributes, Overview of Advanced Dimension Build Rules Files

Module 7: Loading Data

Topics: Data Load Overview, Selecting and Rejecting Records, Loading Actual Data with Load Rules, Capturing New Members, Creating Data Load Rules Files, Tips and Tricks For SQL Interface, Best Practices in Design

Module 8: Smart View

Topics: Navigating Smart View, Updating Essbase Data, Creating Ad Hoc Grids, Integrating Essbase Data with Ms Office, Setting the Point of View, Creating Shared Database Perspectives, Associating Data Sources with Worksheets, Connecting to Data Sources, Creating Custom Reports, Creating Free-Form Grids

Module 9: Data Storage And Calculation

Calculation Overview, Data Block Fundamentals, Database Calculation Order, Interpreting Database Statistics, Referencing Members in Calculations, Data Block Creation, Data Blocks and the Index System, Mastering the Calculation Process,Database Calculation Process, Controlling Scripts, Developing and Testing Complex Calculation Scripts

Module 10: Normalizing Data

Topics: Allocating Data, Normalizing Rates and Drivers, Planning Data Normalization, Copying and Clearing Data

Module 11:Analyzing

Topics: Varying Attributes Overview, Creating Varying Attributes, Viewing Varying Attributes Data, Typed Measures Overview, Enabling Typed Measures, Creating Date Measures, Creating Text Measures, Calculations Based on Typed Measures, Viewing Typed Measures.

    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