You are previewing Oracle Hyperion Financial Management Tips & Techniques.
O'Reilly logo
Oracle Hyperion Financial Management Tips & Techniques

Book Description

Master Oracle Hyperion Financial Management

Consolidate financial data and maintain a scalable compliance framework with expert instruction from an Oracle ACE. Oracle Hyperion Financial Management Tips & Techniques provides advanced, time-saving procedures not documented in user manuals or help files. Find out how to configure Oracle Hyperion Financial Management, import and reconcile data, deliver dynamic business reports, and automate administrative tasks. Stragegies for supporting, testing, and tuning your application are also covered in this comprehensive Oracle Press guide.

• Establish objectives and develop an effective rollout plan

• Set up and customize Oracle Hyperion Financial Management

• Create rules using VBScript and the Calculation Manager feature of Oracle Hyperion Foundation Services

• Load, test, and reconcile your data with Oracle Data Integrator and Oracle Hyperion Financial Data Quality Management

• Design, update, and distribute Web-based business reports

• Integrate content from Microsoft Excel, Word, and PowerPoint using SmartView

• Work with the Lifecycle Management feature of Oracle Hyperion Foundation Services

• Identify and resolve performance, design, and capacity problems

Table of Contents

  1. Title Page
  2. Copyright Page
  3. Dedication
  4. About the Author
  5. Contents at a Glance
  6. Contents
  7. Acknowledgments
  8. Introduction
  9. 1 Designing Your Oracle HFM Application
    1. Enterprise Performance Management
    2. The Oracle EPM Suite Overview
    3. Define the Scope
    4. EPM and EPI
    5. Identify Your Team
      1. The Internal Team
      2. Your Implementation Partner
      3. Support from the Infrastructure Group
    6. Create a Project Plan
    7. Dimension Overview
      1. Naming Convention
      2. Application Profile
      3. Currencies
      4. Application Settings
      5. Scenario
      6. Entity
      7. Value
      8. Account
      9. Intercompany Partner (ICP)
      10. Custom Dimensions
    8. Consolidation Methods
    9. Best Practices for Design Dimensionality
    10. The Subcube and Its Impact on Your Design
    11. Migrating Your Application from Hyperion Enterprise
    12. Conclusion
  10. 2 Tips for Building Your Oracle HFM Application
    1. Workspace
    2. EPMA and the Win32 Application
    3. Grids
    4. Web Data Entry Forms
    5. Process Management
    6. Phased Submissions
    7. Intercompany Eliminations
    8. Intercompany Transaction Module
    9. Line Item Detail
      1. Organization by Period and Structures
    10. Ownership Module
    11. Equity Pickup Module
    12. Database Management
    13. Security
      1. Oracle HFM Security
      2. Oracle FDM Security
    14. Conclusion
  11. 3 Rules and Calculations
    1. Overview
    2. VBScript for Oracle HFM
      1. What Is VBScript?
      2. Formatting
      3. Variables and Constants
      4. Strings
      5. Arrays
      6. Sub Procedures
      7. Function Procedures
      8. How to Call a Procedure
      9. Conditionals
      10. Looping Statements
    3. Sub Procedures
      1. Calculation
      2. Translation
      3. Consolidation
      4. Allocation
      5. Input
      6. NoInput
      7. Dynamic
      8. Transactions
      9. Equity Pickup
    4. The Value Dimension
    5. Understanding the Subcube
    6. Writing a Rule
      1. HS.Exp Function
      2. GetCell Functions
    7. Scope of Rules
    8. Consolidation Rules
      1. Methods
      2. Organization by Period and Structures
      3. HS.Con
      4. OpenDataUnit Functionality
      5. GetNumItems
      6. GetItem
      7. Put It Together
      8. Elimination
    9. Error Handling
    10. Complex Rules Issues
      1. Invest in Sub
      2. Good Ideas
      3. Bad Ideas
    11. Writing Rules in Calculation Manager
    12. Rules Migration in Oracle HFM 11.1.1.3
    13. Conclusion
  12. 4 Reporting
    1. Overview
    2. Financial Reports
      1. Rounding
      2. Report Performance Basics
      3. Financial Report Design
      4. Best Practices for Reports
      5. Best Practices for Cell Text, Documents in Reports, and Commentary
      6. Books, Batches, and Bursting
      7. Charts and Graphs
    3. Web Analysis
      1. Best Practices for Web Analysis
    4. Smart View
      1. Best Practices for Smart View
      2. Connection Manager
      3. Linked Views and Dynamic Data Points
      4. Smart Slice
    5. Related Content
    6. Line Item Detail
    7. Annotations
    8. IFRS and Multi-GAAP Reporting
    9. Financial Close Manager
    10. Disclosure Management
    11. Conclusion
  13. 5 Data Integration and Testing
    1. The Right Tool for the Right Job
    2. Data Flow
    3. Oracle Hyperion Financial Data Quality Management
    4. Oracle Data Integrator
    5. ERPi
    6. Drillthrough vs. Drillback
    7. Converting HAL to FDM or ODI
    8. Supplemental Data
    9. Journals
    10. Data Loading Validations
    11. Data Relationship Management
    12. Validating Your Data
      1. Historical Data
      2. Ongoing Account Reconciliation
      3. Data Validations
    13. Extended Analytics
      1. Moving Journals and Elimination Data
    14. Conclusion
  14. 6 Supporting Your Application
    1. Planning to Support Your Application
      1. IT Support
      2. Admin/Functional Support
    2. Change Control Processes
    3. Oracle HFM System Logs
      1. HSV Event Log
      2. HFM Error Log
      3. Windows Event Log
      4. Audit and Error Log Tables
    4. Oracle HFM Errors and Common Causes
      1. Windows Interface Errors
      2. HSV Event Errors and Codes
    5. Oracle FDM Errors and Common Causes
      1. Testing FDM Integration
    6. Relational Database Structure
      1. Data Table Overview
      2. Metadata Tables
      3. Application Security Tables
      4. Intercompany Transaction Objects
      5. System Table Overview
    7. Invalid Records
    8. Starting Services
    9. Life Cycle Management
    10. Task Automation
    11. Other Information Sources
    12. Upgrading and Patching Your Application
    13. Conclusion
  15. 7 Tuning Your Application
    1. Understanding Key Performance Drivers
      1. Using a Reference Application
    2. Identifying and Resolving Problems
      1. Server Capacity
    3. Memory Requirements
      1. Memory and 64-bit Software
    4. Maintaining Your Registry
      1. Network Performance and Capacity
      2. Platform and Third-Party Software
      3. Oracle HFM Application Design
      4. Identifying Design Issues
      5. Identifying Rule Issues
      6. Business Process
    5. Diagnosing Performance Problems Using Monitoring Tools
    6. Conclusion
  16. 8 Case Studies
    1. An Electronics Group (AEG)
      1. Company Profile
      2. Business Situation
      3. The Team
      4. Accounting Challenges
      5. Infrastructure Challenges
      6. Solution
      7. Benefits
      8. Products and Services Used
    2. Henri and the Bean’s Toy Emporium
      1. Company Profile
      2. Business Situation
      3. Technical Situation
      4. The Team
      5. Accounting Challenges
      6. Infrastructure Challenges
      7. Solution
      8. Benefits
      9. Products and Services Used
    3. Putty’s Pet Food
      1. Company Profile
      2. Business Situation
      3. Technical Situation
      4. The Team
      5. Accounting Challenges
      6. Infrastructure Challenges
      7. Solution
      8. Benefits
      9. Products and Services Used
    4. Fictus Corp
      1. Company Profile
      2. Business Situation
      3. Technical Situation
      4. The Team
      5. Accounting Challenges
      6. Infrastructure Challenges
      7. Solution
      8. Benefits
      9. Products and Services Used
    5. Conclusion
  17. A Oracle HFM Errors and Event Codes
  18. B Examples of Common Oracle HFM Rules
    1. Formatting
    2. Variables
    3. Calculate Rules
      1. Out of Balance
      2. CTA and Currency Translation
      3. Retained Earnings
      4. Validations
      5. Cash Flow
      6. Roll Forwards and Movement Accounts
      7. Roll Forward
      8. Copy Scenarios
      9. Impact Scenarios
      10. HS.ImpactStatus Functionality
    4. NoInput and Input Rules
    5. Dynamic Rules
    6. Translation Rules
      1. Translation Best Practices
      2. FX Calculations
      3. Overrides
    7. Allocation Rules
    8. Consolidation Rules
    9. Conclusion
  19. Index