Oracle Hyperion Training in Chennai & Best Oracle Hyperion Essbase Training Institute in Chennai

HYPERION ESSBASE course content

Essbase Overview:

• Multidimensional Analysis
• Oracle’s Enterprise Performance Management System
• Essbase
• Production Environment Components
• Designing Applications and Databases
• Creating Applications and Databases
• Creating Outlines
• Designing Data Descriptor Dimensions
• Data Descriptor Dimensions Overview
• Designing Time Dimensions
• Designing Scenario Dimensions
• Outline Calculations
• Designing Accounts Dimensions
• Testing Outline Calculations
• Optimizing Data Descriptor Dimensions
• Creating Member Aliases
• Dimension Types
• Creating Period to Date Totals
• Dynamic Calc Members
• Enhancing Accounts Dimensions
• Optimizing Data Storage
• Developing Dimension Designs
• Business View Dimensions Overview
• Attributes in Database Design
• Combining Business Views
• Developing Label Outlines
• Creating Basic Dimension Build Rules Files
• Rules Files Overview
• Creating Dimension Build Rules Files
• Configuring Dimension Maintenance Settings
• Creating Advanced Dimension Build Rules Files
• Advanced Dimension Build Rules Files Overview
• Creating Shared Members
• Manipulating Fields
• Creating User Defined Attributes
• Creating Attribute Dimensions with Rules Files
• Loading Data
• Data Load Overview
• Creating Data Load Rules Files
• Selecting and Rejecting Records
• Capturing New Members
• Getting Started with Smart View
• Navigating Smart View
• Connecting to Data Sources
• Creating Ad Hoc Grids
• Setting the Point of View
• Associating Data Sources with Worksheets
• Creating Free Form Grids
• Creating Reports with Smart View
• Updating Essbase Data
• Integrating Essbase Data with Microsoft Office
• Creating Shared Database Perspectives

Hyperion Financial Reporting course content:

Financial Reporting Overview:

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

Navigating Reports in Workspace

• Workspace Overview
• Setting Preferences
• Browsing the Repository
• Searching for Items
• Previewing and Printing Reports

Interacting with Reports in Workspace:

• Annotations Overview
• Creating, Viewing, and Replying to Annotations
• Integrating Reports into Microsoft Office Applications

Navigating Reports in Reporting Studio:

• Reporting Studio Overview
• Opening Reports
• Previewing and Printing Reports

Creating Basic Reports:

• Report Creation Overview
• Creating Reports and Grids
• Selecting Members for Rows and Columns
• Setting the Point of View
• Adding Rows or Columns
• Saving Reports

Applying Advanced Member Selections:

• Lists Overview
• Selecting Members by Using Lists
• Selecting Members by Using Functions
• Selecting Members for the Page Axis

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

Formatting Cells and Grids:

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

Creating Report Objects:

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

Adding Text Functions:

• Text Functions Overview
• Inserting Text Functions
• Common Text Functions

Adding Auto Calculations and Mathematical Functions:

• Auto Calculations Overview
• Mathematical Functions
• Mathematical Operators in Expressions
• Formulas Overview
• Common Mathematical Functions
• Creating Books
• Books Overview
• Previewing and Printing Books
• Changing the Book Point of View
• Importing Files into the Repository
• Creating Books
• Changing the Appearance of Books

Creating Batches:

• Working with Batches
• Scheduling Batches
• Scheduling Batch Bursting Options
• Monitoring Batch Schedules

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

Hyperion Financial Management:

• Introduction to Financial Management
• About Enterprise Performance Management

HFM Basics:

• Dimensions
• Define Application Profile
• Create application

Loading Metadata from a File:

• About Metadata Load Files
• Loading Metadata
• Manage Metadata
• Prepare own Metadata

Configuring Accounts and Custom Dimensions:

• About Accounts and Custom Dimensions
• Setting Up Account Types and Hierarchies
• Setting Up Accounts and Custom Dimensions
• Intercompany Account and Other Account Properties

Setting Up Entities, Calendars, and Scenarios:

• Setting up Entities
• Setting Up Calendars
• Setting Up Scenarios

Loading Data:

• Loading Data Files
• Extracting Data
• Copying and Removing Data

Creating Tasklist and Data Forms:

• About Data Forms
• Accessing the Form Builder
• Defining the Point of View
• Defining Columns and Rows
• Setting Row and Column Options
• Exporting Data to Spreadsheets

Entering Data Using Data Grids:

• About Data Grids and Accessing Data Grids
• Changing the Grid Layout and Display
• Selecting Members for Dimensions
• Selecting Members
• Saving Grid Settings
• Entering Data and Filling Multiple Cells
• Spreading and Calculating Data
• Adding Cell Text and Line Item Detail

Creating Member Lists in Financial Management:

• About Member Lists
• System and User Defined Member Lists
• Creating Member Lists
• Identifying Member Lists in a File
• Creating Static Member Lists
• Creating Dynamic Member Lists for the Entity Dimension and Other Dimensions
• Loading and Extracting Member Lists

Entering Intercompany Data:

• About Intercompany Transactions
• Intercompany Account Balances
• Elimination Process
• Plug Accounts
• Intercompany Eliminations and the Value Dimension
• Setting Up Entities and Accounts for Intercompany Data
• Creating and Running Intercompany Matching Reports

Adjusting Data with Journals:

• About Journals and Journal Benefits and Adjusting Data
• Journals Review Process and the Value Dimension
• Multiple Journal Postings, Accessing Journals and Opening Periods for Journal Entry
• Creating Journal Templates and Journal Balance Types
• Creating Journals and Entering Journal Data
• Creating, Previewing, Running and Viewing Adjustments with the Entity Details Report
• Setting Journal Report Properties and Selecting Columns and Filters
• Saving Journal Reports Locally and Remotely

Running Consolidations and process management:

• Consolidation Process and Percentages
• Entering Consolidation Information Using Ownership Management
• Running Consolidations
• Checking Consolidation Status
• Data Translation
• Entering Exchange Rates

Analyzing Data Using Smart View:

• About Smart View
• Smart View Installation and Components
• Connecting to a Data Source
• Entering Data with Web Data Forms
• Functions in Smart View

Rule:

• About Rules and Rules Syntax
• Rule Types and Rules Files
• Objects and Functions in Rules
• Assigning Values to Accounts
• Account Expressions
• Setting Values for Multiple Accounts
• Subcubes, Data Retrieval, and Rules
Loading and Extracting Rules

Hyperion Financial Data Quality management course content:

Product Orientation:

• Oracle's Enterprise Performance Management System
• Benefits and Features of FDM
• ERP Integrator
• Processing Data Overview

Navigating FDM:

• Accessing FDM
• Working with the POV
• Locking Out Users for Maintenance
• Running Reports
• Viewing Graphical Timelines

Creating FDM Applications:

• About FDM Applications
• Creating Applications
• Managing Applications

Integrating Applications:

• Integration Overview
• Importing, Registering, and Configuring Adapters
• Adding Machine Profiles
• Configuring Application Settings
• Configuring Integration Settings
• Testing Integrations
• Setting Up Standard Reports and Templates

Setting Up Control Tables and Locations:

• Viewing Control Tables
• Managing Control Tables
• Viewing Locations
• Managing Locations
• Setting Location Attributes
• Searching Control Trees

Setting Up Mapping Tables:

• Mapping Dimension Members
• Building Maps
• Map Types
• Processing Order
• Building Maps Externally
• Copying Maps
• Sharing Dimension Maps
• Setting Up Conditional Mapping
• Building Import Formats
• About Import Formats
• Creating Import Groups
• Creating Import Formats
• Assigning Import Formats
• Adding Import Expressions

Loading Data:

• About Loading Data
• Importing Source Data
• Working with Records
• Validating Dimension Mappings
• Loading Data to Target Systems
• Drilling into Data
• Drilling Through from Target Applications

Building Validation Rules:

• About Validation Rules and Reports
• Creating Validation Rule Groups
• Creating Validation Rules
• Creating Validation Rules with Validation Editor
• Assigning Validation Rules to Locations
• Checking Validation Rules

Setting Up Validation Entities:

• About Validation Entities
• Creating Validation Entity Groups
• Creating Validation Entities
• Assigning Validation Entity Groups to Locations
• Verifying Consolidations

Processing Batch Files:

• About Batch Processing
• Setting Up Batch Load Files
• Processing Batches
• Creating Batch Scripts
• Scheduling Batch Scripts in Task Manager

Creating Logic Accounts:

• About Logic Accounts
• Creating Logic Groups
• Creating Simple Logic Accounts
• Creating Complex Logic Accounts
• Assigning Logic Groups to Locations

Loading FDM Journals:

• About FDM Journals
• Creating Journal Templates
• Adding Metadata Tags
• Loading Journal Templates

Loading Data with Multiload Files:

• About Multiload Files
• Creating Multiload Excel Templates
• Creating Multiload Text Files
• Loading Multiload Files
• Viewing Errors

Setting Up Security:

• About FDM Security
• Security Levels
• Setting Up Object Security
• Setting Up User Security
• Locking and Unlocking the Local POV Mode
• Setting Up Report Group Security

Working with Financial Controls:

• About Financial Controls
• Creating Controls Groups, Sections, and Questions
• Deleting and Restoring Controls Groups, Sections, and Questions
• Assigning Reviewer, Submitter, and Proxy Rights
• Accessing Financial Controls
• Selecting Application Settings for Financial Controls

Working with Import Scripts:

• About Scripting in FDM
• Working with Scripting Components
• Creating Import Scripts
• Assigning Import Scripts to Import Formats
• Applying Scripting Functions to Import Scripts
• 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

Oracle Hyperion training duration in Chennai

Regular Classes( Morning, Day time & Evening)

• Duration : 5 weeks

Weekend Training Classes( Saturday, Sunday & Holidays)

• Duration : 6 Weeks

Fast Track Training Program( 3+ hours classes daily)

• Duration : within 3 weeks

Oracle Hyperion trainer Profile & Placement

Our Oracle Hyperion Trainers

• More than 5 Years of experience in Oracle Hyperion Technologies
• Has worked on 10 realtime Oracle Hyperion projects
• Working in a MNC company in Chennai
• Trained 1746+ Students so far.
• Strong Theoretical & Practical Knowledge
• Oracle Hyperion certified Professionals

Oracle Hyperion (oracle hyperion essbase) Placement Training in Chennai

• More than 1746+ students Trained
• 1399 students Placed
• 762 Interviews Organized
• Placement Supported by InterviewDesk.com

Oracle Hyperion training Locations in Chennai

Our Oracle Hyperion Essbase Training centers

• Adyar
• Ambattur
• Adambakkam
• Anna Nagar
• Anna Salai
• Ashok Nagar
• Choolaimedu
• Chromepet
• Ekkattuthangal
• Guindy
• Kodambakkam
• Madipakkam
• Mylapore
• Porur
• Saidapet
• T. Nagar
• Tambaram
• Vadapalani
• Velachery
• Villivakkam
• Virugambakkam

Oracle Hyperion training batch size (students per class) in Chennai

Regular Batch ( Morning, Day time & Evening)

• Seats Available : 9 (maximum)

Weekend Training Batch( Saturday, Sunday & Holidays)

• Seats Available : 11 (maximum)

Fast Track batch

• Seats Available : 8 (maximum)

Oracle Hyperion related training courses

• Data Warehousing course
• Informatica course
• TeraData course
• Ab initio course
• Cognos course
• Datastage course
• OBIEE course
• ETL Testing course
• Microsoft Dynamics course
• MSBI course
• Microstrategy course
• IBM Cognos TM1 course
• IBM Cognos administration course