About this course

Course code TPD71845GC20
Duration 4 Days

This course is based on Oracle Hyperion Financial Management 11.1.2.3. The class specifically covers creating rules and calculations in Hyperion Financial Management (rather than Hyperion Planning), and is designed to teach you how to create rules for advanced business calculations. The course is based on creating these rules and calculations within Calculation Manager. Expert Oracle University instructors will demonstrate how you can design, maintain, and execute complex rules by using Calculation Manager. Choose this course if you will use Calculation Manager.Learn How To:Create formulas, rules, rule sets and rules templates with Calculation Manager.Reduce database size and calculation time by properly using the custom and value dimensions in rules. Calculate percentages and ratios for dynamic accounts.Create loops by using member lists and data ranges.Create rules with proper data-handling techniques.Create allocation, currency translation, consolidation and elimination rules.Benefits to YouBy investing in this course, you'll develop the knowledge and skills necessary to increase your organization's database performance, write rules for dynamic accounts and create translation and consolidation rules. You'll also walk away from this course with a new ability to effectively troubleshoot rules using log files.Note: The Calculation Manager class is specifically for Calculation Manager with Hyperion Financial Management, not Calculation Manager for Hyperion Planning.Live Virtual Class FormatA Live Virtual Class (LVC) is exclusively for registered students; unregistered individuals may not view an LVC at any time. Registered students must view the class from the country listed in the registration form. Unauthorized recording, copying, or transmission of LVC content may not be made.

Delegates will learn how to

  • Calculate percentages and ratios for dynamic accounts
  • Create loops by using member lists and data ranges
  • Create rules with proper data-handling techniques
  • Create allocation, currency translation, consolidation, and elimination rules
  • Create formulas, rules, rule sets, and rules templates with Calculation Manager
  • Reduce database size and calculation time by proper use of the custom and Value dimensions in rules

Outline

Introduction to Calculation Manager

  • Financial Management Rules
  • Calculation Manager Overview
  • Viewing Rules
  • Viewing Flow Charts
  • Printing Rules

Creating Rules and Formulas

  • Creating Rules
  • Creating Formula Components
  • Member Expressions in Calculation Statements
  • Operators, Keywords, and Functions
  • Validating Rules

Managing Rules

  • Creating and Validating Rule Sets
  • Deploying Rules
  • Importing and Exporting Calculation Manager Objects
  • Creating Rules as VB Script Components
  • Converting Script Components to Graphical Rules
  • Importing Rules From RLE Files

Managing Templates

  • Templates Overview
  • System Templates
  • Adding Templates to Rules
  • Creating Custom-Defined Templates
  • Saving Rules and System Templates as Custom-Defined Templates

Reducing Maintenance with Variables

  • Execution and Replacement Variables
  • Creating Variables
  • Assigning Values to Variables in Grids
  • Passing Values to Variables
  • Standard Variables for the Point of View
  • Standard Variables for Custom and ICP Dimensions

Managing Rule Scope with Conditions

  • Adding Condition Rows to Grids
  • Adding Condition Components to Rules
  • Trigger Functions for Conditions
  • Managing Rule Execution for the Value Dimension

Managing the Custom and ICP Dimensions

  • Subcubes and Performance
  • Page Dimensions and Rules
  • Specifying Source Dimensions
  • Specifying Destination Dimensions

4 Days

Duration

This is a QA approved partner course

Delivery Method

Delivery method

Virtual learning

Recreates a classroom experience online, enabling full interactions with the learning professional leading the course.

Find dates and prices

Sorry, we don't have any public dates scheduled for this course, but it can be run as a closed event for your company.
Please contact us for details on alternative ways we can help you 0845 757 3888 or email us at info@qa.com.

Trusted, awarded and accredited

Fully accredited to ensure we provide the highest possible standards in learning

All third party trademark rights acknowledged.