Hyperion Essbase Online Training:

Hyperion Essbase 9.3.1&11.1

Introduction to Online Analytical Processing
Multidimensional view of information
Introduction to the Hyperion Essbase Product Family
Essbase Product family architecture
Setting Up Essbase Analytic Environment
Essbase Analytic Server Architecture
Essbase Administration Server Architecture
Managing an Essbase Administration Server
Using the Essbase Administration Console
Creating an Essbase Analytic application and database
Creating and editing the database outline
Verifying and saving the database outline
Building dimensions dynamically
Loading Data into the Essbase Analytic Database
Supported data sources
Performing free-form data load
Creating and editing a simple rules file
Performing data load using the rules file
Previewing the loaded data
Calculating the Essbase Analytic Database
Essbase Analytic Services scripting capabilities
Calculating with calc scripts
Executing the cal script
Retrieving Analytic Data
Essbase Spreadsheet Add-in overview
Navigating through the spreadsheet report
Modifying the spreadsheet report layout by selecting and pivoting retrieved data
Updating retrieved data in the Essbase Analytic database
Introducing Essbase Analytic Services storage options
Block storage option concepts
Aggregate storage option concepts
Automating analytic reports with Report Writer
Interacting with Essbase Analytic Services using MaxL
Understanding aggregations
Batch scripting and Automation
Extending Essbase Analytic Capabilities with Hyperion Analyzer
Hyperion Analyzer key features, system architecture, and components
Hyperion Analyzer Java client
Creating spreadsheet reports, composite reports, and custom reports
Overview of Hyperion System 9 Architecture

Hyperion Financial Management 9.3.1/11.1(H.F.M)

Introduction
Architecture
Hyperion Financial Management Dimensions
Managing Applications
Application Administration
Creating Application Profiles
Defining Calendars
Creating Applications
Windows Procedure
Web Procedure
Copying Hyperion Financial Management Applications
Monitoring Running Tasks
Managing Application Security
Creating Security Classes
Creating Application Security Files
Hyperion Financial Management User Roles
Loading Application Security
Managing Metadata
Defining Accounts
Defining Entity Members
Defining Scenario Members
Defining Application Settings
Defining Consolidation Methods
Setting Up Intercompany Partners
Creating a Data Grid
Adding Line Item Detail
Creating Member List Files
Journal Entries in Accounting
Examples of Journal Entries
Calculating Accounting Balances
Balance Sheet and Income Statement
Adjusting Journal Entries
Managing Journals
Postings from multiple Journals are cumulative
Journal Review Process
Managing Data Forms
Defining Reports
Creating a Journal Report
Managing Rules
Calculation Commands
Hyperion Financial Management Objects
Rule Functions
Managing Intercompany Transactions
Elimination Process
Plug accounts
Managing Intercompany Transaction Periods
Business process for the Intercompany Transaction Module
Posting Intercompany Transactions
Monitoring Intercompany Transactions
Consolidating Data
Hyperion Financial Management Business Process Overview
Consolidation Process
About Consolidation Percentages
Entering Consolidation Information Using Ownership Management
Running Consolidations
Translating Data in Data Grids
Entering Exchange Rates
Automating Tasks
Components of a Task flow
Creating a Task flow
Stage Definition – General Tab
Stage Definition - Processing Tab
Stage Definition-Starting Event
Budgeting and Forecasting
Financial Reporting
Architecture
Financial Reporting Components
Steps to Share the report
Steps to create batch and Schedule the reports
Smart View
Steps to establish a data source connection

Hyperion Planning 9.3.1&11.1

Hyperion Analytical Administration Services 9.3
Hyperion Analytical Services 9.3
Hyperion Planning 4.0.5
Hyperion Shared Services 9.3
Hyperion Business rules 9.3
Vignette Business Integration Studio 7.2
Hyperion reports 7.2

Content

Planning Features
Planning Architecture
Planning Installation Sequence
Connection between Planning and Essbase
Hyperion Planning required dimensions
Hyperion Planning user-defined dimensions
Create and Manage Applications
Creating an Application
Creating Calendar
Setting up currencies
Setting up Plantypes
Account types
Data Type and Exchange Rate Type
Storage Options
Account members and Plan Types
Creating Application with Setup Application Task
Creating Additional Applications
Creating databases
Refresh databases
Setting Up Security
Creating Security Filters
Assigning Access rights
Importing Access rights
Reporting on Access Assignments
Refresh Security
Hyperion Planning Desktop
Hyperion Planning web
Planning Thick Client vs Thin Client
Setting up Audit Trails
Usage of Audit Trails
Setting Up Alias Tables
Creating Alias Tables
Refresh Alias Tables
Loading Members and Data
Using Hyperion Application Link
Using Vignette Business Integration Studio
Using Flow Diagrams
Hyperion Planning Adapter
Creating an Adapter Process
Flat File Adapter
Importing Data
Managing Shared Services Models
Registering Applications
Assigning an Application to a Shared Services Project
Managing Models
Sharing Data
Creating Shared services Applications
Working with Models
Comparing Models
Managing Permissions to Models
Sync Operations
Data Forms
Creating Data Forms
Setting the Row and Column Layout
Adding Row Definitions
Selecting Attribute Values as Members
Selecting Substitution Variables as Members
Selecting User Variables as Members
Creating Asymmetric Rows and Columns
Enabling Users to Dynamically Add Rows
Defining the Page and POV
Setting a Data Form’s Display Options
Business Rules
Business Rules Roles
Business Rules from AAS
Business Rules from Hyperion Planning web
Business Rules from Hyperion Business rules web portal
Creating a Business Rule
Creating Global Variables
Inserting Functions with the Function Editor
Creating Local Variables
Launching a Business Rule
Selecting Business Rules form Hyperion Planning web:
Runtime Prompts
Previewing a Data Form
Managing User Variables
Different Ways of Launching Hyperion Business Rules
Managing the Budgeting Process
Planning Units
Setting Up E-mail for Workflow Notification
Printing Planning Unit Annotations
Overview of Managing Task Lists
Creating Task Lists
Copying Data

Know About Cognos Online Training Course.