Category Archives: Hyperion

Oracle Hyperion Server Access

Hyperion Server Access 24/7 by Spiritsofts, Oracle Hyperion Installation , Infrastructure Training and Job Support and Placement Assistance. We are also providing Training on Hyperion Essbase, Planning, HFM Training, FDMEE, ODI, DRM Training,……….

Hyperion Server Access and Job Support

Hyperion Installation:

Hyperion InstallationOracle Hyperion Installation , Hyperion Essbase Installation , Planning installation , HFM, ODI, DRM FDMEE……

Hyperion Support :

Hyperion Support by SpiritsoftsHyperion Job Support by Spiritsofts with real time Experts, Automation Scripting, And more

  • installation and configurations of Hyperion EPM suite in distributed environment in, and versions.
  • version up-gradation.
  • Apply patches to fix bugs.
  • Artifacts backup of EPMA applications using LCM (Automated process).
  • Migrated applications in different environments

Hyperion Infrastructure Course Content :  Click Here

Hyperion Financial Close Management Training

Oracle Hyperion Financial Close Management is built for centralized, web based management of period end close activities across the extended financial close cycle. The first application of its kind, Oracle Hyperion Financial Close Management training will help manage all financial close cycle tasks including ledger and sub ledger close, data loading and mapping, financial consolidation, account reconciliation, supplemental schedule management, tax/treasury and internal and external reporting processes

Hyperion Financial Close Management Online Training Course Content

  Hyperion ARM: Hyperion Account Reconciliation Manager

  Audience: Accountants and Financial Analyst
  Pre-requisites :
  Advanced Preparation :
Learning Objectives

This course teaches you how to setup and Manage Account Reconciliations Manager module of Financial Close Management

Course Description
This session is designed for how to create the profiles, periods, Formats, load account balances, currency rates into periods , perform account reconciliations, and monitor account reconciliations workflow and Security
Course Summary

  Create Account Profiles

  Create formats

  Configure System Settings

  Set up Reconciliation workflow

  Create Periods and load balances

  Perform reconciliations and monitor the reconciliations process

  Report Binder

Detailed Agenda
ARM System Setting


  Currency Translation

  Profile Segments

  Aging Profiles

  System Attributes


  User Groups

  Assigning Security roles

  Viewing and provisioning Report

  Configuring power user security

  Enabling security Auditing

Reconciliation formats

  Reconciliation Methods

  Custom Attributes

  Reconciliation formats




  Profile properties




  Commentator and Viewer

Importing, Exporting and Updating Account profiles

  Importing and exporting Account profiles

  Create Basic and Advanced filters

  Bulk updating of Account profiles


  Creating profiles

  Copying Account profile into periods

  Identifying missing profile

  Identifying Invalid profile

  Updating Reconciliations

  Deleting Periods

Managing Reconciliations

  Opening Period

  Adding Transaction to reconciliations

  Submitting reconciliations

  Reviewing and approving Reconciliations

  Closing and Locking periods

Loading Balances

  Data Load process

  Running data Loads

  Viewing warnings

  Drill Through

Managing Reconciliations

  Opening Periods

  Adding Transactions to Reconciliations

  Submitting Reconciliations

  Reviewing and Approving Reconciliations

  Closing and Locking Periods

Monitoring Reconciliations

  Viewing Reconciliations and transactions in List Views

  Viewing Reconciliations in the Dashboard

  Customizing the Dashboard

  Creating Report Binders

  Viewing Report Binders

Reassigning Reconciliations

  Reassigning a reconciliation to a different user

Oracle ODI Online Training

Oracle ODI Online Training by Spiritsofts, Live ODI Training Online Classes with Experts. Oracle Data Integrator Training Material ODI 11g/12c Our Institutes in Hyderabad Bangalore USA Canada Australia Singapore and Dubai ✓Cerification Training ✓Real time Scenarios ✓Pay Installments* ✓24/7 Server Access ✓Job Support.

Oracle ODI Online Training Course Content
  • History of ODI 11g
  • ODI 11g Architecture
  • ODI 11g Installation
  • Creating Master and Work Repository (Manual & RCU Method)
    • Create the Master Repository
    • Create the Work Repository
  • Configuring database
    • Configuring source database
    • Configuring Target database
  • Creating and Managing Topology
    • Creating Physical Architecture
    • Creating Logical Architecture
  • Creating Contexts
  • Creating Model
  • Creating Project
  • Create a Simple Mapping using Filter
  • Create interface to load data from Flat File to Target Data Base
  • Create interface to load data from Flat File to Target Flat File
  • Create Interface using Joiner
  • Create interface using Lookup
  • Creating User Functions
  • Variables
    • Global Variables
    • Project Variables
  • ODI Sequences
  • ODI Procedures
  • ODI Packages
  • ODI Scenarios
  • ODI Version Control
  • ODI Agent
  • ODI Load Plan Creation
  • ODI Migration (DEV, UAT and PROD)
  • ODI Security
  • ODI Modifying Knowledge Modules
  • ODI Change Data Capture (CDC)
  • ODI Slowly Changing Dimension (SCD-Type-1,2,3)


ODI Online Training Inerview Questions and Answers – Spiritsofts

OBIEE Online Training


Introduction to OBIEE:

Project Development
Oracle Answers and Interactive Dashboards
Interactive dashboards
Oracle Business Intelligence Publisher
OBIEE Administrator Architecture

Hyperion Infrastructure (Administrator) Training

Oracle Hyperion Infrastructure (Administrator) Training Course Content

Oracle EPM System Environment Overview
HSS (Hyperion Shared Services)
Common Activities
Batch/Shell scripts
Oracle DB
Adhoc Activities
Performance tuning
Logs &Trouble Shooting
Other Topics
Realtime Issues
Interview Point of view

DRM Training

Oracle DRM Online Training Classes with Experts, Learn DRM Training Online in Spiritsofts, Best institute for Hyperion Data Relationship Management Hyderabad USA UK Canada Australia Singapore and Dubai Course Material Installation Job Support 24/7 Server Access Resume Preparation Placement Assistance*




  • About Data Relationship Management
  • Task Group Descriptions
  • Key User Experience Differences
  • Logon
  • Browse
  • Query
  • Compare
  • Script
  • Import
  • Blend
  • Export
  • Audit
  • Administer


Managing Versions

  • Data Relationship Management Version Life Cycle
  • Version Type and Status
  • Creating Versions
  • Copying Versions
  • Saving Versions
  • Contents iii
  • Creating As-Of Versions
  • Editing Version Properties
  • Assigning Validations to Versions
  • Unloading and Deleting Versions


Managing Hierarchies

  • Creating Hierarchies
  • Editing Hierarchy Properties
  • Enabling and Disabling Node Types
  • Opening Hierarchies
  • Creating Hierarchy Groups
  • Assigning Hierarchies to Hierarchy Groups
  • Assigning Controlled Properties
  • Assigning Controlled Node Access Groups
  • Assigning Validations
  • Deleting Hierarchies


Working with Nodes

  • About Nodes
  • Adding and Inserting Nodes
  • ID Function
  • Modeling a Node
  • Moving and Ordering Nodes
  • Relaxed Move Option
  • Sorting Nodes
  • Node Deletion Methods
  • Merging Nodes
  • Deleting Nodes
  • Removing Nodes
  • Annulling Nodes
  • Inactivating Nodes
  • Reactivating Nodes
  • Assigning Validations
  • Orphan Nodes
  • Viewing Orphan Nodes
  • Deleting Orphan Nodes
  • Navigating in Tree View
  • Finding Nodes
  • Node Security
  • Using Shared Nodes
  • iv Contents
  • Shared Node Properties
  • Enabling Shared Nodes
  • Adding and Inserting Shared Nodes
  • Removing and Deleting Shared Nodes
  • Renaming Shared Nodes
  • Converting a Shared Node to a Primary Node
  • Displaying Shared Nodes


Managing Properties

  • Property Categories
  • System Properties
  • Stats Properties
  • Property Value Scope and Origin
  • Property Status
  • Editing Property Values


Validating Data

  • Validating Versions
  • Validating Hierarchies
  • Validating Nodes
  • Navigating Validation Results
  • Navigating Version and Hierarchy Results in Li
  • st View
  • Navigating Node Results in List View
  • Navigating Node Results in Tree View
  • Downloading Node Results
  • Clearing Validation Results


Using Queries

  • Query Types
  • Creating Queries
  • Navigating Query Results
  • Navigating in List View
  • Navigating in Tree View
  • Downloading Query Results
  • Managing Queries
  • Opening Queries
  • Copying Queries
  • Deleting Queries


Comparing Hierarchies

  • Compare Types
  • Contents v
  • Visual Compare
  • Structure Compare
  • Property Compare
  • Rename Compare
  • Creating Compares
  • Navigating Compare Results
  • Navigating in List View
  • Navigating in Tree View
  • Downloading Compare Results
  • Managing Compares
  • Opening Compares
  • Copying Compares
  • Deleting Compares


Working with Action Scripts

  • Loading Action Scripts From Flat Files
  • Downloading Action Script Results
  • Required Action Script Parameters
  • Loading Action Scripts From a Transaction Log
  • Loading Action Scripts From a Node Model


Working with Imports

  • Import Sections
  • Creating Imports
  • Running, Copying, and Deleting Imports


Blending Versions

  • Creating Blenders
  • Running, Copying, and Deleting Blenders


Working with Exports

  • Creating Exports
  • Creating Hierarchy Exports
  • Creating Hierarchy XML Exports
  • Creating Generation Exports
  • Creating Compare Exports
  • Creating Difference Exports
  • Creating Version Exports
  • Creating Property List Exports
  • Creating Property Lookup Exports
  • Creating Transaction Log Exports
  • vi Contents
  • Creating Merge Log Exports
  • Creating Export Books
  • Running, Copying, and Deleting Exports and Export Books

Working with Change Requests


Auditing Transaction and Request History

  • Auditing Transaction History
  • Data Actions in Transaction History
  • Administrative Actions in Transaction History
  • Auditing Requests


Using the Data Relationship Management Batch Client

  • Securing the Batch Client
  • Setting up Batch Client Credentials
  • Running the Batch Client
  • Dependencies
  • Saving Versions in the Batch Client
  • Command Line Syntax
  • Configuration File Syntax
  • Outputs and Result Codes



FDMEE Training


For Oracle FDMEE Training Demo Video

Oracle FDMEE Online Training Course content


1 Production Orientation
2.Preparing FDMEE Integrations
3.Setting Up Import Formats for File Systems
4.Completing the Integration Setup
5.Setting Up Data Load Mappings
6.Defining and Executing Data Load Rules
7.Processing Data in Data Load Workbench
8.Setting Up Check Rules and Check Entities
9.Processing Batches
10.Reporting in FDMEE
11.Setting up Security
12.Defining Import Scripts
13.Defining Mapping and Event Scripts
14.FDMEE Integration with Other Source Systems

Hyperion Financial Management Training

Hyperion Financial Management online training by Spiritsofts learn HFM training through  real time experts with real time scenarios and also providing placement assistance.


For HFM Training Demo Video

Hyperion Financial Management  Online Training Course content


1. Introduction to Financial Management

  • About Enterprise Performance Management


2. HFM Basics

  • Dimensions
  • Define Application Profile
  • Create application


3. Loading Metadata from a File

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


4. Configuring Accounts and Custom Dimensions

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


5. Setting Up Entities, Calendars, and Scenarios

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


6. Loading Data

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


7. 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


8. 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


9. 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


10. 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


11. Adjusting Data with Journals

  • Journals Review Process and the Value Dimension
  • 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


12. 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


13. 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


14. Rules

  • 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 Planning Online Training


For Oracle Hyperion planning Training Demo Video

Oracle Hyperion planning  Online Training Course content


1.Essbase Overview

  • Introduction to Hyperion
  • Introduction to Hyperion Planning
  • Hyperion Planning Architecture
  • RDBMS/Planning/Essbase
  • Hyperion Essbase Terminology
  • Navigating the Planning Web Client
  • Hyperion Workspace



2.Planning Dimensions and Data Storage Overview

  • Planning Dimensions Overview
  • Required Dimensions
  • User-Defined Dimensions
  • Dense Dimensions
  • Sparse Dimensions
  • Data Block Creation Process
  • Selecting Aggregation, Data Storage, And Calculation Options


3.Planning Application Creation

  • Classic Planning Application Creation
  • Pre-requisites to create Hyperion Planning Application
  • Oracle Schema Creation
  • Data Source Creation
  • Year and Timeperiod Setting
  • Currency Settings
  • Defining Plan Types
  • EPMA Planning Application Creation
  • Pre-requisites to create Hyperion Planning Application
  • Oracle Schema Creation
  • Data Source Creation
  • Dimension Library Creation Process
  • Year and Time period Settings
  • Currency Settings
  • Defining Plan Types


4.Loading metadata from File

  • Metadata building in Classic Planning Application
  • Metadata Creation Process
  • Manual Process (for learning purpose)
  • Loading Metadata into Planning Application using outline load utility
  • Metadata building in EPMA Planning Application
  • Metadata Creation Process
  • Manual Process (for learning purpose)
  • Loading Metadata into EPMA Planning Application using .ads flat files


5. Creating and Managing Web Forms

  • Creation of Simple Web Forms
  • Creation of Composite Web Forms
  • Creation of Web Form Folder Structure
  • Assigning BR to the Web Forms
  • Security on Web Forms
  • Security on Web Forms Folder Structure


6.Data Submission Process

  • Entering Data using Web Forms
  • Entering Data uisng Smart View


7.Creating Business Rules

  • Overview on Business Rules
  • Business Rules Creation Process
  • Using Run-Time Prompts in Business Rules
  • Defining Access Privileges to Business Rules


8. Creation of Smart Lists

  • Smart List Creation


9.Creation of Task Lists

  • Creation of Task Lists
  • Defining Access Privileges to Task Lists


10.Process Management Overview

  • Work Flow


11.Security Implementation

  • Hyperion Shared Services
  • Creation of Users
  • Creation of Groups
  • Assigning users to groups
  • Giving Access to Planning Application
  • Giving Security on Dimension Members
  • Giving Security on Business Rules
  • Giving Security on Task Lists


12.Real Time

  • Real time scenarios
  • Complexities faced in the implementation
  • Support Tickets or Real time Errors
  • Questionnaire
  • CV Preparation

Hyperion Essbase Training

Hyperion Essbase Online Training by Real time experts. Live Oracle Hyperion Essbase Training Classes with Course Material Our Institutes in Hyderabad Bangalore USA Canada Singapore Australia and Dubai Certification Training Job Support Hyperion Installation 24/7 Server Access Placement Assistance* Pay Installments Resume Preparation.


Enroll today for live demo class, Attend the Demo for free & you will find spiritsofts is the best Online Training Institute within reasonable fee, updated course materiel PDF.

The Training in Oracle Hyperion Essbase is every thing we explained based on real time scenarios,it works which we do in companies.

Experts Training sessions will absolutely help you to get in-depth knowledge on the subject.

Key FeaturesCourse ContentFAQs


 40 hours of Instructor Training Classes                            24/7 Support*

 Lifetime Access to Recorded Sessions                              Practical Approach

 Real World use cases and Scenarios                                 Expert & Certified Trainers

Hyperion Essbase Online Course Content :

Essbase Overview

1. Introduction to Hyperion Essbase

  • What is the requirement of Essbase?
  • History Of Essbase
  • Hyperion Essbase Architecture
  • Hyperion Essbase Versions
  • Hyperion Essbase Clients
  • Essbase Thin Client
  • Essbase Thick Client
  • MaxL or ESSCMD
  • Essbase Interaction Services
  • Essbase Studio


2. Essbase Application Type

  • BSO Application
  • Business Requirement of BSO App
  • ASO Application
  • Business Requirement of ASO App


3. Essbase Outline Terminology

  • What is Essbase Outline?
  • Data/Meta Data Explanation


4. Dimensions and Dimension Types

  • What is Dimension?
  • Standard Dimension
  • Dense Dimension
  • Sparse Dimension
  • Attribute Dimension
  • Account type Dimension
  • Time type Dimension
  • Currency Type Dimension


5. Attribute Dimension

  • What is the need of Attribute Dimension?


6. Alias and UDA creation

  • What is the requirement of Alias and UDA’s?


7. Member properties and Dimension properties

  • Data Storage Properties
  • Consolidation Properties


8. Outline building methods

  • Data Load Overview
  • Generation Reference
  • Level Reference
  • Parent/Child Reference


9. Data Loading Process

  • Data loading using flat files
  • Data loading using SQL
  • Free Form Loading


10. Essbase Calculation Process

  • Aggregation
  • Formulas
  • Calculation Sript
  • Two-Pass Calculation
  • Intelligent Calculation


11. Dense and Sparse Restructure

  • Dense Restructure
  • Sparse Restructure


12. Essbase Partitions

  • What is the requirement of Partiton?
  • Replicated Partition
  • Transparent Partition
  • Linked Partition


13. Essbase Optimization Techniques

  • Outline Optimization
  • Dataload Optimization
  • Calculation Sript Optimization
  • Database Optimization


14. Essbase Maxl or ESSCMD

  • How to automate Essbase Application Creation Using MaxL?
  • How to automate Essbase Application Creation Using ESSCMD?


15. Essbase Analytics VS Enterprise Analytics

  • BSO Advantages and Disadvantages
  • ASO Advantages and Disadvantages


16. Security Implementation

  • Security Type
  • EAS Security
  • Shared Service Security
  • Creation of Users
  • Creation of Groups
  • Creation of Essbase Filters
  • Assigning users to groups
  • Creation of Essbase Filters
  • Assigning filters to groups


17. Real Time

  • Real time scenarios
  • Complexities faced in the implementation
  • Support Tickets or Real time Errors
  • Questionnaire
  • CV Preparation
Who Are The Trainers?
What If I Miss A Class?
How Will I Execute The Practical?
If I Cancel My Enrollment, Will I Get The Refund?
Will I Be Working On A Project?
Are These Classes Conducted Via Live Online Streaming?
Is There Any Offer / Discount I Can Avail?
Who Are Our Customers?