Total Pageviews

Saturday, July 2, 2016

Essbase Training Content


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

Essbase is a powerful and intuitive tool used to build highly useful analytical models,
reporting systems, and forecasting applications. The ease of use and power of Essbase

provide for a rapid development cycle.

 * Class Delivery:  Online Class/ Class Room Training.

* Duration:  20 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. 


I. Essbase Overview

·         Multidimensional Analysis
·         Oracle’s Enterprise Performance Management System
·         Oracle BI Suite Enterprise Edition Plus
·         Essbase
·         Production Environment Components

II. Designing Applications and Databases

·         Block Storage Implementation Process
·         Analyzing and Planning Implementations
·         Creating Applications and Databases
·         Creating Outline Structures
·         Modifying Member Properties

III. Designing Data Descriptor Dimensions

·         Data Descriptor Dimensions Overview
·         Designing Time Dimensions
·         Designing Scenario Dimensions
·         Outline Calculations
·         Designing Accounts Dimensions
·         Testing Outline Calculations

IV. Optimizing Data Descriptor Dimensions

·         Creating Member Aliases
·         Dimension Types
·         Creating Period-to-Date Totals
·         Dynamic Calc Members
·         Enhancing Accounts Dimensions
·         Optimizing Data Storage

V. Planning Dimension Designs

·         Business View Dimensions Overview
·         Combining Business Views
·         Planning Dimensions with Label Outlines

VI. Creating Basic Dimension Build Rules Files

·         Rules Files Overview
·         Creating Dimension Build Rules Files
·         Configuring Dimension Maintenance Settings

VII. Creating Advanced Dimension Build Rules Files

·         Advanced Dimension Build Rules Files Overview
·         Creating Shared Members
·         Manipulating Fields
·         Creating User-Defined Attributes

VIII. Loading Data

·         Data Load Overview
·         Creating Data Load Rules Files
·         Selecting and Rejecting Records
·         Capturing New Members

IX. Getting Started with Smart View

·         Smart View Overview
·         Configuring Data Sources
·         Creating Ad Hoc Reports
·         Setting the Point of View

X. Creating Reports with Smart View

·         Manipulating Multidimensional Data
·         Updating Essbase Data
·         Integrating Essbase Data with Microsoft Office
·         Customizing the User Experience

XI. Data Storage and Calculation

·         Calculation Overview
·         Database Calculation Order
·         Data Block Fundamentals
·         Data Blocks and the Index System
·         Database Statistics
·         Data Block Creation
·         Database Calculation Process

XII. Creating Calculation Scripts

·         Calculation Script Organization
·         Returning Correct Calculation Results
·         Troubleshooting CALC DIM Processes

XIII. Controlling the Calculation Process

·         Top-Down Calculation
·         Focusing Calculations with FIX Statements
·         Calculating Conditionally with IF Statements
·         Comparing FIX and IF Calculation Processes

XIV. Analyzing Member Attributes

·         Attribute Dimensions Overview
·         Adding Attribute Dimensions to Outlines
·         Design Considerations
·         Creating Attributes with Rules Files

XV. Analyzing Varying Attributes

·         Varying Attributes Overview
·         Creating Varying Attributes Overview
·         Viewing Varying Attribute Data

XVI. Task Automation


·         Automating Tasks Using MaxL
·         The MaxL Command Shell
·         MaxL Statements and Syntax
·         MaxL Username and Password Encryption
·         Debugging MaxL scripts
=================

Online Analytical Processing Overview

·         Data Transformation
·         Multidimensional View of Information
·         Dimensional Modeling
·         Data Cubes
·         Dimension Hierarchies
·         OLAP Solutions

Essbase architecture, components, and production cycle

·         Outlines
·         Load Rules
·         Calculation Scripts
·         Aggregations
·         Essbase Spreadsheet Add-in
·         Smart View

Block Storage Data Structure

·         Data Blocks and the Index System
·         Block Storage Database Statistics
·         Data Block Creation
·         Database Calculation Process

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


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


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.

Friday, July 1, 2016

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. 

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”

Monday, June 27, 2016

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