Greens Technology
15 First Street Padmanabha Nagar, Adyar, Chennai
      Greens Technology Contact
Email: contact@greenstechnologys.com

ORACLE HYPERION TRAINING IN CHENNAI

Best Oracle Hyperion Training In Chennai in-terms of syllabus and expert teaching. We offers classes designed, developed, and delivered by Professional Trainers who are also Certified Consultants. These experienced consultants bring a wealth of real-world, practical knowledge and examples into the curriculum and the classroom. There’s no better way to learn than from experienced consultants!


Total Modules in Hyperion Suit: Version 11.1.2 Latest

  • Hyperion Financial Reporting
  • Hyperion Interactive Reporting
  • Hyperion SQR Production Reporting
  • Hyperion Web Analysis
  • Hyperion Financial Management
  • Hyperion Planning
  • Hyperion Financial Data Quality Management, Enterprise Edition
  • Hyperion Profitability and Cost Management
  • Hyperion Crystal Ball Enterprise Performance Management
  • Hyperion Performance Scorecard
  • Hyperion Strategic Finance
  • Hyperion Disclosure Management
  • Hyperion Financial Close Management
  • Hyperion Data Relationship Management
  • Hyperion Smart View for Office
  • Hyperion Financial Management Analytics
  • Hyperion Quantitative Management and Reporting for Solvency II

Hyperion Essbase Course Content:

  • DATA WAREHOUSE CONCEPTS
  • Business Intelligence
  • Data warehouse
  • Business Requirement gathering
  • Star Schema Design
  • MDDB
  • OLAP vs. OLTP
  • Data & Metadata
  • Dimensional Table
  • Fact Table
  • HYPERION ESSBASE 11.x
  • Hyperion Architecture
  • Hyperion Essbase Architecture
  • Hyperion Essbase Analytical Architecture
  • Hyperion Essbase Administration Server Architecture
  • Configuring Essbase Server
  • Configuring Essbase Administration Console
  • Creating Essbase Analytic application and database
  • Explanation of Essbase components like Database Outline, calc script, Rule File & report Script.
  • Dimensions
    • Standard Dimensions
    • Attribute Dimensions
    • Dense & Sparse Dimensions
  • Dimension Properties
    • Dimensions Type Properties
    • Member Properties
  • Consolidation Properties
  • Storage Properties
  • Time balance properties
  • Variance Expenses
  • Skip Options
  • Dynamic Time Series (DTS members)
  • Building Outline
    • UsingManually
    • Using rule file with dynamic dimension build methods
    • User Defined Attributes (UDA’S)
    • Building manually, dynamic dimension build methods using rule file Shared members
    • Building manually, dynamic dimension build methods using rule file Two-pass
  • Building Dimensions using Rule file with dynamic Dimension Build Methods
    • Generation Reference
    • Level Reference
    • Parent/Child Reference
  • Loading Data into Outline With Rule (with realtime Scenarios)
  • Loading Data into Outline Without Rule file (freedom Data Loading)
  • Types of Free form data loading
    • Loading data from excel
    • Loading data using import from export data file
  • Explanation Excel Add-in recover
  • Building Reports with Excel Add-in
  • Creating Formulas with real time scenarios
  • Creating Calc Script (simple to Complex real Examples)
  • Building Reports with Report scripts
  • ESSCMD & Maxl
  • Batch process
  • Differences between BSO & ASO
  • Outline back & Recovery
  • Data Backup & Recovery
  • Creating Users / Groups
  • Creating Filters
  • Optimization Techniques
  • Outline Optimization
    • Data load Optimization
    • Calc Script Optimization
    • Database ptimization using Attribute dimensions
    • Database optimization using Data settings.



Certification Details For Hyperion Essbase:
Examination Code: 1z0-531

-Oracle Essbase 11 Certification Implementation Specialist

-OPN

-Certification Specialist


Hyperion Planning Course Content:

  • HYPERION PLANNING COURSE CONTENT
  • PLANNING OVERVIEW
  • Oracle's Enterprise Performance Management System
  • Oracle's Business Intelligence Suite Enterprise Edition Plus
  • Architecture of Planning
  • Relationship Between Planning and Essbase
  • Navigation of Workspace
  • CREATING DIMENSIONS
  • EPM Architect
  • Period, Scenario and Version Dimensions
  • Entity Dimensions
  • Account Dimensions
  • Custom Dimensions
  • METADATA
  • Loading Data
  • Using Application Views
  • Deploying Applications
  • Setting Up Exchange Rates
  • LOADING DATA AND CALCULATING DATABASE
  • Setting Up Data Loads and Calculating
  • Loading Data
  • SECURITY
  • Provisioning Users and Groups
  • Defining Access Levels
  • DESIGNING DATA FORMS
  • Creating Forms and Folders
  • Customizing
  • ENTERING DATA
  • In Planning
  • Using Smart View
  • Offline
  • BUSINESS RULES
  • Creating Business Rules
  • Building Runtime Prompts
  • Adding Formulas
  • Managing Business Rules
  • MANAGING PLAN PROCESS
  • Approval Process
  • Task Lists
  • ANALYZING PLANNING DATA
  • Financial Reporting
  • Reports in Workspace
  • WORKING WITH FINANCIAL CONTROLS
  • About Financial Controls
  • Creating Controls Groups, Sections, and Questions
  • Deleting and Restoring Controls Groups, Sections, and Questions
  • WORKING WITH IMPORT SCRIPTS
  • Working with Scripting Components
  • Working with Temporary Variables & Substitution Variables



Certification Details For Hyperion Planning:
Examination Code: 1z0-533

-Oracle Hyperion Planning 11 Certification Implementation Specialist

-OPN

-Certification Specialist


Hyperion Financial Management Course Content:

  • 1.Financial Reporting
    • Oracle's Enterprise Performance Management System
    • Oracle's BI Suite Enterprise Edition Plus
    • Financial Reporting Features and Architecture
    • Financial Management Data Sources

  • 2.Navigating Reports in Workspace
    • Workspace
    • Setting Preferences
    • Browsing the Repository
    • Searching for Items
    • Previewing and Printing Reports

  • 3.Interacting with Reports in Workspace
    • Annotations
    • Creating, Viewing, and Replying to Annotations
    • Integrating Reports into Microsoft Office Applications

  • 4.Navigating Reports in Reporting Studio
    • Reporting Studio
    • Opening Reports
    • Previewing and Printing

  • 5.Creating Basic Reports
    • Report Creation
    • Creating Reports and Grids
    • Selecting Members for Rows and Columns
    • Setting the Point of Viewv
    • Adding Rows or Columns
    • Saving Reports

  • 6.Applying Advanced Member Selections
    • Lists
    • Selecting Members by Using Lists
    • Selecting Members by Using Functions
    • Selecting Members for the Page Axis

  • 7.Customizing Grids
    • Selecting Database Connections in Reports
    • Attaching Documents to Reports
    • Displaying Line-Item Details
    • Setting Up Expansions to Display Detail Data
    • Adding Related Content Links to Reports

  • 8.Formatting Cells and Grids
    • Formatting Cells
    • Formatting Grids
    • Suppressing Data
    • Applying Conditional Formatting in Grids
    • Setting Up Pages

  • 9.Creating Report Objects
    • Adding Text Boxes and Images
    • Saving Report Objects
    • Inserting Saved Report Objects
    • Designing Headers and Footers
    • Designing Row and Column Templates

  • 10.Adding Text Functions
    • Text Functions
    • Inserting Text Functions
    • Common Text Functions

  • 11.Adding Auto Calculations and Mathematical Functions
    • Auto Calculations
    • Mathematical Functions
    • Mathematical Operators in Expressions
    • Formulas
    • Common Mathematical Functions

  • 12.Creating Books
    • Books
    • Previewing and Printing Books
    • Changing the Book Point of View
    • Importing Files into the Repository
    • Creating Books
    • Changing the Appearance of Books

  • 13.Creating Batches
    • Working with Batches
    • Scheduling Batches
    • Scheduling Batch-Bursting Options
    • Monitoring Batch Schedules

  • 14.Managing Items in the Repository
    • Managing User Points of View
    • Creating E-Mail Links
    • Managing Repository Items
    • Managing Database Connections
    • Setting Permissions for Repository Items
    • Working with Temporary Variables
    • Manually Executing Custom Custom Web Scripts
    • WORKING WITH IMPORT INTEGRATION SCRIPTS
    • About Import Integration Scripts
    • Creating Import Integration Scripts
    • Assigning Import Integration Scripts to Import Formats
    • WORKING WITH EVENT SCRIPTS
    • About Event Scripts
    • Creating Event Scripts
    • Changing Import Formats Dynamically.




Certification Details For Hyperion Planning:
Examination Code: 1z0-532

-Oracle Hyperion Financial Management Implementation Specialist

-OPN

-Certification Specialist





  • Dinesh J
    CEO, Greens Technology
    Trainer, Exp: 12 yrs
    Mobile: +91 8939915577
  • About Trainer

    Dinesh is a Hyperion Essbase Certified Professional™ and a Hyperion Certified Instructor™. Having worked as a consultant and trainer on Essbase since 2005, he has been exposed to a wide range of analytical applications including planning/forecasting, consolidation, statistical modeling. Dinesh broad training background includes most recently running a training company, GT (Greens Technology) focused on developing and deploying practical applied training on Hyperion products to customers and partners. His technical skills encompass all aspects of implementing Essbase, Planning and some of the peripheral products. In addition to his OLAP experience he comes from a relational background, having worked with Oracle RDBMS and other products for Oracle. Dinesh has a MS in Computer Engineering from UC Santa Barbara and has completed many of the Master Certification at Oracle University. Contact Dinesh at dinesh@oraclechennai.in