Software Training

Hyperion is a Business Intelligence (BI) and Business Performance Management (BPM ) Tool. Its the market leader in Financial, Operational and Strategic Planning. It has applications for Planning, consolidation, scorecarding, reporting, dashboards, Analysis, Workspace, Master Data Management and Foundation. There is a sufficient demand in the industry for essbase consultants. Hyperion Training in Chennai is equipped with well trained human resources, Real-time Corporate Trainers, modern infrastructure – hardware and software resources.

Oracle Hyperion Planning 11 training in Chennai

OVERVIEW OF HYPERION PLANNING

· Describe the main features of Hyperion Planning

· Describe the product architecture of Hyperion Planning

· Access Planning through Workspace

CREATING A PLANNING APPLICATION

· Set up data source

· Describe and use the Calendar

· Described and use Plan Types

MODELING IN PLANNING

· Describe dimensions

· Describe members and member properties

· Create scenario dimensions

· Create version dimensions

· Set up entity dimensions

· Set up account dimensions

· Describe dense and sparse dimensions

· Set up currencies and exchange rates

· Set up user defined dimensions and attribute dimensions.

· Data Loading

· Describe different dimension build alternatives

· Describe different data load alternatives

· Share Planning data within an application and outside an application

EPMA

· Describe EPM Architect

· Create dimension members in EPMA

FORMS DESIGNER

· Create and edit data forms and folders

· Manage user variables

· Create Custom Menus

· Create Smart Lists

PLANNING END USER FUNCTIONS

· Perform Planning End User features over the web

· Use End User features in Smart View

· Use work flow process management to copy data between application versions

CALCULATIONS, BUSINESS RULES, & CALCULATION MANAGER

· Describe Business Rules and capabilities

· Create and manage business rules

· Describe and use member formulas and calc scripts

· Use Calculation Manager

PLANNING SECURITY AND ADMINISTRATION

· Describe security in Planning

· Describe user provisioning in Shared Services

· Provision users and groups for Planning

· Generate provisioning reports

· Assign access rights in Dimension Editor

· Import access rights

· Create security filters

· Perform general application administration tasks

OTHER

· Describe financial reporting basics

· Described and use Workforce Planning

· Describe and use Capital Expense Planning

 

ORACLE HYPERION ESSBASE TRAINING IN CHENNAI

OVERVIEW OF ORACLE ESSBASE

· Describe multidimensional analysis

· Describe Oracle Essbase

SMART VIEW

· Describe Smart View

· Retrieve Data using Smart View

ESSBASE APPLICATION CREATION FUNDAMENTALS

· Perform manual outline creation

· Build dimensions from sources

· Perform initial data loads

• · Use calculations and aggregations
  • · Assign security

AGGREGATE STORAGE DATABASES

• • · Describe when to deploy aggregate storage, block storage, or a combined solution
  • · Convert block storage to aggregate storage
  • · Create, load, and pre-aggregate aggregate storage databases
  • · Employ database partitioning in combined block/aggregate storage solutions
  • · Write member formulas using MDX
  • · Perform management tasks for aggregate storage databases
  • · Partition block and aggregate storage databases
  • · Describe and implement aggregate storage design best practices
  • · Describe multiple hierarchies and the use of Shared Members

BLOCK STORAGE DATABASES

• • · Describe block storage calculations
  • · Describe the default database calculation order
  • · Describe data blocks

Describe how data blocks are indexed

· Interpret database statistics

· Describe when data blocks are created

· Describe the block storage database calculation process

· Tune and optimaize block storage databases

· Describe and implement block storage design best practices

• · Describe BSO load techniques

WORKING WITH CALUCULATION SCRIPTS

• • · Identify correct and incorrect calculation script syntax

Describe calculation script behavior for various ASO data structures

• · Describe calculation script behavior for various BSO data structures
  • · Design calculation scripts to meet specified requirements

ESSBASE ADMINISTRATION

• • · Describe the file Essbase.cfg and its settings.
  • · Describe the file Essbase.sec and its settings.
  • · Identify and interpret Essbase log files
  • · Manage Essbase security via Administration Services
  • · Manage Essbase security via Shared Services
  • · Back up and recover Block Storage Databases
  • · Automate database processes with MaxL
  • · Describe and use substitution variables and location aliases

ESSBASE STUDIO

• • · Describe functionality of Essbase studio
  • · Add and delete joins between tables
  • · Create drill through reports

ORACLE HYPERION FINANCIAL MANAGEMENT TRAINING IN CHENNAI

OVERVIEW OF HYPERION FINANCIAL MANAGEMENT

• • · Explain financial reporting concepts
  • · Describe HFM structure and design concepts a high level

CREATING APPLICATIONS — PROFILE AND METADATA — CLASSIC

• • · Create an application profile and application
  • · Create the application profile
  • · Manage, Load and Extract metadata
  • · Build a Chart of Accounts
  • · Describe and specify values for commonly used properties
  • · Describe and specify values for commonly used application settings
  • · Describe and implement dimensionality

EPM ARCHITECT

• • · Explain advantages and disadvantages of using EPMA versus “classic” HFM
  • · Describe EPMA components
  • · Define and maintain dimensions using EPMA
  • · Create and maintain application using EPMA
  • · Deploy applications
  • · Use data synchronization to move data between EPMA-based applications Data Loading and Analysis
  • · Load data into an application with native format files
  • · Load data into an application using alterna tive approaches
  • · Copy and clear data from HFM application

HFM RULES & CALCULATION MANAGER

• • · Create and maintain calculations in HFM
  • · Define and invoke subroutines
  • · Define and use variables
  • · Define and invoke functions

CREATING AND BUILDING LISTS

• • · Create member lists.
  • · Use member lists.
  • · Load and Extract member lists.

SHARED SERVICES

• • · Explain Security and Lifecycle Management
  • · Describe security structure (i.e. users/groups, roles, and classes) in HFM
  • · Provision users and groups
  • · Create and assign classes
  • · Manage users, groups and classes in a classic HFM application via extract/load
  • · Use Lifecycle Management Services to move artifacts from one application to another

HFM ADMINISTRATION

• • · Copy classic HFM applications
  • · Perform application management tasks using the HFM Administration menu
  • · Implement process control
  • · Perform HFM tuning and optimization

OTHER

• • · Use task lists
  • · Use data grids
  • · Use data entry forms
  • · Use Journals.

HFM END USER ADVANCE FUNCTIONS

• • · Implement intercompany reporting in HFM

FINANCIAL REPORTING STUDIO

• • · Explain and use the basic features of Financial Reporting Studio
  • · Explain and use relationship functions in report creation
  • · Use end user report functionality and features

SUPPORTING TOOLS OF FM

• • · Financial Data Quality Management
  • · Other – Extended Analytics

PLANNING OVERVIEW

• • · Describe the main features of Hyperion System 9 Planning
  • · Describe the product architecture of Hyperion System 9 Planning
  • · Describe the relationship between Hyperion System 9 Planning and Hyperion System 9 BI+ Analytic Services

NAVIGATING WORKSPACE

• • · Describe the user interface components
  • · Access Planning through Workspace
  • · Navigate the Planning Web client

CREATING DIMENSIONS OVERVIEW

• • · Identify required dimensions
  • · Identify user-defined dimensions
  • · Describe dense and sparse dimensions
  • · Describe data block creation
  • · Set up aggregation, data storage, and calculation options

MANAGING DIMENSIONS WITH BPM ARCHITECT

• • · Describe BPM Architect
  • · Navigate BPM Architect
  • · Manage Dimensions
  • · Create Dimension Members
  • · Edit Member Properties
  • · [Data Types (Dates, Text)]
  • · Create Property Associations
  • · Add and modify currencies

SETTING UP THE PERIOD, SCENARIO, AND VERSION DIMENSIONS

• • · Describe Planning time periods
  • · Customize time periods
  • · Create scenarios
  • · Create versions

SETTING UP THE ENTITY DIMENSION

• • · Add entity members to the Entity dimension
  • · Modify entity members in the Entity dimension
  • · Delete entity members in the Entity dimension

SETTING UP THE ACCOUNT DIMENSION

• • · Describe account types and consolidation order
  • · Create account hierarchies

CREATING USER-DEFINED ELEMENTS

• • · Create Alias Tables
  • · Create user-defined dimensions
  • · Create attributes and assign attribute values
  • · Describe member formulas
  • · Add member formulas in Analytic Administration Services
  • · Create Smart Lists

LOADING METADATA FROM A FILE

• • · Format metadata load files
  • · Map dimensions and dimension properties
  • · Create Profiles
  • · Load and extract Metadata

CREATING APPLICATION VIEWS

• • · Create Application Views
  • · Add dimensions to Application Views
  • · Configure application properties
  • · Remove members

DEPLOYING APPLICATIONS

• • · Validate application views
  • · Compare application views
  • · Deploy applications
  • · Activate and register Planning using the Configuration Utility
  • · Review Planning application in Analytic Administration Services (???)
  • · Test Application Deployments
  • · Redeploy Applications

SETTING UP EXCHANGE RATES

• • · Create exchange rate tables
  • · Enter exchange rate values
  • · Generate currency conversion calculation scripts

LOADING AND CALCULATING DATA OVERVIEW

• • · Describe the requirements for data load files
  • · Describe data load rules
  • · Describe how data is calculated within dimensions

LOADING DATA

• • · Load data using the staging area
  • · Create load rules for data files for Analytic Services
  • · Load data using Analytic Administration Services
  • · Modify performance settings

PROVISIONING USERS AND GROUPS

• • · Describe security in Planning
  • · Describe user provisioning in Shared Services
  • · Provision users and groups for Planning
  • · Generate provisioning reports

SETTING UP ACCESS RIGHTS TO PLANNING APPLICATIONS

• • · Assign access rights in Dimension Editor
  • · Import access rights
  • · Create security filters

CREATING DATA FORMS AND FOLDERS

• • · Create data forms and folders
  • · Print data form definition reports
  • · Assign access rights to data forms
  • · Associate Custom Menus to Data Forms
  • · Export and import data forms

CUSTOMIZING DATA FORMS

• • · Create Custom Menus
  • · Specify application default settings
  • · Manage user variables
  • · Set up user preferences

ENTERING DATA

• • · Enter and submit data in data forms
  • · Adjust and annotate plan data
  • · Calculate data in data forms
  • · Enter data by using Smart Lists
  • · Navigate data forms by using Custom Menus

ENTERING DATA IN SMART VIEW

• • · Describe Smart View
  • · Enter, adjust, calculate, and analyze data with Smart View
  • · Modify planning data offline

CREATING BUSINESS RULES

• • · Describe Business Rules and capabilities
  • · Navigate Administration Console to design business rules
  • · Create business rules
  • · Launch business rules from Planning
  • · Print business rules

BUILDING RUN-TIME PROMPTS FOR BUSINESS RULES

• • · Describe Runtime Prompts
  • · Create Runtime Prompts

ADDING FORMULAS TO BUSINESS RULES

• • · Identify the four formulas included with Business Rules
  • · Build formulas for business rules
  • · Manage Business Rules

PLANNING PROCESS MANAGEMENT

• • · Explain the planning process
  • · Describe planning units
  • · Manage the review cycle for planning units
  • · Copy data between versions
  • · Copy data
  • · Delete textual information

CREATING TASK LISTS

• • · Define task list capabilities
  • · Navigate task lists in Basic and Advanced modes
  • · Create task lists
  • · Assign Access to task lists
  • · Validate task lists

FINANCIAL REPORTING OVERVIEW

• • · Describe Financial Reporting
  • · Describe Data Sources
  • · Navigate Financial Reporting Studio
  • · Log on to Financial Reporting Studio
  • · Identify portions of the Financial Reporting Studio workspace
  • · Open, Preview, and print reports
  • · Identify report components
  • · Change the user POV

NAVIGATING REPORTS IN WORKSPACE

• • · Identify interface elements in Workspace
  • · Set preferences
  • · Set the user POV
  • · Limit user POV user selections
  • · Integrate reports into Microsoft Office applications

FINANCIAL REPORTING OVERVIEW

• • · Describe the components and general architecture of System 9
  • · Describe Financial Reporting functionality and architecture
  • · Identify data source dimensions and members
  • · Start the Analytic Services server

NAVIGATING REPORTS IN WORKSPACE

• • · Identify interface elements in Workspace
  • · Set preferences
  • · Preview and print reports
  • · Set the user Point of View (POV)
  • · Limit the user POV member selections
  • · Integrate reports into Microsoft Office applications

NAVIGATING REPORTS IN FINANCIAL REPORTING STUDIO

• • · Log on to Financial Reporting Studio
  • · Identify portions of the Financial Reporting Studio workspace
  • · Open, preview, and print reports
  • · Identify report components
  • · Change the user POV

CREATING BASIC REPORTS

• • · Create reports and grids
  • · Select members for rows and columns
  • · Set the POV
  • · Modify reports by adding rows and columns
  • · Save reports

APPLYING ADVANCED MEMBER SELECTIONS

• • · Select members by using lists
  • · Select members by using functions
  • · Select multiple members by using expressions
  • · Select members for the page axis
  • · Set data query optimization options

CUSTOMIZING GRIDS

• • · Select multiple database connections in a grid
  • · Attach documents to reports
  • · Display Planning supporting detail
  • · Create reports with expansions
  • · Create reports with related content

FORMATTING CELLS AND GRIDS

• • · Format cells within a grid
  • · Format grids
  • · Sort a range of rows or columns
  • · Suppress data in a grid
  • · Apply conditional formatting in a grid
  • · Specify the page setup

CREATING REPORT OBJECTS

• • · Create text boxes in a report
  • · Add images to a re port
  • · Save and link objects
  • · Insert saved objects into a report
  • · Add headers and footers to a report
  • · Create row and column templates

CREATING CHARTS

• • · Create bar, line, pie, and combo charts
  • · Format charts

ADDING TEXT FUNCTIONS

• • · Describe the purpose of text functions
  • · Add text functions to reports
  • · Describe common text functions

ADDING AUTO CALCULATIONS AND MATHEMATICAL FUNCTIONS

• • · Describe the purpose of auto calculations and mathematical functions
  • · Add auto calculations to data rows and columns
  • · Apply mathematical functions and properties to perform calculations
  • · Describe common mathematical functions

CREATING BOOKS

• • · Preview books in PDF and HTML modes
  • · Change the book POV
  • · Create books containing multiple reports
  • · Set member selections for reports in a book

CREATING BATCHES

• • · Create and schedule batches to automatically generate reports
  • · Schedule batch bursting options
  • · Retrieve exported batch output from the Scheduler Server

MANAGING ITEMS IN THE REPOSITORY

• · Create e-mail links
• · Create folders
• · Rename, move, and delete items in the repository
• · Import and export items
• · Manage database connections
• · Set permissions for repository items