Audience :

  • System Administrators
  •  Application Developers
  •  Power Users

Objectives :

  • Introduction to HFM Rules
    • Lesson 1. Oracle Hyperion Financial Management
    • HFM Overview
    • HFM Task Flow
    • Enterprise Performance Management Overview
    • Oracle Hyperion EPM Workspace
    • Foundation Tier
    • Product Tier
    • Application Tier
    • Web Tier
    • Help Information
    • Summary
    • Lesson 2. HFM Dimensions
    • Dimensions Overview
    • Entity Dimension Hierarchy
    • Period Dimension Hierarchy
    • Account Dimension Hierarchies
    • Fixed Dimensions
    • Custom Dimensions (1-4)
    • Leading Practices
    • Define Dimension Hierarchies
    • Define Dimension Labels
    • Define Labels without Spaces
    • Define Labels Using Existing Labels
    • Define a Reasonable Number of Years
    • Avoid Using the Weeks or a 13th Month Field in the Period Dimension
    • Define View Labels Using Abbreviations
    • Summary
    • Lesson 3. HFM Default Calculations
    • Default Calculations Overview
    • Consolidation
    • Value Dimension
    • Value Adjustment Members
    • [None] Value Member
    • Value Dimension Consolidation Process
    • Translation Process
    • Account Dimension – FX Rates
    • Currencies
    • AppSettings
    • Intercompany Elimination and Consolidation Process
     
  • Course Outline
    • Intercompany Metadata Setup
    • Intercompany Metadata Setup – Entities
    • Intercompany Metadata Setup – Intercompany Accounts
    • The IsICP Account Flag
    • IsICP Account Flag to Y for account 20300
    • The Plug Account
    • Account 20300 – Plug Account 22200
    • Account Dimension – ICPTopMember
    • Intercompany Elimination and Consolidation
    • Summary
    • Lesson 4. HFM Rules
    • Rules Overview
    • Leading Practices
    • Consolidation Rules
    • Translation Process
    • Intercompany Elimination – Base Entities
    • Summary
  • Commonly-used Visual Basic Functions and Commands
    • Lesson 1. Functions and Commands
    • If…Then
    • For… Next
    • Case
    • ..End Sub
    • Call
    • Function…End Function
    • Sequence of Execution
    • Circular Account References, Clearing Mechanisms, and Data Explosion
    • Summary
  • Rules Functions and Methods
    • Lesson 1. Routines
    • System Defined Subroutines
    • Calculate()
    • Translate()
    • Allocate()
    • NoInput()
    • Consolidate()
    • Dynamic()
    • Input()
    • Eliminate()
    • Basic Rules – HS.EXP and General Syntax
    • Other Common Functions
    • CLEAR
     
  • Course Outline
    • VALUE.MEMBER
    • ENTITY.MEMBER
    • SCENARIO.MEMBER
    • VALUE.ISTRANSCUR
    • YEAR.MEMBER
    • PERIOD.MEMBER
    • ENTITY.ISBASE
    • GETCELL
    • UCASE
    • Rules Considerations and Leading Practices
    • Summary
  • Extract, Edit, Test, and Deploy Rules
    • Lesson 1. Use the New Test Application
    • Extract Rules and Other Application Components
    • Summary
    • Lesson 2. Quick Rule Editing
    • Edit a Rules File
    • Summary
    • Lesson 3. Deploy and Test Rule Changes
    • Determine Fallback Plan
    • Summary
  • Member Lists, Variables, and Other Rules Dynamics
    • Lesson 1. Create Member List Files
    • Member Lists
    • Create Member List Files
    • EnumMemberLists
    • EnumMembersInList
    • Load and Extract Member Lists
    • Load member lists
    • Extract member lists
    • Summary
    • Lesson 2. Variables
    • Create Variables
    • Pass Variables to Subroutines
    • Summary
  • Build Rules
    • Lesson 1. Build Basic Rules
    • Basic Rules Overview
    • Beginning Balance Roll Forward
    • Net Income Transfer to Balance Sheet
    • Calculate the Balancing Account
     
  • Course Outline
  • Summary
  • Lesson 2. Translation and Dollar Overrides
  • Default Translation Methods
  • Application Metadata Settings
  • Application Design Considerations
  • Default Translation
  • Translation Rules
  • Application Design Consideration – Execution Order
  • Dollar Override Accounts – Concept
  • The GetCell Function
  • Dollar Override Example – No Flows
  • Dollar Override Example – Opening Balance
  • Dollar Override Example – Current Activity
  • Currency Translation Adjustment (CTA)
  • Summary
  • Lesson 3. Flows
  • Flows Overview
  • PP&E Flow Summary – Input Currency
  • Suggested Metadata Setup for PP&E Flows
  • PP&E Flows – PVA Translation Overview
  • Opening Balances
  • Additions, Disposals and Other Adjustments
  • Exchange Adjustments
  • PP&E Flows – Rules Description
  • Opening Balances
  • Additions, Disposals and Other Adjustments
  • Exchange Adjustments
  • Exchange Adjustment – Part One
  • Exchange Adjustment – Part Two
  • Opening Balances
  • Additions, Disposals and Other Adjustments
  • Exchange Adjustments
  • Opening Balances
  • Exchange Impact – Opening Balances
  • Additions, Disposals and Other Adjustments
  • Exchange Adjustments
  • Summary
  • Lesson 4. Advanced Forecasting
  • Case Study: Rolling Forecast
  • Work with Variables
  • Set Forecast Equal to Actual
  • The NoInput Subroutine
  • Forecast Rules – Even Spread
  • Forecast Rules – Seasonal Spread
     
  • Course Outline
    • Summary
    • Lesson 5. Ratios
    • Ratios Overview
    • Return on Assets %
    • Annualized Net Profit – Account 65001
    • Average (13-point) Total Assets – Account 65002
    • Return on Assets (ROA %) – Account 65000
    • Return on Assets %
    • Days Sales Outstanding (DSO)
    • A Simple DSO Example
    • DSO Rules Description
    • Logic for Days in Month Account
    • Logic for DSO Calculation
    • Days Sales Outstanding
    • Summary
  • Calculation Manager Demonstration
    • Lesson 1. Calculation Manager
    • Calculation Manager Overview
    • Calculation Manager Flowcharts
    • Calculation Manager Views
    • Business Rules Creation Overview
    • Edit a Business Rule
    • Edit a Business Rule in Script Mode
    • Business RuleSets Creation Overview
    • Create a Business RuleSet
    • Design a Business RuleSet
    • Add a Business Rule to a RuleSet
    • Summary
  • Case Study: Create Cash Flow
    • Cash Flow Overview
    • Cash Flow Accounts
    • Cash Flow Analysis – Custom 4
    • Basic DFB Function
    • Advanced DFB Function
    • Account by Account Cash Flow Guidelines
    • Local Currency Cash Flow
    • Write DFB function
    • Write Cash Flow Rules Using DFB Function
    • Verify Local Currency Results
    • Translated Cash Flow
    • Currency Considerations
    • Translated Currency Cash Flow