Hyperion Financial Management 9.3: Create Rules - Student ...

1 Hyperion Financial Management : Create RulesStudent GuideD52372GC10 Edition 2007D53166 Copyright 2007, Oracle. All rights document contains proprietary information and is protected by copyright and other intellectual property laws. You may copy and print this document solely for your own use in an Oracle training course. The document may not be modified or altered in any way. Except where your use constitutes "fair use" under copyright law, you may not use, share, download, upload, copy, print, display, perform, reproduce, publish, license, post, transmit, or distribute this document in whole or in part without the express authorization of information contained in this document is subject to change without notice.

2 If you find any problems in the document, please report them in writing to: Oracle University, 500 Oracle Parkway, Redwood Shores, California 94065 USA. This document is not warranted to be Rights NoticeIf this documentation is delivered to the United States Government or anyone using the documentation on behalf of the United States Government, the following notice is applicable: GOVERNMENT RIGHTSThe Government s rights to use, modify, reproduce, release, perform, display, or disclose these training materials are restricted by the terms of the applicable Oracle license agreement and/or the applicable Government contract. Trademark NoticeOracle is a registered trademark of Oracle Corporation and/or its affiliates.

3 Other names may be trademarks of their respective MitsockWanda KingTechnical Contributors and ReviewersKeith GlideJennifer HoughDaniel TijerinaBrian MaguireEditorSusan MoxleyGraphic DesignerCarisa CannanPublisherJudy GaitanTable of Contents0 PrefaceCourse Objectives .. viiCourse Structure .. viiiCourse Materials .. viiiStudent Guide .. viiiActivity Guide .. viiiConventions ..ixModule 1: Financial Management Rules BasicsLesson 1: Reviewing Rules SyntaxAbout Rules .. 1-2 Objects and Functions .. 1-3 Creating Rules Expressions.. Function .. 1-8 Account Expressions .. 1-10 Destination Expressions ..1-11 Source Expressions ..1-11 Adding Operators and Functions to Expressions.. 1-12 Period and Year Keywords.

4 1-13 Placing Other Functions Within Exp .. 1-13 Rule Types .. 1-14 Sub Procedures .. 1-16 Adding Comments to Rules .. 1-18 Inserting Line Continuations .. 1-19 Creating Conditional Statements .. 1-21 Applying Statements .. 1-22 Making Decisions with Select Case Statements .. 1-24 Comparing Strings in Financial Management .. 1-25 UCase Function .. 1-26 LCase Function .. 1-26 Left Function .. 1-26 Right Function .. 1-27 Table of ContentsivHyperion Financial Management : Create RulesLesson 2: Reducing Maintenance with VariablesAbout VB Script Variables .. 2-2 Creating Variables and Assigning Values .. 2-3 Variables and Data Types .. 2-5 Variables and Constants .. 2-7 Creating Header Sections for Variables and Constants.

5 2-9 Point of View Variables .. 2-10 Top and None Members for Custom and ICP Dimensions .. 2-10 Global Accounts..2-11 Conditional Statement Triggers ..2-11 Lesson 3: Managing the Scope of RulesSubcubes and Data Retrieval .. 3-2 Financial Management Subcubes .. 3-3 Subcube Dimensions .. 3-4 Subcubes and Performance .. 3-5 Subcubes and Rules .. 3-7 The Left Side of .. 3-7 Page Dimensions and .. 3-9 Managing the Scope of Rules ..3-11 Omitting Dimensions .. 3-12 Specifying the Destination Dimensions .. 3-13 Specifying Source Dimensions .. 3-14 Mismatched Custom Dimensions (Example 1) .. 3-15 Mismatched Custom Dimensions (Example 2) .. 3-17 Executing Rules with the Value Dimension.

6 3-19 Sub Calculate and the Value Dimension .. 3-21 Working with Total Members .. 3-23 Lesson 4: Creating Rules for Dynamic AccountsDynamic Account Types .. 4-2 Sub Dynamic Procedures .. 4-3 Creating Rules for Dynamic Accounts .. 4-4 Functions Valid with .. 4-6 Table of ContentsHyperion Financial Management : Create RulesvModule 2: Creating Procedures, Loops, and ArraysLesson 5: Creating Custom ProceduresCreating Custom Sub Procedures .. 5-2 Calling Custom Sub Procedures .. 5-4 Creating Custom Function Procedures .. 5-6 Calling Custom Function Procedures .. 5-8 Troubleshooting with Logging Procedures.. 5-9 Writing to Log Files .. 5-10 Calling Write to File Procedures .. 5-13 Managing Log Files.

7 5-14 DeleteFile Function .. 5-15 FileExists Function.. 5-15 GetFile Function.. 5-15 MoveFile Function .. 5-16 Size Function .. 5-16 Lesson 6: Creating Arrays and LoopsArrays.. 6-2 Loops .. 6-3 Arrays and Loops in Rules .. 6-4 Creating Array Variables .. 6-6 Filling Arrays Using Member Lists .. 6-7 Creating Loops.. 6-8 For .. 6-10 Assigning Values with Arrays and Loops .. 6-12 Attributes in Loops .. 6-14 Loops and Data Units .. 6-15 Opening Data Units .. 6-16 Creating Loops With Data Units.. 6-18 Table of ContentsviHyperion Financial Management : Create RulesModule 3: Working With Data and HierarchiesLesson 7: Managing Financial Management DataRetrieving and Writing Data .. 7-2 Testing for No Data.

8 7-4 Setting Accounts to No Input .. 7-6 Setting Parent Entities to Input .. 7-8 Rounding and Scaling Overview .. 7-10 Rounding and Scaling with .. 7-12 Lesson 8: Working with Dimension HierarchiesWorking with the Calendar.. 8-2 Preventing Prior and Next from Crossing into Invalid Years .. 8-3 Populating Days in Period Accounts .. 8-5 Managing Calculation Status .. 8-6 Managing Movement Accounts and Data Views .. 8-8 Avoiding Circular Calculations in Hierarchies .. 8-10 Creating Allocations Using Sub Allocate .. 8-12 Running the Sub Allocate Procedure.. 8-13 Using the Alloc Function to Create Allocation Rules .. 8-15 Module 4: Creating Custom Translations and ConsolidationsLesson 9: Creating Currency Translation RulesAbout Translating Data.

9 9-2 Currency and Exchange Rate Settings .. 9-3 Translation Methods .. 9-5 Default Translation Process .. 9-7 Creating Custom Translation Rules .. 9-9 Translation Functions..9-11 Calculating Exchange Differences .. 9-13 Working with Currency Overrides .. 9-15 Lesson 10: Creating Consolidation and Elimination RulesDefault Consolidation Calculations .. 10-2 Creating Consolidation Rules .. 10-4 Table of ContentsHyperion Financial Management : Create RulesviiConsolidation Functions.. 10-5 Consolidation Procedure Example.. 10-9 Testing For Eliminations..10-11 Table of ContentsviiiHyperion Financial Management : Create Rules