Training Course:Hyperion Financial Management 3School/Trainer:QA Ltd.
Aberdeen, Birmingham, Bristol, Edinburgh, Exeter, Glasgow, Leeds, London, Manchester, Slough, United Kingdom
Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced
Course Description:
'' This course is designed to teach you the methodology to create rules for advanced business calculations in Financial Management applications. You learn how to design, maintain, and execute complex rules using VBScript and Financial Management Rules Editor. You learn how to increase database performance and write rules for dynamic accounts, create translation rules, and create consolidation rules. You also learn how to effectively troubleshoot rules files by writing log data to text files.
Prerequisites
Basic knowledge of VBscript and Financial Management Rules
Familiarity with Financial Management Application Administration
Hyperion Financial Management 9.3.1: Create & Manage Applications
Delegates will learn how to
Describe and apply variables in rules
Use custom Sub procedures, functions arrays, and loops in rules
Write rules for dynamic accounts
Retrieve data, write data, and test for No Data
Write rules for the custom and value dimensions
Work with data dimension hierarchies and allocate data
Create custom currency translation rules and custom consolidation and elimination rules
Identify and implement syntax used in rules
Course outline
Reviewing Rules Syntax
About Rules
Objects and Functions
Creating Rules Expressions
Adding Operators and Functions to Expressions
Managing Log Files
Creating Arrays and Loops
About Arrays and Loops
Creating Arrays Variables
Filling Arrays Using Member Lists
Creating Loops
Assigning Values with Arrays and Loops
Attributes in Loops
Processing Data Units with the Open data unit Function
Managing Data
Retrieving and Writing Data
Testing for No Data
Setting Accounts to No Input
Setting Parent Entities to Input
Rounding and Scaling Overview
Rounding and Scaling with HS Round
Working with the Calendar
Working with the Calendar
Managing Movement Accounts and Data Views
Avoiding Circular Calculations in Hierarchies
Using Sub Allocate to Create Applications
Creating Currency Translation Rules
About Translating Data
Creating Custom Translation Rules
Creating Consolidation and Elimination Rules
About Default Consolidation and Elimination Calculations
Creating Consolidation Rules
Rule Types
Sub Procedures
Adding Comments
Inserting Line Continuations
Creating Conditional Statements
String Comparison Functions
Reducing Maintenance with Variables
About Visual Basic Variables
Creating Variables and Assigning Variables
Variables and Data Types
Variables and Constants
Creating Header Sections for Variables and Constants
Managing the Scope of Rules
Data Retrieval and Sub Cubes
Sub Cubes and Performance
Managing the Scope of Rules
Executing Rules with the Value Dimension
Creating Rules for Dynamic Accounts
Dynamic Account Types
Sub Dynamic Procedures
Creating Rules for Dynamic Accounts
Creating Custom Procedures
Creating Custom Sub Procedures
About Variables in Custom Sub Procedures
Calling Custom Sub Procedures
Creating Custom Functions
Calling Custom Functions
Troubleshooting with Logging Procedures ...''
Elements of this syllabus are subject to change.
Please go to the school's official website for training price and schedule:
http://www.qa.com/
Phone:0844 871 2080
School Address:
TEL: 0844 871 2080
E-mail us: info@qa.com
Jobs & Resumes: Aberdeen, Birmingham, Bristol, Edinburgh, Exeter, Glasgow, Leeds, London, Manchester, Slough
Houses & Roommates: Aberdeen, Birmingham, Bristol, Edinburgh, Exeter, Glasgow, Leeds, London, Manchester, Slough
Travel Agencies: Birmingham, Bristol, Edinburgh, Leeds, London, Manchester,
Search other schools for Hyperion Financial Management 3 training resources.
Other training courses offered by QA Ltd.:
Hyperion Essbase for System Administrators
Hyperion Essbase Analytics Bootcamp
Hyperion Financial Data Quality Management Administration
Hyperion Financial Management for Interactive Users
Hyperion Financial Management 1
Hyperion Financial Management 2
Hyperion Financial Management 4
Hyperion Financial Reporting for Financial Management
Hyperion Financial Reporting for Essbase and Planning
Hyperion Interactive Reporting: Design Advanced Reports
Hyperion Interactive Reporting: Design Reports and Dashboards
Hyperion Master Data Management Administration
Hyperion Planning for Interactive Users
Hyperion Planning Installation and Configuration
Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
Tips:
You do not need to register before you can use most of our services. You will get a code for each posting ever made on this website. It is the key for you to remove the posting anytime by yourself. |
|
|
