Audience :

  • System administrators
  • Power users
  • Application developers

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-xx)
    • 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
    • Account Dimension – ICPTopMember
    • IsICP Account Flag to Y for account 22100 (Intercompany Payables)
    • The Plug Account
    • Account 22100 – Plug Account 22200
    • 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
    • Create a Subroutine or Function in Calc Manager
    • Sequence of Execution
    • Circular Account References, Clearing Mechanisms, and Data Explosion
    • Summary
  • Rules Functions and Methods
    • Lesson 1. Rulesets
    • System Defined Rulesets
    • Calculate()
    • Translate()
    • Allocate()
    • NoInput()
    • Consolidate()
    • Dynamic()
    • Input()
    • 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. Create Backups and Fallback Plans
    • Backups and Fallback Plans
    • Summary
    • Lesson 2. Quick Rule Editing
    • Edit a Rule
    • Summary
    • Lesson 3. Deploy and Test Rule Changes
    • Summary
    • Lesson 4. Compare Scripts
    • 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
    • Leading Practices
    • Summary
    • Lesson 2. Variables
    • Create Variables
    • Pass Variables to Subroutines
    • Summary
  • Build Rules
    • Lesson 1. Build Basic Rules
    • Basic Rules Overview
    • Impact Status
   
  • Course Outline
  • Beginning Balance Roll Forward
  • Net Income Transfer to Balance Sheet
  • Calculate the Balance Account
  • Copy Actuals to Actual Budget
  • 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
  • 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
  • Summary
  • Lesson 5. Ratios and More Complex Calculations
  • Ratios Overview
   
  • Course Outline
  • Return on Assets %
  • Annualized Net Profit – Account 65001
  • Average (13-point) Total Assets – Account 65002
  • Return on Assets (ROA %) – Account 65000
  • Days Sales Outstanding (DSO)
  • A Simple DSO Example
  • DSO Rules Description
  • Logic for Days in Month Account
  • Logic for DSO Calculation
  • Summary