HFR Course Content

for more details, pls contact Whatsup- 8152873070, Contact@ITSoftwareGuru.com, 91- 815 287 3070

Hyperion Financial Reporting(HFR) is a Powerful tool for creating highly formatted financial reports and designing and presenting analytic data graphically.

* HFR Notes

HFR Interview Questions

 * Class Delivery:  Online Class/ Class Room Training.

* Duration:  5 days, Week days- Mon to Fri, 7.30 AM to 8.30 AM, IST

* Learning Material: Complete material for Theory.

 * Lab:    Exercises/practices on real-time Projects.

 * About Hyperion Trainer: Hyperion Trainer is an Hyperion Real Time Expert in all Hyperion modules, have 15 years USA/India  experience  in  Hyperion Admin, Development, Support of Hyperion different modules. He is working in MNC. 

*  Audience/ Prerequisites for Hyperion Training 

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

2. Navigating Reports in Workspace

·         Workspace Overview

·         Setting Preferences

·         Browsing the Repository

·         Searching for Items

·         Previewing and Printing Reports

3. Interacting with Reports in Workspace

·         Annotations Overview

·         Creating, Viewing, and Replying to Annotations

·         Integrating Reports into Microsoft Office Applications

4. Navigating Reports in Reporting Studio

·         Reporting Studio Overview

·         Opening Reports

·         Previewing and Printing Reports

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

6. Applying Advanced Member Selections

·         Lists Overview

·         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 Overview

·         Inserting Text Functions

·         Common Text Functions

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

Planning Training Content

                         

for more details, pls contact WhatsApp- 8152873070, SanatanaSoft@gmail.com,  91- 815 287 3070.

Hyperion Planning product is to provide a Planning, Budgeting, and Forecasting solution that helps you manage and coordinate all your business planning and budgeting needs.

Planning Interview Questions

 * Class Delivery:  Online Class/ Class Room Training.

* Duration:  10 days, Week days- Mon to Fri, 7.30 AM to 8.30 AM, IST

* Learning Material: Complete material for Theory.

 * Lab:    Exercises/practices on real-time Projects.

 * About Hyperion Trainer: Hyperion Trainer is an Hyperion Real Time Expert in all Hyperion modules, have 15 years USA/India  experience  in  Hyperion Admin, Development, Support of Hyperion different modules. He is working in MNC. 

*  Audience/ Prerequisites for Hyperion Training 

I. PLANNING OVERVIEW

• Oracle's Enterprise Performance Management System
• Architecture of Planning
• Relationship between Planning and Essbase
• Navigation of Workspace

II. CREATING DIMENSIONS

• EPM Architect
• Period, Scenario and Version Dimensions
• Entity Dimensions
• Account Dimensions
• Custom Dimensions

III. METADATA

• Loading Data
• Using Application Views
• Deploying Applications

IV. LOADING DATA AND CALCULATING DATABASE

• Setting Up Data Loads and Calculating
• Loading Data

V. SECURITY

• Provisioning Users and Groups
• Defining Access Levels

VI. DESIGNING DATA FORMS

• Creating Forms and Folders
• Customizing

VII. ENTERING DATA

• In Planning
• Using Smart View
• Calc script/Business rules
• Creating Business Rules/Calc scripts

VIII. MANAGING PLAN PROCESS

• Approval Process
• Task Lists

X. ANALYZING PLANNING DATA

• Financial Reporting
• Reports in Workspace
• Life Cycle Management
• Converting  Classic application to EPMA application

Essbase- Real Time Questions

                                           Essbase- Real Time Questions

1. Level 0 Data back up: You have level o data back up.  Suppose Bangalore users data got corrupt.  How you will restore  only Bangalore data only.  No need to restore  overall data?

2. Cube performance: A customer has a cube with 10 dimensions and the performance was fine. Now they have added two more dimensions in the existing cube and the performance becomes very slow. Customer said logically nothing wrong with the two new dimensions they have added. What could be the reason for slow down?

Navigation for Hyperion Software

                            I. Start “VMWare with Hyperion”

   

* VMWare Workstation- 10

  

* Click on “VMware workstation" Icon.

 * Power on or Resume Virtual Machine (if it is in Suspend Mode) 

                            II. Start "Essbase Services- 4"

 * 2 ways for Services windows

   

    * Icon: Start “Administration Services Console”                

                            Or

    * Start, Run, services.msc

     

        * Hyperion Services Starting

            * open "Hyperion Foundation OpenLDAP", right click "Start"

           * open "Hyperion Foundation Shared Services- Web Application", right click "Start"

           * open "Hyperion Essbase Services 11.1.1.3- hypservice- 1", right click "Start"

          * open "Hyperion Administration Services- Web Application", right click "Start"              

                  III. Start "Administration Services Console”

    * Start, programs, Oracle EPM System", Essbase, Essbase Administration Service, start Administration services Console

  * Administrator server:  hyp113

      *User name: admin

      *Password: password

   * Enterprise View

     * Essbase Servers

        * hyp113

        * Applications

           * Sample

           *Walmart

                       IV. Stop "Essbase Services- 4"?

* Start, Run, services.msc      

* open "Hyperion Administration Services- Web Application", right click "Stop"

* open "Hyperion Essbase Services 11.1.1- hypservice- 1", right click "Stop"

* open "Hyperion Foundation Shared Services- Web Application", right click "Stop"

* open "Hyperion Foundation OpenLDAP", right click "Stop"

                

                                            V. Shut Down

* Start (VMWare Desktop), Shut Down
     
              Comment: aaaa

* close “VMWare Workstation”

Prerequisites for Hyperion Training

Hyperion Career is good for  Freshers, IT Professionals, and Unemployed Youth.

The Hyperion  Training course is ideal for 

  * General Technical background
  *  Basic System Administration experience
  * Developers
  * Technical System Administrators
  * IT  Professionals
  * Database Administrators
  * Security Administrators
  * Database Designers
  * Application Developers who wish to include a valuable addition in their skill set.

Eligibility for Hyperion Course: BE,B.Tech,BS,MS, M.Tech,MBA, B.Com, M.Com, CA, BSc, MSc and All Graduates.

For more details, please contact Contact@sanatanasoft.com, 91- 815 287 3070,   Whatsapp: 8152873070

H1b Visa Process for Hyperion Professionals.

                                                 

                                                  1.   All Passports all pages.

                                                  2.   Degree Certificate and Transcripts.

                                                  3.   Copies of Pay statements

                                                 4.   Marriage Certificate

                                                 5.   Experience / Reference Letters

1. All Passports all pages.

2. Latest I-94 (Front and Back) ( For Change of Status in USA)- Done

3. Degree Certificate and Transcripts.

4. Copies of all H1s, L1s, H4s held  (For Change of Status in USA)

5. Copies of Pay statements (Self or Principal for H4, L2s)

6. Marriage Certificate (For H4, L2 Applicants)

7. Educational Evaluation. (Foreign Equivalency)

8. Entry & Exit Details (H1, H4, L1) - Page 11 of I-129 Supplement

9. Experience / Reference Letters

10. SSN Card (if applicable)

For more details, please contact Contact@sanatanasoft.com, 91- 815 287 3070,   Whatsapp: 8152873070

Hyperion Essbase Training and Placement

       

      Hyperion Essbase, Planning and HFR Training - Class Room/Online

1. Real Time Classes- 

      helps for Interviews& Job.

  2.Lab Material.

  3.Study Material

  4.Hyperion Interview Session: Special Classes for Interview.

  5.Hyperion Software Installation help.

 for more details, Please contact, Contact@ITSoftwaareGuru.com, 91- 815 287 3070

   

         Hyperion Placement/Job.

  1.Interview help  

           2.Resume Preparation

3.Refer to MNC 

Hyperion Training  Modules:

 Essbase, Planning, HFR, FDMEE, HFM,DRM, Hyperion Admin/Infrastructure