Category Archives: Hyperion

Oracle Hyperion Server Access

Hyperion Server Access 24/7 by Spiritsofts, Oracle Hyperion Installation 11.1.2.4 , 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 11.1.2.4 , Hyperion Essbase Installation 11.1.2.4 , Planning installation 11.1.2.4 , 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 11.1.1.3, 11.1.2.1 and 11.1.2.4 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 11.1.2.3

  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

  Frequencies

  Currency Translation

  Profile Segments

  Aging Profiles

  System Attributes

Security

  User Groups

  Assigning Security roles

  Viewing and provisioning Report

  Configuring power user security

  Enabling security Auditing

Reconciliation formats

  Reconciliation Methods

  Custom Attributes

  Reconciliation formats

  Instructions

  Questions

Profiles

  Profile properties

  Instructions

  Workflow

  Currency

  Commentator and Viewer

Importing, Exporting and Updating Account profiles

  Importing and exporting Account profiles

  Create Basic and Advanced filters

  Bulk updating of Account profiles

Periods

  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

OBIEE Online Training Course ContentORACLE BUSINESS INTELLEGENCE ENTERPRISE EDITION [OBIEE]

Introduction to OBIEE:

Project Development
Oracle Answers and Interactive Dashboards
Reports
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
Process
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*

 

 

Introduction

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

.

.

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