[wpcol_1third id=”” class=”” style=””]

youtube

 

>>   Cognos

>>   Informatica

>>   Datastage

>>   Microstrategy

>>   AB-Initio

>>   Teradata

>>   OBIEE

>>   Hyperion

[/wpcol_1third] [wpcol_2third_end id=”” class=”” style=””]

 HYPERION-ESSBASE,FM,PLAN  

HYPERION – ESSBASE, FM, PLAN

Duration: 30 Hrs

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

[/wpcol_2third_end]

Leave a comment

Your email address will not be published. Required fields are marked *