HFM_STUDENYGUIDE

Full text

(1)These eKit materials are to be used ONLY by you for the express purpose SELF STUDY. SHARING THE FILE IS STRICTLY PROHIBITED.. Management 11.1.2: Create &. Manage Applications. Student Guide - Volume II. D63786GC30. Edition 3.0. November 2013. D84382. Oracle University and (Oracle Corporation) use only.. Oracle Hyperion Financial.

(2) Copyright © 2013, Oracle and/or its affiliates. All rights reserved.. Mark Mitsock. Disclaimer. Technical Contributors and Reviewers Ron Reiley Yuen Man Boronski. This 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 Oracle.. Graphic Editor Seema Bopaiah. The information contained in this document is subject to change without notice. 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 error-free.. Editors. Restricted Rights Notice. Malavika Jinka Aju Kumar Anwesha Ray. If 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:. Publishers Pavithran Adka Veena Narasimhan Michael Sebastian. U.S. GOVERNMENT RIGHTS The U.S. 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 U.S. Government contract. Trademark Notice Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.. Oracle University and (Oracle Corporation) use only.. These eKit materials are to be used ONLY by you for the express purpose SELF STUDY. SHARING THE FILE IS STRICTLY PROHIBITED.. Author.

(3) 1. Introduction Course Objectives 1-2 Course Agenda: Day 1 1-3 Course Agenda: Day 2 1-4 Course Agenda: Day 3 1-5 Course Agenda: Day 4 1-6 Course Agenda: Day 5 1-7 Lesson Objectives 1-8 Financial Management 1-9 Additional Financial Management Components 1-10 Product Integration 1-11 Financial Management Architecture 1-12 Client Tier 1-13 Middle Tier 1-14 Data Tier 1-15 External Services 1-16 Financial Management Business Process: Steps 1-17 Step 1: Entering Data 1-18 Step 2: Calculating Data 1-19 Step 3: Adjusting Data 1-20 Step 4: Translating and Consolidating Data 1-21 Step 5: Reviewing and Approving Data 1-22 Step 6: Running and Publishing Financial Reports 1-23 Activity Guide Business Scenario 1-24 Training Environment 1-26 Summary 1-27 Quiz 1-28 Lesson 1 Practice: Overview 1-31. 2. Navigating Financial Management Objectives 2-2 Financial Management Components 2-3 Workspace: Overview 2-4 Logging On to Workspace 2-5 Metadata 2-6. iii. Oracle University and (Oracle Corporation) use only.. These eKit materials are to be used ONLY by you for the express purpose SELF STUDY. SHARING THE FILE IS STRICTLY PROHIBITED.. Contents.

(4) 3. Managing Dimensions Objectives 3-2 Dimension Library 3-3 Applications 3-4 Shared Library 3-5 Creating Dimensions 3-6 Creating Associations Between Dimensions 3-8 Configuring Custom Dimensions 3-11 Setting Up Languages 3-13 Setting Up Enhanced Cell Text 3-15 Organizing Shared Library by Using Folders 3-16 Filtering Shared Library 3-17 Managing Dimensions in Classic Applications 3-18 Summary 3-20 Quiz 3-21 Practice 3: Overview 3-25. iv. Oracle University and (Oracle Corporation) use only.. These eKit materials are to be used ONLY by you for the express purpose SELF STUDY. SHARING THE FILE IS STRICTLY PROHIBITED.. Dimensions 2-7 Financial Management Data Dimensions 2-8 Dimension Hierarchies 2-10 Dimensions and Data 2-11 Value Dimension 2-12 Value Dimension: Example 2-13 Other Financial Management Dimensions 2-14 Navigating Financial Management 2-15 Opening Applications 2-16 Navigating Applications and Tasks 2-17 Consolidation Administration Module 2-19 Opening Documents 2-20 Setting the Point of View 2-23 Selecting Members 2-25 Selecting Members by Using Member Lists 2-26 Selecting Members from a Favorites Members List 2-28 Selecting Members by Typing a Member Name 2-29 POV Display Options 2-30 Summary 2-31 Quiz 2-32 Practice 2: Overview 2-35.

(5) Managing Dimension Members Objectives 4-2 Creating Dimension Members 4-3 Guidelines for Member Names 4-4 Modifying Member Properties 4-5 Common Consolidation Properties 4-7 System and Statistical Properties 4-9 Property Value Inheritance 4-10 Creating Alternate Hierarchies 4-12 Inserting Multiple Shared Members 4-13 Reordering and Moving Members 4-14 Deleting Members 4-15 Managing Orphan Members 4-16 Finding Members 4-17 Managing Members with Grid Editor 4-19 Modifying Members and Properties in Grid Editor 4-20 Modifying Property Values in Grid Editor 4-21 Creating and Deleting Members in Grid Editor 4-22 Summary 4-23 Quiz 4-24 Practice 4: Overview 4-28. 5. Loading Metadata Objectives 5-2 Metadata Load Files: Overview 5-3 Formatting Metadata Load Files for Performance Management Architect 5-4 Setting Up Dimensions 5-5 Dimensions Section 5-6 Members Sections 5-7 Managing Languages 5-9 Hierarchy Sections 5-10 DimensionAssociations Section 5-12 Creating ADS Files with the Performance Management File Generator 5-13 Loading Metadata Process 5-14 Merge and Reorder Options 5-15 Creating Import Profiles 5-17 Defining Load Options 5-18 Mapping Dimensions 5-19 Mapping Properties 5-20 Running Import Profiles 5-21 Viewing Job Status 5-22. v. Oracle University and (Oracle Corporation) use only.. These eKit materials are to be used ONLY by you for the express purpose SELF STUDY. SHARING THE FILE IS STRICTLY PROHIBITED.. 4.

(6) 6. Creating Applications Objectives 6-2 Applications and Performance Management Architect 6-3 Local and Shared Dimensions 6-4 Creating Applications by Using the Application Wizard 6-6 Defining Dimensions 6-7 Validating Applications 6-9 Adding Dimensions from the Shared Library 6-11 Changing Local Dimensions to Shared Dimensions 6-12 Shared Dimensions: Overriding Property Settings 6-13 Shared Dimensions: Activating Dimension Associations 6-14 Shared Dimensions: Excluding and Showing Members 6-15 Synchronizing Local with Shared Dimensions 6-16 Creating Classic Administration Applications 6-18 Summary 6-20 Quiz 6-21 Practice 6: Overview 6-25. 7. Configuring Application Settings Objectives 7-2 Configuring Financial Management Application Settings 7-3 Exchange Rate Settings 7-4 PVA Translation Method 7-5 Consolidation Settings 7-6 Org by Period 7-7 Intercompany Aggregations 7-8 Consolidation Rules 7-9 Phased Submission Settings 7-10 Validation Account Settings 7-11 Dimension Security Settings 7-12 Metadata Security Filtering 7-13 Node Security 7-14 Document Attachment Settings 7-15 FDM Application Name Settings 7-16 Summary 7-17. vi. Oracle University and (Oracle Corporation) use only.. These eKit materials are to be used ONLY by you for the express purpose SELF STUDY. SHARING THE FILE IS STRICTLY PROHIBITED.. Loading Metadata from Interface Tables 5-23 Loading Metadata from Oracle Hyperion Data Relationship Management 5-24 Summary 5-25 Quiz 5-26 Practice 5: Overview 5-30.

(7) 8. Configuring Accounts and Custom Dimensions Objectives 8-2 Accounts and Custom Dimensions: Overview 8-3 Setting Up Account Types and Hierarchies 8-4 Time Balance and Account Types 8-7 Dynamic Account Type 8-8 Group Label Account Type 8-9 Setting Up Accounts and Custom Dimensions 8-10 Assigning Custom Members to Accounts 8-12 Balance Sheet Accounts and Custom Dimensions 8-14 Custom Dimensions and Account Types 8-15 Setting Up Custom Members for Balance Sheet Movement 8-16 Auditing Data 8-18 Intercompany Account Properties 8-20 Other Account Properties 8-22 Summary 8-24 Quiz 8-25 Practice 8: Overview 8-29. 9. Setting Up Entities, Calendars, and Scenarios Objectives 9-2 Setting Up Entities 9-3 Requirements for Entities 9-4 Entities and Journals 9-5 Entities and Intercompany Partners 9-6 Entities and the ICP Dimension 9-7 Adding Currencies 9-8 Setting Up Calendars 9-10 Setting Up Scenarios 9-12 Frequency and View 9-13 View and Missing Data 9-14 Scenarios and Process Management 9-15 Summary 9-17 Quiz 9-18 Practice 9: Overview 9-22. vii. Oracle University and (Oracle Corporation) use only.. These eKit materials are to be used ONLY by you for the express purpose SELF STUDY. SHARING THE FILE IS STRICTLY PROHIBITED.. Quiz 7-18 Practice 7: Overview 7-22.

(8) 11 Loading and Extracting Data Objectives 11-2 Data Load and Extract Methods 11-3 Data Load Text Files 11-5 POV Dimension Section 11-6 Data Section 11-7 Descriptions Section 11-8 Column Order 11-9 Line-Item Detail Section 11-10 Submission Phase Section 11-11 Financial Management Data Storage and Retrieval 11-12 Subcube Dimensions and Performance 11-13 Guidelines for Managing Performance 11-15 Loading Data from Files 11-17 Merge Option: Overwriting Application Data with Load File Data 11-19 Replace Option: Replacing Data with Load File Data 11-20 Accumulate Option: Accumulating Application Data with Load File Data 11-21 Accumulate Within File Option: Loading Totals into Applications 11-22 Extracting Data 11-24 Copying Data 11-27 Removing Data 11-29 Summary 11-30 Quiz 11-31 Practice 11: Overview 11-35. viii. Oracle University and (Oracle Corporation) use only.. These eKit materials are to be used ONLY by you for the express purpose SELF STUDY. SHARING THE FILE IS STRICTLY PROHIBITED.. 10 Deploying Applications Objectives 10-2 Application Deployment Process 10-3 Validating Applications 10-4 Comparing Applications 10-5 Duplicating Applications 10-7 Deploying Applications 10-9 Viewing Job Status 10-11 Disabling Application Modules 10-12 Summary 10-13 Quiz 10-14 Practice 10: Overview 10-17.

(9) 13 Creating, Loading, and Extracting Member Lists Objectives 13-2 Member Lists: Overview 13-3 System-Defined Member Lists 13-4 User-Defined Member Lists 13-5 Creating Member Lists 13-6 Identifying Member Lists in a File 13-8 Creating Static Member Lists 13-10 Creating Dynamic Member Lists for the Entity Dimension 13-13 Creating Dynamic Member Lists for Other Dimensions 13-14 About Dynamic POV Member Lists 13-15 Creating Dynamic POV Member Lists 13-16 Dynamic POV Member List Example 13-17 Using Dynamic POV Member Lists 13-18 Loading Member Lists 13-19. ix. Oracle University and (Oracle Corporation) use only.. These eKit materials are to be used ONLY by you for the express purpose SELF STUDY. SHARING THE FILE IS STRICTLY PROHIBITED.. 12 Entering Data by Using Data Grids Objectives 12-2 Data Grids: Overview 12-3 Creating and Managing Documents 12-4 Creating Data Grids 12-6 Setting Up Grid Layout 12-7 Member Selection for Data Grids 12-8 Data Grid Display Options 12-10 Data Grid POV Options 12-11 Saving Data Grids 12-12 Entering Data 12-13 Spreading Data 12-15 Calculating Data 12-16 Calculation Options 12-17 Adding Cell Text and Document Attachments 12-18 Adding Line-Item Detail 12-20 Viewing Member Properties 12-21 Opening Data Grids in Smart View 12-22 Retrieving Data from FDM 12-23 Summary 12-24 Quiz 12-25 Practice 12: Overview 12-29.

(10) 14 Managing Rules by Using Calculation Manager Objectives 14-2 Financial Management Rules 14-3 Calculation Manager Overview 14-4 Calculation Manager and VB Script 14-5 Rule Types and Rule Sets 14-6 Rules 14-8 Formula Components 14-10 Creating Rules 14-12 Editing Rules in Script View 14-14 Creating Rule Sets 14-15 Validating Rules 14-17 Deploying Rules 14-18 Importing and Exporting Calculation Manager Objects 14-20 Importing Script-Based Rules Files 14-22 Summary 14-25 Quiz 14-26 Practice 14: Overview 14-30 15 Provisioning Users and Groups Objectives 15-2 Levels of Security 15-3 User Authentication 15-4 Task Security 15-5 Artifact Security 15-6 Data Security 15-7 Security Roles: Overview 15-8 Security Roles: Categories 15-10 Assigning Security Roles 15-11 Summary 15-13 Quiz 15-14 Practice 15: Overview 15-17. x. Oracle University and (Oracle Corporation) use only.. These eKit materials are to be used ONLY by you for the express purpose SELF STUDY. SHARING THE FILE IS STRICTLY PROHIBITED.. Extracting Member Lists 13-20 Summary 13-21 Quiz 13-22 Practice 13: Overview 13-26.

(11) 17 Creating Data Forms Objectives 17-2 Data Forms: Overview 17-3 Data Forms: Context Menu 17-5 Calculating in Data Forms 17-6 Creating Data Forms 17-7 Defining Columns and Rows 17-8 Setting Column and Row Options 17-10 Formatting Columns and Rows 17-12 Setting Up Relative Time Periods 17-14 Adding Custom Calculations 17-16 Setting Up Text Rows and Columns 17-18 Defining the Point of View 17-19 Setting Data Form Display Options 17-21 Setting Heading Defaults 17-22 Adding On Demand Rules 17-23 Viewing Scripts 17-24 Summary 17-25 Quiz 17-26 Practice 17: Overview 17-30. xi. Oracle University and (Oracle Corporation) use only.. These eKit materials are to be used ONLY by you for the express purpose SELF STUDY. SHARING THE FILE IS STRICTLY PROHIBITED.. 16 Assigning Access to Data and Documents Objectives 16-2 Application Settings and Security 16-3 Data Access Levels 16-5 Access to Data Cells 16-6 Document Access 16-7 Security Classes 16-8 Assigning Access to Security Classes 16-9 Running Security Reports 16-11 Configuring Security Auditing 16-13 Running Audit Reports 16-15 Loading Security Information from Text Files 16-17 Security Files 16-18 Loading Security Files 16-20 Extracting Security 16-22 Summary 16-23 Quiz 16-24 Practice 16: Overview 16-28.

(12) 19 Entering Intercompany Data Objectives 19-2 Intercompany Transactions: Overview 19-3 Intercompany Account Balances 19-4 Elimination Process 19-5 Plug Accounts 19-6 Intercompany Eliminations and the Value Dimension 19-7 Setting Up Entities for Intercompany Data 19-8 Setting Up Accounts for Intercompany Data 19-9 Creating Intercompany Matching Reports 19-10 Running Intercompany Matching Reports 19-12 Formatting Intercompany Reports with Oracle BI Publisher 19-13 Intercompany Transactions Module 19-14 Summary 19-15 Quiz 19-16 Practice 19: Overview 19-19 20 Adjusting Data by Using Journals Objectives 20-2 Journals: Overview 20-3 Viewing Automated Consolidation Journals 20-4 Journals and the Value Dimension 20-6 Multiple Journal Postings 20-7 Creating Parent and Contribution Adjustments 20-8 Opening Periods for Journal Entries 20-9 Journal Process 20-10 Creating Journal Templates 20-11 Setting the Point of View 20-13 Creating Journals 20-14. xii. Oracle University and (Oracle Corporation) use only.. These eKit materials are to be used ONLY by you for the express purpose SELF STUDY. SHARING THE FILE IS STRICTLY PROHIBITED.. 18 Creating and Managing Task Lists Objectives 18-2 Task Lists: Overview 18-3 Organizing Task Lists 18-4 Creating Task Lists 18-5 Adding Items to Task Lists 18-6 Adding Related Content 18-8 Adding Links 18-9 Summary 18-10 Quiz 18-11 Practice 18: Overview 18-15.

(13) 21 Translating Data Objectives 21-2 Data Translation: Overview 21-3 Default Translation Process 21-4 Data Grids and Data Forms for Exchange Rates 21-5 Translating Financial Data in Data Grids 21-7 Checking Translation Status 21-8 Summary 21-10 Quiz 21-11 Practice 21: Overview 21-15 22 Running Consolidations Objectives 22-2 Financial Management Business Process 22-3 Consolidation: Overview 22-4 Consolidation Process 22-5 Consolidation and the Value Dimension 22-6 Checking Calculation Status 22-7 Consolidation of Children by Percentages 22-9 Ownership Management 22-10 Assigning Ownership by Period 22-11 Calculating Ownership Using Shares 22-13 Managing Equity Pickup by Using the Equity Pickup Task 22-15 Consolidating Data 22-16 Setting Data Process Control Display Options 22-19. xiii. Oracle University and (Oracle Corporation) use only.. These eKit materials are to be used ONLY by you for the express purpose SELF STUDY. SHARING THE FILE IS STRICTLY PROHIBITED.. Creating Journals from Recurring Templates 20-16 Creating Auto-Reversing Journals 20-17 Submitting, Reviewing, Approving, and Posting Journals 20-18 Viewing Journal Adjustments 20-20 Viewing Adjusted Data in Data Grids 20-21 Viewing Adjustments in the Entity Details Report 20-22 Creating Journal Reports 20-23 Setting Up Columns and Filters 20-24 Running Journal Reports 20-26 Summary 20-27 Quiz 20-28 Practice 20: Overview 20-32.

(14) 23 Managing the Review Cycle by Using Process Management Objectives 23-2 Process Management: Overview 23-3 Process Units 23-4 Process States 23-5 Process Management Security Roles 23-6 Process Management Options 23-7 Phased Submissions 23-8 Process for Setting Up Phased Submissions 23-10 Configuring Application Settings 23-11 Setting Up Submission Groups 23-12 Assigning Submission Groups 23-14 Security Access for Process Units 23-15 Viewing Process Unit Status 23-16 Viewing Status for Multiple Submission Phases 23-17 Validating Process Units 23-18 Validation Accounts: Overview 23-20 Viewing Validation Account Details 23-21 Moving Process Units Through the Review Cycle 23-22 Selecting Review Levels 23-24 Email Alerts 23-25 Viewing Review History 23-27 Viewing Process Level in Data Grids 23-28 Managing Process Unit States in Data Grids 23-29 Locking and Unlocking Data 23-30 Summary 23-32 Quiz 23-33 Practice 23: Overview 23-37 24 Synchronizing Data and Migrating Applications Objectives 24-2 Data Synchronization: Overview 24-3 Creating Mapping Tables 24-4 Creating Data Synchronizations 24-6 Specifying Source and Destination 24-7 Mapping Source Dimensions to Destination Dimensions 24-8. xiv. Oracle University and (Oracle Corporation) use only.. These eKit materials are to be used ONLY by you for the express purpose SELF STUDY. SHARING THE FILE IS STRICTLY PROHIBITED.. Viewing Status for All Periods 22-20 Summary 22-21 Quiz 22-22 Practice 22: Overview 22-26.

(15) 25 Analyzing Data with Smart View Objectives 25-2 Smart View: Overview 25-3 Smart View Installation Components 25-4 Typical Business Process for Smart View 25-5 Components of Smart View 25-6 Accessing the Smart View Ribbon 25-7 Connecting to Data Sources 25-8 Specifying Smart View Options 25-10 Viewing and Analyzing Data by Using Ad Hoc Analysis 25-12 Drilling into Dimension Hierarchies 25-13 Pivoting Dimensions 25-14 Changing the Point of View 25-15 Changing Members 25-16 Displaying Cell Text 25-18 Creating Free-Form Worksheets 25-19 Adding Formulas and Preserving Formatting 25-21 Drilling Through to ERP Systems 25-23 Calculating, Translating, and Consolidating Data 25-25 Adjusting Data Values 25-26 Submitting Data 25-28 Opening Grids and Forms in Smart View 25-29 Summary 25-31 Quiz 25-32 Practice 25: Overview 25-36. xv. Oracle University and (Oracle Corporation) use only.. These eKit materials are to be used ONLY by you for the express purpose SELF STUDY. SHARING THE FILE IS STRICTLY PROHIBITED.. Adding Filters to Source Dimensions 24-9 Inserting Mapping Tables 24-11 Saving Data Synchronizations 24-12 Validating Data Synchronizations 24-13 Executing Data Synchronizations 24-14 Viewing Data Flows 24-15 Migrating Applications by Using Lifecycle Management 24-16 Exporting Financial Management Applications 24-17 Exporting Performance Management Architect Artifacts 24-18 Exporting Users, Groups, and Security Role Assignments 24-19 Importing Artifacts 24-20 Exporting and Importing Individual Artifacts 24-22 Summary 24-24 Quiz 24-25 Practice 24: Overview 24-29.

(16) Oracle University and (Oracle Corporation) use only.. These eKit materials are to be used ONLY by you for the express purpose SELF STUDY. SHARING THE FILE IS STRICTLY PROHIBITED..

(17) Copyright © 2013, Oracle and/or its affiliates. All rights reserved.. Schedule:. Timing. Topic. 30 minutes. Lecture. 20 minutes. Practice. 50 minutes. Total. Instructor Note Practices Tip: The “Creating a Dynamic Member List” exercise is challenging. Plan on helping individual students with syntax and troubleshooting after they load their member list file. You can use the finished file in the solutions folder to compare to the students file to try to spot mistakes. Dynamic POV Member Lists: The SalesUnitPrice data grid in both the Reports and Training applications uses a dynamic POV member list that changes based on the selected Entity if you want to demo it. When you change the entity to any of the Connecticut entities, it shows columns only for Software, for non-Connecticut entities it shows columns for both Hardware and Software.. Oracle University and (Oracle Corporation) use only.. These eKit materials are to be used ONLY by you for the express purpose SELF STUDY. SHARING THE FILE IS STRICTLY PROHIBITED.. Creating, Loading, and Extracting Member Lists.

(18) After completing this lesson, you should be able to: • Describe system-defined and user-defined member lists • Create static member lists • Create dynamic and dynamic POV member lists • Load and extract member lists. Copyright © 2013, Oracle and/or its affiliates. All rights reserved.. Oracle Hyperion Financial Management 11.1.2: Create & Manage Applications 13 - 2. Oracle University and (Oracle Corporation) use only.. These eKit materials are to be used ONLY by you for the express purpose SELF STUDY. SHARING THE FILE IS STRICTLY PROHIBITED.. Objectives.

(19) A member list is a subset of related members that belong to a single dimension. Account Dimension. Member List. Income Before Taxes Gross Margin Total Revenue. Total Revenue Sales Sales Interco. Total Costs. Total Costs Salaries Interest Expense Admin Expense. Admin Expense. Copyright © 2013, Oracle and/or its affiliates. All rights reserved.. Member lists can reduce the time that you spend browsing member hierarchies in data grids and data forms. For the example in the slide, if Total Revenue, Total Costs, and Administration Expenses are used frequently in the point of view for the Account dimension, your administrator can create a member list named Profit. You can then select members from the list, instead of browsing through the hierarchy of the Account dimension. You can also use member lists in rules and in Financial Reporting and Web Analysis. For example, you can write a rule that calculates all members of a member list, or run a report for all members of a member list. Two types of member lists are used in Financial Management: • System-defined member lists • User-defined member lists. Oracle Hyperion Financial Management 11.1.2: Create & Manage Applications 13 - 3. Oracle University and (Oracle Corporation) use only.. These eKit materials are to be used ONLY by you for the express purpose SELF STUDY. SHARING THE FILE IS STRICTLY PROHIBITED.. Member Lists: Overview.

(20) Income Before Taxes. Children of parent member list. Gross Margin Total Revenue. Base member list Sales. Sales. Sales. Sales Interco. Sales Interco. Sales Interco Salaries. Total Costs Interest Chgs Salaries Admin Expense Interest Expense Admin Expense. Copyright © 2013, Oracle and/or its affiliates. All rights reserved.. After an application is created and metadata is loaded, the system generates system-defined member lists. System-defined member lists group members according to common properties, such as all children of a specified parent or all base members of a specified dimension. For the example in the slide, Sales and SalesInterco are shown as children of Total Revenue, and Sales, SalesInterco, Salaries, Interest Charges, and Administration Expense are shown as base members in a hierarchy.. Oracle Hyperion Financial Management 11.1.2: Create & Manage Applications 13 - 4. Oracle University and (Oracle Corporation) use only.. These eKit materials are to be used ONLY by you for the express purpose SELF STUDY. SHARING THE FILE IS STRICTLY PROHIBITED.. System-Defined Member Lists.

(21) Create user-defined member lists to customize your application. Income Before Taxes. Static member list. Gross Margin. Dynamic member list. Total Revenue Sales Sales Interco. Total Costs Total Revenue Salaries Total Costs Interest Chgs. Total Costs. Admin Expense Salaries. Admin Expense. Interest Expense Admin Expense. Copyright © 2013, Oracle and/or its affiliates. All rights reserved.. User-defined members lists are static or dynamic. Static member lists contain user-specified dimension members. To add members to static lists (for example, to add accounts to a static Account member list, such as ProfitandLoss), you must add the members manually. Dynamic member lists contain members that, at run time, meet specified criteria. Because the lists are built dynamically, they are updated when they are retrieved. For the example in the slide, Total Revenue, Total Costs, and Administration Expense are shown as members of the static list and Total Costs, Salaries, Interest Charges, and Administration Expense are shown as members of the dynamic list. Dynamic Tip: Static lists are helpful when you need a standard list, such as a list of tax accounts.. Oracle Hyperion Financial Management 11.1.2: Create & Manage Applications 13 - 5. Oracle University and (Oracle Corporation) use only.. These eKit materials are to be used ONLY by you for the express purpose SELF STUDY. SHARING THE FILE IS STRICTLY PROHIBITED.. User-Defined Member Lists.

(22) • •. Create member lists in a text file that you load into your application. Include definitions for all user-defined member lists in a single file. Sub EnumMemberLists() Dim aEntityLists(2) Dim aAccountLists(1) If HS.Dimension = "Entity" Then aEntityLists(1) = "UnitedStates" aEntityLists(2) = "Europe" HS.SetMemberLists aEntityLists ElseIf HS.Dimension = "Account" Then aAccountLists(1) = "ProfitAndLoss" HS.SetMemberLists aAccountLists End If End Sub. Copyright © 2013, Oracle and/or its affiliates. All rights reserved.. You can use a text editor, such as Microsoft Notepad, to create member list files. Member list creation process: 1. Identify the number of lists for the dimension and the name and number ID for each list. 2. Following Microsoft Visual Basic script syntax, add members to each static and dynamic list. The example in the slide shows the following syntax for creating two Entity member lists and one Account member list: Sub EnumMemberLists () Dim aEntityLists(2) Dim aAccountLists(1) If HS.Dimension = “Entity” Then. Oracle Hyperion Financial Management 11.1.2: Create & Manage Applications 13 - 6. Oracle University and (Oracle Corporation) use only.. These eKit materials are to be used ONLY by you for the express purpose SELF STUDY. SHARING THE FILE IS STRICTLY PROHIBITED.. Creating Member Lists.

(23) ElseIf HS.Dimension = “Account” Then aAccountLists(1) = “ProfitAndLoss” HS.SetMemberLists aAccountLists End If End Sub. Oracle University and (Oracle Corporation) use only.. These eKit materials are to be used ONLY by you for the express purpose SELF STUDY. SHARING THE FILE IS STRICTLY PROHIBITED.. aEntityLists(1) = “UnitedStates” aEntityLists(2) = “Europe” HS.SetMemberLists aEntityLists. Oracle Hyperion Financial Management 11.1.2: Create & Manage Applications 13 - 7.

(24) Use the EnumMemberLists subroutine to specify the number of member lists and the names of the member lists. Sub EnumMemberLists() Dim aEntityLists(2) Dim aAccountLists(1) If HS.Dimension = "Entity" Then aEntityLists(1) = "UnitedStates" aEntityLists(2) = "Europe" HS.SetMemberLists aEntityLists ElseIf HS.Dimension = "Account" Then aAccountLists(1) = "ProfitAndLoss" HS.SetMemberLists aAccountLists End If End Sub. Copyright © 2013, Oracle and/or its affiliates. All rights reserved.. Each member list file must include an EnumMemberLists subroutine to specify which dimensions have member lists, the number of lists for each dimension, and the name of each member list. The following table describes the syntax shown in the slide: Syntax. Description. Dim aElementLists(n). Specifies the number of lists for each statement. Element = dimension name n = total number of member lists for this element For example, if the file contains four member lists for the Entity dimension, the syntax is Dim aEntityLists(4).. Oracle Hyperion Financial Management 11.1.2: Create & Manage Applications 13 - 8. Oracle University and (Oracle Corporation) use only.. These eKit materials are to be used ONLY by you for the express purpose SELF STUDY. SHARING THE FILE IS STRICTLY PROHIBITED.. Identifying Member Lists in a File.

(25) Description. aElementLists(n) = “ListName”. Specifies the name and numeric ID for each list. Element = dimension name n = ID number of the list “ListName”= name of the list For example, to set the name for the first Entity member list as UnitedStates, use aEntityLists(1) = “UnitedStates”.. HS.SetMemberLists aElementLists. Sets the specified names and numeric IDs. Element = dimension name For example, to set the name and ID number of the lists for the Entity dimension use HS.SetMemberLists aEntityLists.. Oracle Hyperion Financial Management 11.1.2: Create & Manage Applications 13 - 9. Oracle University and (Oracle Corporation) use only.. These eKit materials are to be used ONLY by you for the express purpose SELF STUDY. SHARING THE FILE IS STRICTLY PROHIBITED.. Syntax.

(26) Use the EnumMembersInList subroutine to create static and dynamic member lists.. Sub EnumMembersInList() If HS.Dimension = "Account" Then If Hs.MemberListID=1 Then HS.AddMemberToList "Sales" HS.AddMemberToList "SalesInterco" HS.AddMemberToList "Purchases" HS.AddMemberToList "PurchasesInterco" End If End If End Sub. Copyright © 2013, Oracle and/or its affiliates. All rights reserved.. You use the EnumMembersInList subroutine to add members to a list. For a static member list, you list all members of the list in the script. For all dimensions except Entity, you use the HS.AddMemberToList statement, in which you must specify a member. For the Entity dimension, you use the Hs.AddEntityToList statement, in which you must specify a member and its parent.. Oracle Hyperion Financial Management 11.1.2: Create & Manage Applications 13 - 10. Oracle University and (Oracle Corporation) use only.. These eKit materials are to be used ONLY by you for the express purpose SELF STUDY. SHARING THE FILE IS STRICTLY PROHIBITED.. Creating Static Member Lists.

(27) Syntax. Description. HS.MemberListID=n. Specifies the member list by its numeric ID. n = numeric ID assigned to the member list in the EnumMemberLists subroutine. HS.AddMemberToList "Member". Adds members to a list for dimensions other than Entity. Member = member name The following example adds the Sales member to the member list: HS.AddMemberToList "Sales"- Specifies the members to include in the list.. HS.AddEntityToList “Parent”, “Member”. Adds members to a list for the Entity dimension. Parent = parent of the member that you are adding Member = a member of the Entity dimension The following example adds the CA_Top member to the member list: HS.AddEntityToList “WestRegion”, “CA_Top”. Sample Script The following member list script creates two Entity member lists and one Account member list: Sub EnumMemberLists() Dim aEntityLists(2) Dim aAccountLists(1) If HS.Dimension = "Entity" Then aEntityLists(1) = "UnitedStates" aEntityLists(2) = "Europe" HS.SetMemberLists aEntityLists ElseIf HS.Dimension = "Account" Then aAccountLists(1) = "ProfitAndLoss" HS.SetMemberLists aAccountLists End If End Sub Sub EnumMembersInList() If HS.Dimension = "Entity" Then If HS.MemberListID=1 Then. Oracle Hyperion Financial Management 11.1.2: Create & Manage Applications 13 - 11. Oracle University and (Oracle Corporation) use only.. These eKit materials are to be used ONLY by you for the express purpose SELF STUDY. SHARING THE FILE IS STRICTLY PROHIBITED.. The following table describes the functions that you use within the EnumMembersInList subroutine to add members to lists:.

(28) Oracle Hyperion Financial Management 11.1.2: Create & Manage Applications 13 - 12. Oracle University and (Oracle Corporation) use only.. These eKit materials are to be used ONLY by you for the express purpose SELF STUDY. SHARING THE FILE IS STRICTLY PROHIBITED.. HS.AddEntityToList "WestRegion","CA_Top" HS.AddEntityToList "EastRegion","CT_Top" ElseIf HS.MemberListID=2 Then HS.AddEntityToList "Europe","ITA_Top" HS.AddEntityToList "Europe","FRA_Top" HS.AddEntityToList "Europe","UK_Top" End If ElseIf HS.Dimension = "Account" Then If HS.MemberListID=1 Then HS.AddMemberToList "Sales" HS.AddMemberToList "SalesInterco" HS.AddMemberToList "Purchases" HS.AddMemberToList "PurchasesInterco" End If End If End Sub.

(29) Dynamic member lists select members from a dimension based on specified criteria. Loops through the dimension members If HS.Dimension = "Entity" Then If HS.MemberListID=1 Then ELi=HS.Entity.List("","") For i=Lbound(ELi) to Ubound(ELi) If (StrComp(HS.Entity.DefCurrency(ELi(i)), “USD”,vbTextCompare)=0) Then HS.AddEntityToList "",ELi(i) End If Next End If End If. Creates an array of the dimension members. Checks the currency property of each member. Copyright © 2013, Oracle and/or its affiliates. All rights reserved.. For Dynamic member lists, instead of listing all members of the member list, you enter rules to select members that meet specified criteria. Criteria are member properties such as currency or account type. The list is generated dynamically each time it is accessed by a user. For the example in the slide, the list of entities is received into an array. For each entity in the array, the value of the DefaultCurrency property is compared with the preferred value of USD. If the value is equal to USD, the entity is added to the list. Then the next entity in the array is processed.. Oracle Hyperion Financial Management 11.1.2: Create & Manage Applications 13 - 13. Oracle University and (Oracle Corporation) use only.. These eKit materials are to be used ONLY by you for the express purpose SELF STUDY. SHARING THE FILE IS STRICTLY PROHIBITED.. Creating Dynamic Member Lists for the Entity Dimension.

(30) Creates an array of the dimension members. Loops through the dimension members. Ali=HS.Account.List("","") For i=Lbound(ALi) to Ubound(ALi) If (StrComp(HS.Account.AccountType(ALi(i)),"asset",vbTextCompare)=0) Then HS.AddMembertoList ALi(i) End If Next. Checks the account type property of each member. Copyright © 2013, Oracle and/or its affiliates. All rights reserved.. The example in the slide shows the following syntax for creating a dynamic member list in the Account dimension for all accounts of the Asset account type: Ali=HS.Account. List(““,””) For i=Lbound(ALi) to Ubound(ALi) If (StrComp(HS.Account.AccountType(ALi(i)),”asset”,vbTextCompare)=0) Then HS.AddMembertoList ALi(i). End If Next. Oracle Hyperion Financial Management 11.1.2: Create & Manage Applications 13 - 14. Oracle University and (Oracle Corporation) use only.. These eKit materials are to be used ONLY by you for the express purpose SELF STUDY. SHARING THE FILE IS STRICTLY PROHIBITED.. Creating Dynamic Member Lists for Other Dimensions.

(31) The available columns for LinesOfBusiness change based on the Entity member selected for the POV.. Copyright © 2013, Oracle and/or its affiliates. All rights reserved.. You use dynamic POV member lists in the rows or columns of data grids and data forms. They allow you to change the rows or columns displayed for a dimension based on the currently selected members of the Entity, Period, Year, or Scenario dimension in the POV. You can base the member list on more than one POV dimension, for example, on the current combination of Scenario and Period. In the slide example, the LinesOfBusiness dimension contains hardware and software products. Entities in Connecticut do business only in software; entities in all other states do business in both hardware and software. A dynamic POV member list is used in the row section of the data form. When the user selects an entity in Connecticut in the POV, the member list displays rows for software products only; when the user selects an entity in any other state, the form displays rows for both hardware and software products .. Oracle Hyperion Financial Management 11.1.2: Create & Manage Applications 13 - 15. Oracle University and (Oracle Corporation) use only.. These eKit materials are to be used ONLY by you for the express purpose SELF STUDY. SHARING THE FILE IS STRICTLY PROHIBITED.. About Dynamic POV Member Lists.

(32) • •. •. The member list name must have the suffix (@POV), for example: LOB by State(@POV). Use the HS.MemberList<Dimension> function to retrieve the current POV member; for example, HS.MemberListYear. The valid POV dimensions you can reference in dynamic POV member lists are Entity, Year, Scenario, and Period. ElseIf HS.Dimension aCustom1Lists(1) aCustom1Lists(2) aCustom1Lists(3). = = = =. "LinesOfBusiness" Then "Business" "LinesOfBusiness" "LOB By State(@POV)". Copyright © 2013, Oracle and/or its affiliates. All rights reserved.. Oracle Hyperion Financial Management 11.1.2: Create & Manage Applications 13 - 16. Oracle University and (Oracle Corporation) use only.. These eKit materials are to be used ONLY by you for the express purpose SELF STUDY. SHARING THE FILE IS STRICTLY PROHIBITED.. Creating Dynamic POV Member Lists.

(33) Stores the current Entity POV member.. Loops through the dimension members in Ali and adds them to the member list.. ElseIf HS.MemberListID = 3 Then EntityPOV=HS.MemberListEntity If HS.Entity.IsCHild("CT_TOP",EntityPOV)Then Ali=HS.Custom("LinesOfBusiness").List("Software","[BASE]") Else Ali=HS.Custom("LinesOfBusiness").List("AllLinesOfBusiness","[BASE]") End If For i=Lbound(ALi) to Ubound(ALi) HS.AddMembertoList ALi(i) Next. Sets the LinesOfBusiness members stored in the Ali variable based on whether or not the current POV entity is a child of CT_TOP.. Copyright © 2013, Oracle and/or its affiliates. All rights reserved.. In the slide example: 1. The HS.MemberListEntity function retrieves the currently selected entity POV member and stores it in the EntityPOV variable. 2. An If..Then...Else statement checks whether the current entity member is a child of CT_TOP. If it is, then the base members of the Software member are stored in the Ali variable. For all other entities (the Else condition), the base members under the AllLinesOfBusiness member are stored in the Ali variable . 3. The For...Next statement adds the members stored in Ali to the member list.. Oracle Hyperion Financial Management 11.1.2: Create & Manage Applications 13 - 17. Oracle University and (Oracle Corporation) use only.. These eKit materials are to be used ONLY by you for the express purpose SELF STUDY. SHARING THE FILE IS STRICTLY PROHIBITED.. Dynamic POV Member List Example.

(34) The dynamic POV member lists available for each dimension display at the bottom of the Member Selection dialog box.. Copyright © 2013, Oracle and/or its affiliates. All rights reserved.. Oracle Hyperion Financial Management 11.1.2: Create & Manage Applications 13 - 18. Oracle University and (Oracle Corporation) use only.. These eKit materials are to be used ONLY by you for the express purpose SELF STUDY. SHARING THE FILE IS STRICTLY PROHIBITED.. Using Dynamic POV Member Lists.

(35) You load member lists from the Load Application Elements task.. Select the member list file to load.. Copyright © 2013, Oracle and/or its affiliates. All rights reserved.. After creating a member list script file, you load it into your application. You load member lists using the Load Application Elements task. Before loading the file, you can scan to verify that it is formatted correctly. When you modify the file, you must reload it into the application. Tip: If you click the Scan button, the syntax is checked; the members that are retrieved are not checked. To load member lists: 1. Select Consolidation, then Load, and then Application Elements. The Load Application Elements task is displayed. 2. In the Member Lists section, click Browse to select the member list that you want to load. 3. Optional: On the Load Members Lists, click Scan to check the syntax of the member list. 4. Click Load to load the member list. 5. Click Log to verify that the member list is loaded successfully.. Oracle Hyperion Financial Management 11.1.2: Create & Manage Applications 13 - 19. Oracle University and (Oracle Corporation) use only.. These eKit materials are to be used ONLY by you for the express purpose SELF STUDY. SHARING THE FILE IS STRICTLY PROHIBITED.. Loading Member Lists.

(36) You extract member list from the Extract Application Elements task.. Copyright © 2013, Oracle and/or its affiliates. All rights reserved.. You extract member lists in the Extract Application Elements task. Extracted member lists are saved as ASCII files. By default, member lists have the file extension LST. To extract member lists: 1. Select Consolidation, then Extract, and then Application Elements. The Extract Application Elements task is displayed. 2. In the Member Lists section, click Extract. A Download button is displayed in the Member Lists section. 3. Click Download. The File Download dialog box is displayed. 4. Click Save. The Save As dialog box is displayed. 5. Browse to a location where you want to save the file, and click Save.. Oracle Hyperion Financial Management 11.1.2: Create & Manage Applications 13 - 20. Oracle University and (Oracle Corporation) use only.. These eKit materials are to be used ONLY by you for the express purpose SELF STUDY. SHARING THE FILE IS STRICTLY PROHIBITED.. Extracting Member Lists.

(37) In this lesson, you should have learned how to: • Describe system-defined and user-defined member lists • Create static and dynamic member lists • Load and extract member lists. Copyright © 2013, Oracle and/or its affiliates. All rights reserved.. Oracle Hyperion Financial Management 11.1.2: Create & Manage Applications 13 - 21. Oracle University and (Oracle Corporation) use only.. These eKit materials are to be used ONLY by you for the express purpose SELF STUDY. SHARING THE FILE IS STRICTLY PROHIBITED.. Summary.

(38) Select a user-defined member list. a. Parent b. Base c. Child d. Income Accounts e. Descendants. Copyright © 2013, Oracle and/or its affiliates. All rights reserved.. Answer: d. Oracle Hyperion Financial Management 11.1.2: Create & Manage Applications 13 - 22. Oracle University and (Oracle Corporation) use only.. These eKit materials are to be used ONLY by you for the express purpose SELF STUDY. SHARING THE FILE IS STRICTLY PROHIBITED.. Quiz.

(39) You use EnumMembersList to specify the names of member lists. a. True b. False. Copyright © 2013, Oracle and/or its affiliates. All rights reserved.. Answer: a. Oracle Hyperion Financial Management 11.1.2: Create & Manage Applications 13 - 23. Oracle University and (Oracle Corporation) use only.. These eKit materials are to be used ONLY by you for the express purpose SELF STUDY. SHARING THE FILE IS STRICTLY PROHIBITED.. Quiz.

(40) You use the HS.AddMemberToList statement to add members to lists for all dimensions except one. Identify the odd one. a. Account b. Entity c. Scenario d. Period. Copyright © 2013, Oracle and/or its affiliates. All rights reserved.. Answer: b. Oracle Hyperion Financial Management 11.1.2: Create & Manage Applications 13 - 24. Oracle University and (Oracle Corporation) use only.. These eKit materials are to be used ONLY by you for the express purpose SELF STUDY. SHARING THE FILE IS STRICTLY PROHIBITED.. Quiz.

(41) You enter rules to select members for a dynamic member list. a. True b. False. Copyright © 2013, Oracle and/or its affiliates. All rights reserved.. Answer: b. Oracle Hyperion Financial Management 11.1.2: Create & Manage Applications 13 - 25. Oracle University and (Oracle Corporation) use only.. These eKit materials are to be used ONLY by you for the express purpose SELF STUDY. SHARING THE FILE IS STRICTLY PROHIBITED.. Quiz.

(42) Practice 13-1: Loading and Using Member Lists Practice 13-2: Creating a Dynamic Member List. Copyright © 2013, Oracle and/or its affiliates. All rights reserved.. Oracle Hyperion Financial Management 11.1.2: Create & Manage Applications 13 - 26. Oracle University and (Oracle Corporation) use only.. These eKit materials are to be used ONLY by you for the express purpose SELF STUDY. SHARING THE FILE IS STRICTLY PROHIBITED.. Practice 13: Overview.

(43) These eKit materials are to be used ONLY by you for the express purpose SELF STUDY. SHARING THE FILE IS STRICTLY PROHIBITED.. Copyright © 2013, Oracle and/or its affiliates. All rights reserved.. Oracle University and (Oracle Corporation) use only.. Managing Rules by Using Calculation Manager.

(44) After completing this lesson, you should be able to: • Describe Financial Management rules and Calculation Manager • Create rules • Create rules sets • Validate rules • Deploy rules • Import and export Calculation Manager objects • Import script-based rules files. Copyright © 2013, Oracle and/or its affiliates. All rights reserved.. Oracle Hyperion Financial Management 11.1.2: Create & Manage Applications 14 - 2. Oracle University and (Oracle Corporation) use only.. These eKit materials are to be used ONLY by you for the express purpose SELF STUDY. SHARING THE FILE IS STRICTLY PROHIBITED.. Objectives.

(45) Financial Management rules provide powerful, customized calculations, such as: • Ratios and variance analyses • Currency conversions and exchange rate differences • Custom consolidations. %. Copyright © 2013, Oracle and/or its affiliates. All rights reserved.. Financial Management rules provide powerful, customized calculations, such as: • Calculating data that cannot be calculated through a hierarchical aggregation, such as ratios and variance analyses • Performing complex currency conversions and calculating exchange rate differences • Performing custom consolidations for statutory reporting requirements. Oracle Hyperion Financial Management 11.1.2: Create & Manage Applications 14 - 3. Oracle University and (Oracle Corporation) use only.. These eKit materials are to be used ONLY by you for the express purpose SELF STUDY. SHARING THE FILE IS STRICTLY PROHIBITED.. Financial Management Rules.

(46) Calculation Manager. Design. Validate. Deploy. Copyright © 2013, Oracle and/or its affiliates. All rights reserved.. You use Calculation Manager to design, validate, and deploy calculations that enable you to solve business problems. The user interface provides a graphical design environment that enables you to build complex calculations easily. Calculation Manager enables you to break rules into individual rule components that can be shared between applications. For example, you can create a formula to calculate “days sales outstanding,” and then reuse the formula in all applications that require this calculation. Rules created in Calculation Manager are stored in the Calculation Manager database. The rules are validated against the dimension metadata in Performance Management Architect and the deployed Financial Management application. To activate the rules in your Financial Management applications, you deploy the rules from Calculation Manager to your Financial Management application server. You can deploy Calculation Manager rules to both Financial Management applications built in Performance Management architect and to Classic Administration applications.. Oracle Hyperion Financial Management 11.1.2: Create & Manage Applications 14 - 4. Oracle University and (Oracle Corporation) use only.. These eKit materials are to be used ONLY by you for the express purpose SELF STUDY. SHARING THE FILE IS STRICTLY PROHIBITED.. Calculation Manager Overview.

(47) Calculation Manager. FinApp Application. FINAPP_CalcMgr.rle. Copyright © 2013, Oracle and/or its affiliates. All rights reserved.. Rules for Financial Management application use Microsoft Visual Basic Script (VB Script) syntax, enhanced with special functions for Financial Management. Calculation Manager provides a graphical interface that enables you to create Financial Management rules without requiring knowledge of VB Script syntax. You create graphical rules in Calculation Man ager, and when you deploy the rules to your Financial Management applications, Calculation Manager automatically converts the graphical rules to a VB Script file, and then loads the file into the application. In the slide example, rules are deployed from Calculation Manager to a Financial Management application named FinApp. Note: You are not required to use Calculation Manager to create Financial Management rules. If you are knowledgeable of VB Script, you can create VB Script files in a text editor or other scripting tool and load the script file directly into your Financial Management application using the Load Application Elements task.. Oracle Hyperion Financial Management 11.1.2: Create & Manage Applications 14 - 5. Oracle University and (Oracle Corporation) use only.. These eKit materials are to be used ONLY by you for the express purpose SELF STUDY. SHARING THE FILE IS STRICTLY PROHIBITED.. Calculation Manager and VB Script.

(48) The Calculate rules run when you select Calculate in a data grid or data form.. Copyright © 2013, Oracle and/or its affiliates. All rights reserved.. The rules for each Financial Management application are organized into eleven rule types. For each rule type, you create a rule set. You can create more than one rule set for each type, but you can deploy only one rule set for each type to the application. You execute the rules for a rule type by performing actions within Financial Management. For the example in the slide, when you select Calculate from the shortcut menu of a data grid, the rules for the Calculate rule type are executed.. Oracle Hyperion Financial Management 11.1.2: Create & Manage Applications 14 - 6. Oracle University and (Oracle Corporation) use only.. These eKit materials are to be used ONLY by you for the express purpose SELF STUDY. SHARING THE FILE IS STRICTLY PROHIBITED.. Rule Types and Rule Sets.

(49) Rule Type. Description. Calculate. Set account values based on formulas. You can run Calculate rules from data grids, data forms, and the Process Control task. Calculate rules are executed automatically when you consolidate an entity.. Dynamic. Create formulas for accounts with the Dynamic account type. Dynamic accounts accurately calculate YTD and Periodic values that are not calculated correctly by the aggregation of base member values. Dynamic rules are valid only for dynamic accounts, and are executed automatically when you open data grids and data forms that contain accounts with the account type Dynamic.. Translate. Perform custom currency translations. You can run Translate rules from data grids, data forms, and the Process Control task. Translate rules are executed automatically when you consolidate if the parent currency is different than the child currency.. Consolidate. Perform customized consolidation and elimination calculations. You run Consolidate rules from data grids and the Process Control task.. Equity Pick Up. Perform customized ownership calculations for entities. You run Equity Pick Up rules from data grids or the Manage Equity Pick Up task.. Allocate. Set allocate data from a source to multiple destinations. You run Allocate rules from data grids or data forms.. Input. Configure parent members to allow data entry. Input rules are executed when you open an application.. No Input. Configure members to prevent data entry. No Input rules are executed when you open an application.. Transaction. Configure accounts to allow posting of data from the Intercompany Transaction module. Transaction rules are executed when you open an application.. Generic. Reuse rules in rule sets for more than one rule type. For example, you create a rule for rounding that you use in your Calculate and Translate rule sets. You must add Generic rules to a rule set for one or more of the other rule types in order to deploy them in a Financial Management application. You can nest generic rule sets within rules sets for any rule type.. Global. Use Generic rules to set global values that you can use in all calculation types. These rules run before all other rule types. For example, you could create a rule that defines variables for names of your exchange rate accounts and then reuse the variables as needed in rules for other calculation types.. Oracle Hyperion Financial Management 11.1.2: Create & Manage Applications 14 - 7. Oracle University and (Oracle Corporation) use only.. These eKit materials are to be used ONLY by you for the express purpose SELF STUDY. SHARING THE FILE IS STRICTLY PROHIBITED.. The following table describes the Financial Management rule types:.

(50) Loop component Condition Formula component component. Scope of the Condition component The formula and range components are located within the scope of the Condition component. Copyright © 2013, Oracle and/or its affiliates. All rights reserved.. A rule is a Calculation Manager object that consists of calculations grouped into components. You design a rule by dragging components from the Rule Palette to the flow chart. Each component performs a separate task. Condition Components A condition component comprises conditional statements (If...Then statements) that are either true or false. You insert other rule components within the scope of the condition component. If the condition is true, Calculation Manager executes the components within the scope of the condition component. If the condition is false, the components within the condition are skipped. You use condition components to limit the members for which a rule is executed. For example, if a calculation is valid only for the Forecast scenario, you can create a condition to test whether the current scenario in the point of view is Forecast. For the example in the slide, the loop and formula components are within the scope of the condition component. They are executed only if the condition specified for the condition component evaluates to true.. Oracle Hyperion Financial Management 11.1.2: Create & Manage Applications 14 - 8. Oracle University and (Oracle Corporation) use only.. These eKit materials are to be used ONLY by you for the express purpose SELF STUDY. SHARING THE FILE IS STRICTLY PROHIBITED.. Rules.

(51) Loop Components. Types of loop components: • A member range component creates a loop for a range of members based on a Financial Management member list. Execution of the components within the scope of the loop is repeated for each member in the list. • A data range component creates a loop for all accounts that have data for a specified point of view. For example, if you create a data range component for California, Actual, January, the components in its scope are executed for all accounts that have data for the California entity for the January period and the Actual scenario. • A fixed loop component creates a loop that repeats for a specified number of iterations. For example, you could specify a loop that repeats the execution of the components in its scope 10 times. The example in the slide shows a member range component that uses the Descendants member list of the TotalAssets account as its range. Because the OpeningBalance formula component is within the scope of the member range component, it is executed for each account that is a descendant of the TotalAssets account. Script Components A script component contains rules written in the Microsoft Visual Basic Script (VB Script) programming language. Tip: When you add a script component to a rule, you can optionally right-click the component and select Convert to Graphical to convert the script-based rules to graphical components.. Oracle Hyperion Financial Management 11.1.2: Create & Manage Applications 14 - 9. Oracle University and (Oracle Corporation) use only.. These eKit materials are to be used ONLY by you for the express purpose SELF STUDY. SHARING THE FILE IS STRICTLY PROHIBITED.. A loop component repeats the execution of the components within its scope based on specified criteria..

(52) Destination. Condition. Source. Functions. Copyright © 2013, Oracle and/or its affiliates. All rights reserved.. Formula components are the primary components of a rule. You use them to assign values to accounts or to clear account values. The formula component comprises calculation statements that assign values to accounts based on your defined formula. To create the calculation statements, you add rows to grids in the formula component. Each calculation statement in the grid consists of a destination expression and a source expression. The destination expression is displayed on the left of the equal sign, and the source expression is displayed on the right. You use dimension keywords to identify the dimensions for the members included in the expressions. Dimension keywords for standard dimensions consist of the first letter of the dimension followed by a pound sign (#). For example, A#Sales identifies the Sales member of the account dimension. Dimension keywords for custom dimensions consist of the dimension alias or short name followed by a pound sign. For example, Flows#ClosingBalance identifies the ClosingBalance member of the Flows dimension.. Oracle Hyperion Financial Management 11.1.2: Create & Manage Applications 14 - <#>. Oracle University and (Oracle Corporation) use only.. These eKit materials are to be used ONLY by you for the express purpose SELF STUDY. SHARING THE FILE IS STRICTLY PROHIBITED.. Formula Components.

(53) The example in the slide shows a formula component with two grids: • In the first row of the first grid, the destination is the Surplus member of the Account dimension. The source expression retrieves values for the TotalLiabEquity and TotalAssets accounts and calculates their difference. • You can use functions within source and destination expressions. In the second grid, the Last function is used with the P# keyword and the Prior function is used with the Y# keyword to retrieve values for the last period of the prior year. The condition statement verifies that it is not the application’s first year. If the condition is true, the calculation statement in the grid is executed; otherwise, it is skipped.. Oracle Hyperion Financial Management 11.1.2: Create & Manage Applications 14 - 11. Oracle University and (Oracle Corporation) use only.. These eKit materials are to be used ONLY by you for the express purpose SELF STUDY. SHARING THE FILE IS STRICTLY PROHIBITED.. Data is retrieved from the dimension members specified in the source expression and written to the members specified in the destination expression. • You can specify members from the account, custom, and ICP dimensions in the destination expressions. • You can specify members from any dimension in the source expression. • You can use standard math operators to perform calculations on the source data before it is written to the destination. For example, you increase the source data values by 10% before writing the values to the destination. • You can also add condition statements to grids. The calculation statements in the grid are executed only if the condition evaluates to true..

(54) Drag components from the Rule Palette to the flow chart.. Use the tabs to configure the selected component.. Copyright © 2013, Oracle and/or its affiliates. All rights reserved.. You create rules for the rule types required by your application. When you add components to a rule, you can create components for the rule or you can reuse components. For example, you create a formula component for Rule1 named Balances that retrieves opening balances for accounts. When you create Rule 2, you can reuse the Balances component. Note: You cannot reuse loop or condition components. However, you can copy and paste loop or condition components between rules.. Oracle Hyperion Financial Management 11.1.2: Create & Manage Applications 14 - <#>. Oracle University and (Oracle Corporation) use only.. These eKit materials are to be used ONLY by you for the express purpose SELF STUDY. SHARING THE FILE IS STRICTLY PROHIBITED.. Creating Rules.

(55) Oracle Hyperion Financial Management 11.1.2: Create & Manage Applications 14 - 13. Oracle University and (Oracle Corporation) use only.. These eKit materials are to be used ONLY by you for the express purpose SELF STUDY. SHARING THE FILE IS STRICTLY PROHIBITED.. To create rules: 1. Log on to Workspace. 2. In Performance Management Architect, select Navigate, then Administer, and then Calculation Manager. 3. Expand Financial Management. 4. Expand the application for which you want to create a rule. 5. Expand the rule type for the rule. For example, if you are creating Calculation rules, expand Calculate. 6. Under the rule type, right-click Rules and then select New. - The New Rule dialog box is displayed. 7. In the Name text box, enter a name for the rule. 8. Click OK. - Rule Designer is displayed. 9. Add components to the Rule Designer flow chart in the order that you want them to be executed: - Add a new component to the rule: Drag a component from the New Objects section of the Rule Palette to the Rule Designer flow chart. - Reuse a component from an existing rule: Drag a component from the Existing Objects section of the Rule Palette to the Rule Designer flow chart. 10. Select each component in the flow chart, and configure the component as required for your calculation. 11. Select File, and then Save..

(56) Graphical View. Script View. Copyright © 2013, Oracle and/or its affiliates. All rights reserved.. The Rule Designer allows you to edit rules in script view. Changes you make to calculation manager objects in script view are preserved when you return to the graphical view. Note: Changes you make to the shared components in the rule in script view are not saved when you return to the graphical view. To edit rules in script view: 1. In Calculation Manager, open a rule. -. The rule designer is displayed.. 2. If you have made change to the rule, save your changes. 3. Select Edit, and then Script. -. The rule is displayed in the script editor.. 4. Edit the script for the rule components as needed. 5. Select Edit, and then Graphical. 6. Click Save to save you changes.. Oracle Hyperion Financial Management 11.1.2: Create & Manage Applications 14 - <#>. Oracle University and (Oracle Corporation) use only.. These eKit materials are to be used ONLY by you for the express purpose SELF STUDY. SHARING THE FILE IS STRICTLY PROHIBITED.. Editing Rules in Script View.

(57) Copyright © 2013, Oracle and/or its affiliates. All rights reserved.. Before you can deploy the rules for a rule type, you must create a rule set and add the rules to it. The order that you place the rules in the rule set determines their order of execution. You can include one rule set inside another rule set. For the example in the slide, you create a rule set named SalesAndPrice for all sales-related rules. You include the SalesAndPrice rule set within another rule set named CalcRules, which contains all rules for the Calculate rules type. To create rule sets: 1. In Calculation Manager, expand Consolidation. 2. Expand an application. 3. Expand the rule type for the rule set that you want to create.. Oracle Hyperion Financial Management 11.1.2: Create & Manage Applications 14 - 15. Oracle University and (Oracle Corporation) use only.. These eKit materials are to be used ONLY by you for the express purpose SELF STUDY. SHARING THE FILE IS STRICTLY PROHIBITED.. Creating Rule Sets.

(58) Oracle Hyperion Financial Management 11.1.2: Create & Manage Applications 14 - 16. Oracle University and (Oracle Corporation) use only.. These eKit materials are to be used ONLY by you for the express purpose SELF STUDY. SHARING THE FILE IS STRICTLY PROHIBITED.. 4. Under the rule type, right-click Rule Sets and then select New. - The New Rule Set dialog box is displayed. 5. In the Name text box, enter a name for the rule set. 6. Click OK. - Ruleset Designer is displayed. 7. In Rule Set Palette, drag the first rule or rule set to Ruleset Designer. 8. Continue dragging rules and rule sets from Rule Set Palette to Ruleset Designer until you add all rules required for the current rule set. Note: The order in which the rules are displayed in Ruleset Designer determines the execution order for the rules. You can use the Up and Down arrows to reorder the rules. 9. Select File, and then Save. 10. Select File, then Close, and then Current..

(59) Formula components. Rules. Rule sets. Script components. Copyright © 2013, Oracle and/or its affiliates. All rights reserved.. You validate rules to verify that the syntax does not contain errors and that all dimension members referenced in the rules exist in the application. You can validate an entire rule set, an individual rule, or an individual formula or script component. You cannot deploy rules to Financial Management applications until all validation errors are corrected. To validate rules: 1. In Calculation Manager, expand Consolidation. 2. Expand an application. 3. Right-click a rule set, rule, formula component, or script component, and select Validate. - The Information dialog box displays any validation errors. 4. Click OK.. Oracle Hyperion Financial Management 11.1.2: Create & Manage Applications 14 - <#>. Oracle University and (Oracle Corporation) use only.. These eKit materials are to be used ONLY by you for the express purpose SELF STUDY. SHARING THE FILE IS STRICTLY PROHIBITED.. Validating Rules.

(60) Rule sets currently deployed. Rule set selected for deployment Copyright © 2013, Oracle and/or its affiliates. All rights reserved.. You cannot execute rules within Financial Management applications until you deploy the rules from Calculation Manager to the application. Deployment Guidelines • You can deploy only one rule set from each rule type. However, the rule set can have other rule sets nested within it. • You do not need to deploy rules sets for all rule types. For example, you can deploy only a rule set for the Calculate rule type. • When you deploy rules, all existing rule sets in the application are erased and replaced with the rules sets that you deploy. To deploy rules to an application: 1. In Calculation Manager, select View, and then Deployment View. 2. Expand Consolidation.. Oracle Hyperion Financial Management 11.1.2: Create & Manage Applications 14 - 18. Oracle University and (Oracle Corporation) use only.. These eKit materials are to be used ONLY by you for the express purpose SELF STUDY. SHARING THE FILE IS STRICTLY PROHIBITED.. Deploying Rules.

(61) Expand the application for which you want to deploy rules. Expand the To Be Deployed node. Expand the rule type for which you want to deploy rules. Select the rule set to deploy. Right-click the application name, and select Deploy.. Oracle University and (Oracle Corporation) use only.. These eKit materials are to be used ONLY by you for the express purpose SELF STUDY. SHARING THE FILE IS STRICTLY PROHIBITED.. 3. 4. 5. 6. 7.. Oracle Hyperion Financial Management 11.1.2: Create & Manage Applications 14 - 19.

(62) Import. Export. Copyright © 2013, Oracle and/or its affiliates. All rights reserved.. You can import Calculation Manager objects from or export them to XML files. You can import and export individual Calculation Manager objects or an entire application. If you import or export an entire application, all rules, rules sets, rule components, and variables for the application are in a single XML file. When you export Calculation Manager objects from an application to an XML file, the application name is included in the file. When you import the file, the Calculation Manager objects are imported into the application named in the file. You can override the target application at the time of import. To import Calculation Manager objects: 1. In Calculation Manager, select File, and then Import. - The Import dialog box is displayed. 2. Click Browse and select an XML file. 3. Optional: Click Update Details to modify the target application. Note: If you do not modify the target application, the Calculation Manager objects are imported into the same application from which they were exported.. Oracle Hyperion Financial Management 11.1.2: Create & Manage Applications 14 - <#>. Oracle University and (Oracle Corporation) use only.. These eKit materials are to be used ONLY by you for the express purpose SELF STUDY. SHARING THE FILE IS STRICTLY PROHIBITED.. Importing and Exporting Calculation Manager Objects.

(63) To export all Calculation Manager objects for an application: 1. In Calculation Manager, expand Consolidation. 2. Right-click an application, and select Export. - The File Download dialog box is displayed. 3. Click Save. - The Save As dialog box is displayed. 4. In the File Name text box, enter a name for the file. 5. Browse to the location where you want to save the file. 6. Click Save.. Oracle Hyperion Financial Management 11.1.2: Create & Manage Applications 14 - 21. Oracle University and (Oracle Corporation) use only.. These eKit materials are to be used ONLY by you for the express purpose SELF STUDY. SHARING THE FILE IS STRICTLY PROHIBITED.. 4. Select one of the following import options: - Select Override Existing Objects to replace Calculation Manager objects that have the same name as objects in the XML file. - Select Skip Existing Objects to skip objects in the XML file that exist in Calculation Manager. - Select Error out for duplicates to halt the import process if duplicate object names are in Calculation Manager and the XML file. 5. Click Import. - A dialog box displays an import results log. 6. Optional: Click Save to save the import results log to a file. 7. Click OK. To export individual Calculation Manager objects: 1. In Calculation Manager, expand Consolidation. 2. Expand the application that contains the object to export. 3. Right-click a rule set, rule, formula component, or script component, and select Export. - The File Download dialog box is displayed. 4. Click Save. - The Save As dialog box is displayed. 5. In the File Name text box, enter a name for the file. 6. Browse to the location where you want to save the file. 7. Click Save..

(64) Sub Translate 'Calculate change due to exchange rates HS.Trans "Flows#Rate","Flows#Opening","A#EopRate" HS.Trans "Flows#Move","Flows#P_L","A#EopRate",A#A End Sub. Copyright © 2013, Oracle and/or its affiliates. All rights reserved.. Prior to version 11.1.1 of Financial Management, you were required to create rules by using VB Script. Rules for all calculation types were included in a single script-based rules file (RLE) that you loaded into Financial Management. You can import RLE files into Calculation Manager either as script components or as Calculation Manager objects. Importing RLE Files as Script Components When you import RLE files, for each SUB procedure of a valid calculation type in the RLE file, a rule set containing one business rule and one script component is created. The example in the slide shows the SUB TRANSLATE procedure of an RLE file and the following Translate type objects that are created in Calculation Manager: • A script component named Translate_Component that contains all script from the procedure • A rule named Translate_Rule that includes Translate_Component as a component. Oracle Hyperion Financial Management 11.1.2: Create & Manage Applications 14 - <#>. Oracle University and (Oracle Corporation) use only.. These eKit materials are to be used ONLY by you for the express purpose SELF STUDY. SHARING THE FILE IS STRICTLY PROHIBITED.. Importing Script-Based Rules Files.

(65) •. A rule set named Translate_Ruleset that includes Translate_Rule as a member. You can migrate RLE files to Calculation Manager objects. To determine how to split groups of VB script calculation statements into Calculation Manager components, the comment lines in the VB script file are used. Three component-splitting options are provided: • Separate component: A separate formula component is created for the calculation statements following each comment line. • Multiblock component: A single formula component is created, with separate grids for the calculation statements following each comment line. • Single-block component: All calculation statements are added to a single formula component in a single grid, regardless of comment lines. To import script-based rules files: 1. In Calculation Manager, select File, and then Import. - The Import dialog box is displayed. 2. Click Browse and select an XML file. 3. Click Update Details. - The File Import Details dialog box is displayed. 4. Select the application type and the target application. 5. Click OK. 6. Select one of the following import options: - Select Override Existing Objects to replace Calculation Manager objects that have the same name as objects in the XML file. - Select Skip Existing Objects to skip objects in the XML file that exist in Calculation Manager. - Select Error out for duplicates to halt the import process if duplicate object names are in Calculation Manager and the XML file. 7. To Import the file as script components, in the Conversion Options area, select Script components. 8. To import the file as Calculation Manager objects, perform these steps: a. In the Conversion Options area, select Graphical components. b. Select Use component level condition object if you want conditions to be added to the grid formula component, rather than using a separate Condition component. Note: If you select this option, all calculation statements within the condition range are placed in a single formula component with a single grid, regardless of the selected component-splitting option. c. Select a component-splitting option.. Oracle Hyperion Financial Management 11.1.2: Create & Manage Applications 14 - 23. Oracle University and (Oracle Corporation) use only.. These eKit materials are to be used ONLY by you for the express purpose SELF STUDY. SHARING THE FILE IS STRICTLY PROHIBITED.. Importing Script-Based Files as Calculation Manager Objects.

(66) Oracle University and (Oracle Corporation) use only.. These eKit materials are to be used ONLY by you for the express purpose SELF STUDY. SHARING THE FILE IS STRICTLY PROHIBITED.. 9. Click Import. - A dialog box displays an import results log. 10. Optional: Click Save to save the import results log to a file. 11. Click OK.. Oracle Hyperion Financial Management 11.1.2: Create & Manage Applications 14 - 24.

No results found