Hyperion

Home  >>  Courses  >>  Hyperion

Hyperion Online Training

  Hyperion Analytic Solutions

  Hyperion Architecture

  Hyperion Essbase Architecture

  Hyperion Essbase Analytical Architecture

  Hyperion Essbase Administration Server Architecture

  Configuring Essbase Serve

  Configuring Essbase Administration Console

  Creating Essbase Analytic application and database

  Essbase components

  • Database Outline
  • calc script
  • Rule File
  • Report Script.

  Dimensions

  •   Standard Dimensions
  •   Attribute Dimensions
  •   Dense & Sparse Dimensions
  •   Dimension Properties
  •   Dimensions Type Properties
  •   Storage Properties

  Memmbers

  Member Properties

  •   Consolidation Properties
  •   Storage Propertiesv

Time balance properties

Variance Expenses

Skip Options

Dynamic Time Series (DTS members)

Building Outline

  • UsingManually
  • Using rule file with dynamic dimension build methods

User Defined Attributes (UDA’S)

  • Building manually, dynamic dimension build methods using rule file
  • Shared members
  • Building manually, dynamic dimension build methods using rule file

Two-pass

Building Dimensions using Rule file with dynamic Dimension Build Methods

  • Generation Reference
  • Level Reference
  • Parent/Child Reference

Loading Data into Outline With Rule (with realtime Scenarios)

Loading Data into Outline Without Rule file (freedom Data Loading)

Types of Free form data loading

  • Loading data from excel
  • Loading data using import from export data file

Explanation Excel Add-in recover

Building Reports with Excel Add-in

Creating Formulas with real time scenarios

Creating Calc Script (simple to Complex real Examples)

Building Reports with Report scripts

ESSCMD & Maxl

Interactive.

Batch process

Differences between BSO &  ASO

Outline back & Recovery

Data Backup & Recovery

Creating Users / Groups

Creating Filters

Optimization Techniques

Outline Optimization

  • Data load Optimization
  • Calc Script Optimization
  • Database optimization using Attribute dimensions
  • Database optimization using Data settings.

Hyperion Financial Reporting course content

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

Navigating Reports in Workspace

  • Workspace Overview
  • Setting Preferences
  • Browsing the Repository
  • Searching for Items
  • Previewing and Printing Reports

Interacting with Reports in Workspace

  • Annotations Overview
  • Creating, Viewing, and Replying to Annotations
  • Integrating Reports into Microsoft Office Applications

Navigating Reports in Reporting Studio

  • Reporting Studio Overview
  • Opening Reports
  • Previewing and Printing Reports

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

Applying Advanced Member Selections

  • Lists Overview
  • Selecting Members by Using Lists
  • Selecting Members by Using Functions
  • Selecting Members for the Page Axis

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

Creating Report Objects

  • Adding Text Boxes and Images
  • Saving Report Objects
  • Inserting Saved Report Objects
  • Designing Headers and Footers
  • Designing Row and Column Templates

Adding Text Functions

  • Text Functions Overview
  • Inserting Text Functions
  • Common Text Functions

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

Hyperion Financial Management course

Introduction to Financial Management

  • About Enterprise Performance Management

HFM Basics

  • Dimensions
  • Define Application Profile
  • Create application

Loading Metadata from a File

  • About Metadata Load Files
  • Loading Metadata
  • Manage Metadata
  • Prepare own Metadata

Configuring Accounts and Custom Dimensions

  • About Accounts and Custom Dimensions
  • Setting Up Account Types and Hierarchies
  • Setting Up Accounts and Custom Dimensions
  • Intercompany Account and Other Account Properties

Setting Up Entities, Calendars, and Scenarios

  • Setting up Entities
  • Setting Up Calendars
  • Setting Up Scenarios

Loading Data

  • Loading Data Files
  • Extracting Data
  • Copying and Removing Data

Creating Tasklist and Data Forms

  • About Data Forms
  • Accessing the Form Builder
  • Defining the Point of View
  • Defining Columns and Rows
  • Setting Row and Column Options
  • Exporting Data to Spreadsheets

Entering Data Using Data Grids

  • About Data Grids and Accessing Data Grids
  • Changing the Grid Layout and Display
  • Selecting Members for Dimensions
  • Selecting Members
  • Saving Grid Settings
  • Entering Data and Filling Multiple Cells
  • Spreading and Calculating Data
  • Adding Cell Text and Line Item Detail

Creating Member Lists in Financial Management

  • About Member Lists
  • System and User Defined Member Lists
  • Creating Member Lists
  • Identifying Member Lists in a File
  • Creating Static Member Lists
  • Creating Dynamic Member Lists for the Entity Dimension and Other Dimensions
  • Loading and Extracting Member Lists

Entering Intercompany Data

  • About Intercompany Transactions
  • Intercompany Account Balances
  • Elimination Process
  • Plug Accounts
  • Intercompany Eliminations and the Value Dimension
  • Setting Up Entities and Accounts for Intercompany Data
  • Creating and Running Intercompany Matching Reports

Adjusting Data with Journals

  • About Journals and Journal Benefits and Adjusting Data
  • Journals Review Process and the Value Dimension
  • Multiple Journal Postings, Accessing Journals and Opening Periods for Journal Entry
  • Creating Journal Templates and Journal Balance Types
  • Creating Journals and Entering Journal Data
  • Creating, Previewing, Running and Viewing Adjustments with the Entity Details Report
  • Setting Journal Report Properties and Selecting Columns and Filters
  • Saving Journal Reports Locally and Remotely

Running Consolidations and process management

  • Consolidation Process and Percentages
  • Entering Consolidation Information Using Ownership Management
  • Running Consolidations
  • Checking Consolidation Status
  • Data Translation
  • Entering Exchange Rates

Analyzing Data Using Smart View

  • About Smart View
  • Smart View Installation and Components
  • Connecting to a Data Source
  • Entering Data with Web Data Forms
  • Functions in Smart View

Rule

  • About Rules and Rules Syntax
  • Rule Types and Rules Files
  • Objects and Functions in Rules
  • Assigning Values to Accounts

Request Live Demo Invitation

Get notified on our Free Interactive Online Demo Session.

Please wait...

Check Reviews
Go to Contact Us

error: Content is protected !!