Hyperion Financial Management - User's Guide
Hyperion Financial Management - User's Guide
Hyperion Financial Management - User's Guide
RELEASE 11.1.1.3
USERS GUIDE
Financial Management Users Guide, 11.1.1.3 Copyright 2000, 2009, Oracle and/or its affiliates. All rights reserved. Authors: EPM Information Development Team This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited. The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing. If this software or related documentation is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, the following notice is applicable: U.S. GOVERNMENT RIGHTS: Programs, software, databases, and related documentation and technical data delivered to U.S. Government customers are "commercial computer software" or "commercial technical data" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, the use, duplication, disclosure, modification, and adaptation shall be subject to the restrictions and license terms set forth in the applicable Government contract, and, to the extent applicable by the terms of the Government contract, the additional rights set forth in FAR 52.227-19, Commercial Computer Software License (December 2007). Oracle USA, Inc., 500 Oracle Parkway, Redwood City, CA 94065. This software is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications which may create a risk of personal injury. If you use this software in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy and other measures to ensure the safe use of this software. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software in dangerous applications. This software and documentation may provide access to or information on content, products and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third party content, products and services. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third party content, products or services.
Contents
Documentation Accessibility . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 15 Chapter 1. About Financial Management . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17 Financial Management Features . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17 Architecture . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18 Performance Management Architect . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18 EPM Workspace . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18 Related Products . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18 Financial Management Dimensions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19 Scenario Dimension . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19 Year Dimension . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19 Period Dimension . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19 Entity Dimension . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 20 Value Dimension . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 20 Account Dimension . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 20 Intercompany Dimension . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 20 View Dimension . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21 Custom Dimensions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21 User-Defined Elements . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 21 Chapter 2. Basic Financial Management Procedures . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27 Starting Financial Management . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 27 Starting Financial Management from the Windows Desktop . . . . . . . . . . . . . . . . . . . 27 Starting Financial Management on the Web . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 28 Starting Financial Management with SiteMinder . . . . . . . . . . . . . . . . . . . . . . . . . . . . 28 Opening Applications . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 28 Setting User Preferences . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 29 Specifying Number Formatting . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 30 Specifying File Extract Options . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 30 Specifying Language Support . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 30 Specifying Startup Options . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 30 Setting User Preferences on the Desktop . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 31
Contents
iii
Setting User Preferences on the Web . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 31 Enabling Multibyte Language Date and Time Formats . . . . . . . . . . . . . . . . . . . . . . . . . . . 32 Using Financial Management Help . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 32 Exiting Financial Management . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 33 Using Financial Management on the Desktop . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 33 Showing and Hiding Desktop Components . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 33 Setting the Point of View on the Desktop . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 34 Selecting Point of View Members on the Desktop . . . . . . . . . . . . . . . . . . . . . . . . . . . 34 Using Point of View Check Boxes in Explore Data . . . . . . . . . . . . . . . . . . . . . . . . . . . 34 Selecting Member Lists on the Desktop . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 35 Viewing Active Entities on the Desktop . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 36 Searching for Dimension Members on the Desktop . . . . . . . . . . . . . . . . . . . . . . . . . . 36 Using Financial Management on the Web . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 37 Setting the Point of View on the Web . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 37 Selecting Multiple Members . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 38 Viewing Active Entities . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 39 Searching for Dimension Members on the Web . . . . . . . . . . . . . . . . . . . . . . . . . . . . 40 Managing Documents . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 40 Managing Task Lists . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 46 Managing Favorites . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 48 Working with System Messages . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 49 Chapter 3. Managing Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 51 Working with Data Files . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 51 Data File Sections . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 51 Dimension Groupings . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 53 Data File Example . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 53 Load Methods . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 53 Merge . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 54 Replace . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 54 Replace by Security . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 55 Accumulate . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 55 Load Example . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 55 Loading Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 56 Viewing Data Load Progress . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 59 Canceling Data Load Tasks . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 59 Loading Submission Groups . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 59 Loading Drillable Region Definitions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 60 Extracting Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 61
iv
Contents
Copying Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 63 Copying Line Item Detail . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 65 Copying Intercompany Transactions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 66 Clearing Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 66 Chapter 4. Using Explore Data on the Desktop . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 69 Starting Explore Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 69 Working with Data Grids . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 69 Selecting Explore Data Settings . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 70 Setting Grid Column Widths . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 70 Saving Data Grid Settings . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 71 Opening Data Grids . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 71 Entering or Editing Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 72 Entering Data into Summary-Level Time Periods . . . . . . . . . . . . . . . . . . . . . . . . . . . 72 Adjusting Data Using Operator Keys . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 73 Using Cell Colors in Data Grids to Determine Status . . . . . . . . . . . . . . . . . . . . . . . . . 73 Refreshing Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 74 Viewing Data in Data Grids . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 74 Viewing Calculation Status . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 74 Viewing Cell Information . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 76 Viewing Cell Adjustments . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 76 Adding Cell Text . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 77 Viewing Cell Text . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 77 Adding Line Item Detail . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 78 Viewing Line Item Detail . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 78 Running Allocations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 79 Locking and Unlocking Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 79 Running Explore Data Reports . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 80 Chapter 5. Using Data Grids on the Web . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 81 Creating Data Grids . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 81 Opening Data Grids . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 82 Data Grid Tasks . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 82 Data Grid Options . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 82 Process Management Options . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 83 Working with Data Grids . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 83 Setting Grid Rows and Columns . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 83 Setting Display Options . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 84 Saving Data Grid Settings . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 85 Creating Data Grid Folders . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 86
Contents
Loading Data Grids . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 86 Extracting Data Grids . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 87 Deleting Data Grids . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 87 Entering or Editing Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 88 Entering Data into Summary-Level Time Periods . . . . . . . . . . . . . . . . . . . . . . . . . . . 88 Filling Data Blocks . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 89 Clearing Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 89 Using Data Cell Colors to Determine Status . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 89 Refreshing Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 90 Viewing Data in Data Grids . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 91 Viewing Calculation Status . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 91 Viewing Process Level . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 92 Viewing Cell Information . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 92 Viewing Cell Adjustments . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 93 Adding Cell Text . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 93 Viewing Cell Text . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 94 Attaching Documents to Data Grids . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 94 Line Item Detail Options . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 95 Adding Line Item Detail . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 95 Viewing Line Item Detail . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 96 Viewing Cell History . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 97 Running Allocations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 97 Locking Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 97 Unlocking Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 98 Viewing Destination and Source Transactions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 99 Running Entity Transaction Detail Reports . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 99 Starting the Entity Transaction Detail Report . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 100 Report Point of View . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 100 Selecting Rows and Columns for the Report . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 100 Displaying Line Item Detail . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 102 Displaying Base Details . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 102 Displaying Source and Destination Transactions . . . . . . . . . . . . . . . . . . . . . . . . . . . 102 Linking to Journal Detail . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 102 Printing Entity Transaction Detail Reports . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 103 Drilling Through to Intercompany Transactions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 103 Drilling Through to Source Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 103 Chapter 6. Consolidating Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 105 Consolidation Process . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 105
vi
Contents
Translation Process . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 107 Calculation Process . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 108 Entering Currency Rates . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 109 Entering Percent Consolidations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 110 Calculating Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 110 Translating Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 111 Consolidation Options . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 112 Consolidate (Impacted Consolidation) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 112 Consolidate All with Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 112 Consolidate All . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 113 Consolidating Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 113 Viewing Consolidation Progress . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 114 Canceling Consolidation Tasks . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 114 Consolidation Status . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 115 Chapter 7. Using Data Forms . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 117 Working with Data Forms . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 117 Opening Data Forms . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 118 Using the Data Form Toolbar . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 118 Viewing Data Form Instructions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 119 Entering Data in Data Forms . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 119 Shortcut Menu Commands . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 120 Working with Cell Text . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 122 Entering Cell Text in Data Forms . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 122 Viewing Cell Text in Data Forms . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 122 Editing Cell Text in Data Forms . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 123 Attaching Documents to Data Forms . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 123 Entering Line Item Detail in Data Forms . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 124 Viewing Line Item Detail in Data Forms . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 125 Deleting Line Item Detail in Data Forms . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 125 Using Linked Forms . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 125 Changing the Point of View in Data Forms . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 126 Calculating Data in Data Forms . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 126 Suppressing Data in Data Forms . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 127 Adding Members to Data Forms . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 127 Printing Data Forms . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 128 Exporting or Importing Data Forms to Excel . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 129 Drilling Through to Intercompany Transactions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 129 Drilling Through to Source Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 130
Contents
vii
Chapter 8. Managing Ownership . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 131 Managing Ownership . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 131 Changing the Point of View . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 132 Setting Display Options . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 132 Filling Multiple Entities with Values . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 133 Entering Ownership Information . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 133 Calculate Ownership Process . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 135 Percent Control . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 135 Consolidation Method . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 135 Percent Ownership . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 136 Percent Consolidation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 136 Direct Percent Ownership . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 136 Calculating Ownership . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 136 Chapter 9. Managing Equity Pickup . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 139 About Equity Pickup . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 139 Examples of Equity Pickup Adjustments . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 140 Example 1: Direct Ownership . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 140 Example 2: Direct Ownership with Translation . . . . . . . . . . . . . . . . . . . . . . . . . . . . 140 Example 3: Cascading Ownership and Subholdings . . . . . . . . . . . . . . . . . . . . . . . . . 141 Example 4: Cross-Ownership . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 143 Managing Equity Pickup . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 143 Modifying the Display of the Manage Equity Pickup Table . . . . . . . . . . . . . . . . . . . . . . 144 Calculating Equity Pickup Adjustments . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 145 Printing Equity Pickup Reports . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 146 EPU Calculation Process . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 146 Chapter 10. Reporting on Financial Management Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 149 Opening Reports . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 149 Viewing Reports . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 150 Formatting System Reports . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 151 Modifying BI Publisher Templates . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 152 Applying HFM Report Style Sheets on the Desktop . . . . . . . . . . . . . . . . . . . . . . . . . 153 Retrieving Style Sheets from the Desktop . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 153 Setting Report Descriptions from the Desktop . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 154 Saving Reports . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 154 Drilling Through to Intercompany Transactions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 155 Printing Reports . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 156 Deleting Reports . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 156
viii
Contents
Chapter 11. Processing Intercompany Transactions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 159 Intercompany Transaction Module Features . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 159 Intercompany Transaction Security Roles . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 160 Sample Intercompany Transactions Task Flow . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 161 Intercompany Transaction Load Files . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 162 Section Headers in the Load File . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 162 Special Keywords in the Load File . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 163 Intercompany Transaction File Example . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 163 Load Methods . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 164 Loading Intercompany Transactions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 165 Extracting Intercompany Transaction Files . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 166 About the Process Transactions Window . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 166 Creating Intercompany Transactions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 167 Viewing Intercompany Transactions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 170 Selecting an Entity and Partner . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 171 Displaying Transaction Columns . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 171 Displaying Transaction Rows . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 172 Viewing Partner Entity Transactions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 173 Editing Intercompany Transactions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 174 Assigning Reason Codes to Intercompany Transactions . . . . . . . . . . . . . . . . . . . . . . . . . 174 Matching Intercompany Transactions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 175 Auto-Match Process . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 175 Auto-Matching Intercompany Transactions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 179 Creating Auto-Match Templates . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 179 Manually Matching Transactions with Tolerance Amount . . . . . . . . . . . . . . . . . . . 180 Manually Matching Transactions without Tolerance Amounts . . . . . . . . . . . . . . . . . 182 Generating Adjustments for Transaction Differences . . . . . . . . . . . . . . . . . . . . . . . . 183 Matching Status . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 183 Match Code . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 184 Unmatching Intercompany Transactions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 185 Posting Intercompany Transactions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 185 Posting Process . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 186 Posting to Flow Accounts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 187 Viewing Posted Status . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 187 Unposting Intercompany Transactions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 187 Viewing Intercompany Transaction Progress . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 188 Deleting Intercompany Transactions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 188 Reporting on Intercompany Transactions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 189 Running Transaction Detail Reports . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 189
Contents
ix
Displaying Transaction Report Columns . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 190 Displaying Transaction Report Rows . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 192 Running Matching Reports . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 192 Selecting Matching Report Options . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 193 General Options . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 193 Account Options . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 194 Display Options . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 194 Running a Matching Report by Account . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 194 Running a Matching Report by Transaction ID . . . . . . . . . . . . . . . . . . . . . . . . . . . . 195 Drilling Through to Transaction Details . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 196 E-mail Alerts for Intercompany Transactions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 197 Chapter 12. Using Journals . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 199 About Journals . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 199 Journal Security Roles . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 200 Setting Up Journals . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 200 Starting Set Up Journals on the Desktop . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 201 Using the Templates Process Bar on the Desktop . . . . . . . . . . . . . . . . . . . . . . . . . . 201 Using Journal Templates . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 201 Creating Standard Journal Templates . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 201 Creating Recurring Templates . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 203 Viewing Template Lists . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 205 Displaying Journal Template Columns on the Desktop . . . . . . . . . . . . . . . . . . . . . . 205 Selecting Column Sort Order on the Desktop . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 206 Displaying Journal Template Columns on the Web . . . . . . . . . . . . . . . . . . . . . . . . . 206 Filtering Journal Template Lists on the Web . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 207 Editing Journal Templates . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 207 Printing Journal Templates on the Web . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 208 Deleting Journal Templates . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 208 Managing Journal Periods . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 209 Viewing Periods . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 209 Opening and Closing Periods . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 209 Processing Journals . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 210 Starting Process Journals . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 211 Using the Journals Process Bar on the Desktop . . . . . . . . . . . . . . . . . . . . . . . . . . . . 211 Creating Journals . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 212 Creating Auto-reversing Journals . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 214 Creating Journals Using Recurring Templates . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 216 Scanning Journals . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 217
Contents
Journal Status . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 218 Managing Journal Groups . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 218 Creating Journal Groups . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 218 Removing Journal Groups . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 219 Viewing Journal Lists . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 219 Displaying Journal Columns on the Desktop . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 220 Selecting Column Sort Order on the Desktop . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 220 Filtering Journal Lists on the Desktop . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 221 Displaying Journal Columns on the Web . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 221 Filtering Journal Lists on the Web . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 222 Editing Journals . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 222 Selecting Dimension Members for Journal Detail . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 223 Collapsing the Grid Columns on the Desktop . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 225 Expanding the Grid Columns on the Desktop . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 225 Copying and Pasting Cells . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 226 Submitting Journals . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 226 Unsubmitting Journals . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 227 Approving Journals . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 228 Rejecting Journals . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 229 Rejecting Submitted Journals . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 229 Rejecting Approved Journals . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 230 Posting Journals . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 231 Unposting Journals . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 232 Reviewing Journals . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 233 Journal Validation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 234 Viewing Automated Consolidation Journals . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 235 Running Journal Reports . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 236 Running Journal Reports on the Desktop . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 236 Selecting Columns for Journal Reports . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 236 Sorting Columns for Journal Reports . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 237 Running Journal Reports on the Web . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 237 Displaying Columns for the Report . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 238 Filtering Journals for Reports . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 239 Saving Journal Reports . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 239 Printing Journal Reports . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 240 Printing Reports for Individual Journals . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 240 Deleting Journals . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 241
Contents
xi
Chapter 13. Using Process Management . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 243 About Process Management . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 243 Enabling Process Management . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 243 Accessing Process Units . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 244 Process Management Security Roles . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 244 Process Levels . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 245 Process Levels for Summary Time Periods . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 246 Review Levels and Submission Phases . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 246 Starting Process Management . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 246 Using Process Control . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 247 Process Control Tasks . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 248 Selecting the Data View . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 249 Selecting Entities for Process Control . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 249 Selecting Multiple Rows for Process Control . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 250 Setting Process Control Options . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 250 Displaying Multiple Phases in Process Control . . . . . . . . . . . . . . . . . . . . . . . . . . . . 254 Using the Process Control Toolbar . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 255 Viewing the Process Control Summary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 255 Viewing the Pass or Fail Status . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 256 Viewing Validation Detail . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 257 Viewing Calculation Status . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 258 Viewing Journal Status . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 258 Viewing Rate Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 259 Viewing Manage Ownership Information . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 259 Attaching Documents to a Process Unit . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 260 Calculating Data from Process Control . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 260 Translating Data from Process Control . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 260 Consolidating Data from Process Control . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 261 Promoting Process Units . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 261 Submitting Process Units . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 262 Approving Process Units . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 263 Rejecting Process Units . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 264 Signing Off on a Process Unit . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 265 Publishing Process Units . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 266 Locking and Unlocking Process Units . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 267 Viewing Process Review History . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 267 E-mail Alerts for Process Control . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 268 Process Management Validation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 268 Validation for Promotion . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 269
xii
Contents
Validation for Rejection . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 269 Process Management and Consolidation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 269 Chapter 14. Using E-mail Alerts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 271 About E-mail Alerts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 271 Generating Alerts for Intercompany Transactions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 272 Sending E-mail Alerts from the Intercompany Transactions Process Window . . . . . . 272 Sending E-mail Alerts from the Intercompany Transactions Monitor Window . . . . . 273 Sending E-mail Alerts from Intercompany Transactions Reports . . . . . . . . . . . . . . . 274 Sending E-mail Alerts from Intercompany Partner Matching Reports . . . . . . . . . . . . 274 Intercompany Transactions E-mail Content . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 275 Receiving Intercompany Transaction E-mail Alerts . . . . . . . . . . . . . . . . . . . . . . . . . 276 Generating Alerts for Process Control . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 276 Process Control E-mail Content . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 277 Receiving Process Control E-mail Alerts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 278 Chapter 15. Automating Tasks . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 279 Overview . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 279 Financial Management Tasks Available for Automation . . . . . . . . . . . . . . . . . . . . . . . . . 280 Prerequisites for Task Automation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 280 Managing Taskflows . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 280 Creating Taskflows . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 281 Adding Stages . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 281 Financial Management Stage Actions and Parameters . . . . . . . . . . . . . . . . . . . . . . . 284 Shared Services Stage Actions and Parameters . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 289 Adding Links . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 289 Viewing Taskflows . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 290 Editing Taskflows . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 290 Copying Taskflows . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 291 Deleting Taskflows . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 291 Running Taskflows Manually for Testing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 291 Managing Access Permissions to Taskflows . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 292 Assigning Access Permissions to Taskflows . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 293 Editing Permissions to Taskflows . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 293 Deleting Permissions to Taskflows . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 294 Viewing Taskflow Status . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 294 Stopping Active Taskflows . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 296 Viewing the Taskflow Participant Details . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 297 Glossary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 299
Contents
xiii
Index . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 323
xiv
Contents
Documentation Accessibility
Our goal is to make Oracle products, services, and supporting documentation accessible, with good usability, to the disabled community. To that end, our documentation includes features that make information available to users of assistive technology. This documentation is available in HTML format, and contains markup to facilitate access by the disabled community. Accessibility standards will continue to evolve over time, and Oracle is actively engaged with other market-leading technology vendors to address technical obstacles so that our documentation can be accessible to all of our customers. For more information, visit the Oracle Accessibility Program Web site at http://www.oracle.com/accessibility/.
15
16
Documentation Accessibility
1
In This Chapter
Financial Management Features..................................................................................................17 Architecture.........................................................................................................................18 Performance Management Architect .............................................................................................18 EPM Workspace ....................................................................................................................18 Related Products...................................................................................................................18 Financial Management Dimensions ..............................................................................................19 User-Defined Elements ............................................................................................................21
One unified view of enterprise financial information consolidates key performance and operating metrics from global sources in a scalable, Web-based application. Virtual close features trim days and weeks off your close cycle using Web-based intercompany reconciliations and a consistent set of data and business measures. Powerful multidimensional analysis identifies and reports new sources of profitability and cash flow at corporate, cost center, product, brand, customer, and channel levels. Flexible what if scenario management feature dynamically consolidates and reports all financial budgets, forecasts and plans, producing new statements as assumptions and facts change. High-volume, preformatted reports deliver timely, accurate financial information for internal management and external regulatory and government bodies from the same application. Prepackaged features are deployed out-of-the-box, quickly and cost-effectively, including features such as world-class allocations, multicurrency translations, and robust data integration with legacy applications, ERP, and CRM systems. Customizable and extensible application solves your issues quickly and cost-effectively, using industry standard tools.
17
Architected for the Web so users can easily and securely access global financial information from any location, using a standard Web browser. Relational data storage ensures mission critical data is available to users 24x7x365.
Architecture
Financial Management is designed to operate as a multitier system.
l
The client tier contains the user interface and the ability to communicate with the application tier. You can display data and metadata, and enter data in this tier. On the Web server tier, you access the Web-enabled portions of Financial Management. The middle tier contains the domain intelligence and connections to the relational database. The data tier contains the relational database and all Financial Management data and metadata.
EPM Workspace
Financial Management is available within Oracle Enterprise Performance Management Workspace, Fusion Edition. For information on tasks performed in EPM Workspace, such as preferences or features in the Navigate, Favorites, Manage, or Tools menu, see the Oracle Enterprise Performance Management Workspace User's Guide, Administrators Guide and Web help.
Related Products
You can use the Extended Analytics module to send data to a database in Oracle Essbase. You can also drill down from data grids and data forms to view data details in Oracle Hyperion Financial Data Quality Management, Fusion Edition. In addition, you can work with data and data forms in Oracle Hyperion Smart View for Office, Fusion Edition.
18
Scenario Dimension
The Scenario dimension represents a set of data, such as Budget, Actual, or Forecast. For example, the Actual scenario can contain data from a general ledger, reflecting past and current business operations. The Budget scenario can contain data that reflects the targeted business operations. The Forecast scenario typically contains data that corresponds to predictions for upcoming periods. A Legal scenario can contain data calculated according to legal GAAP format and rules. You can define any number of scenarios for an application and define attributes for Scenario dimension members, such as the default frequency, the default view, and zero data settings.
Year Dimension
The Year dimension represents the fiscal or calendar year for data. An application can contain data for more than one year. You specify a year range when you create the application and select a year from the Year dimension to process data.
Period Dimension
The Period dimension represents time periods, such as quarters and months. It contains time periods and frequencies by displaying the time periods in a hierarchy. For example, if the Actual scenario maintains data on a monthly basis, generally 12 periods of data are available for this scenario in a year. Financial Management supports years, months, and weeks for the period dimension. It does not support days for the dimension.
19
Entity Dimension
The Entity dimension represents the organizational structure of the company, such as the management and legal reporting structures. Entities can represent divisions, subsidiaries, plants, regions, countries, legal entities, business units, departments, or any organizational unit. You can define any number of entities. The Entity dimension is the consolidation dimension of the system. Hierarchies in the Entity dimension reflect various consolidated views of the data. Various hierarchies can correspond to geographic consolidation, legal consolidation, or consolidation by activity. All relationships among individual member components that exist in an organization are stored and maintained in this dimension. Entities in an organization are dependent, base, or parent entities. Dependent entities are owned by other entities in the organization. Base entities are at the bottom of the organization structure and do not own other entities. Parent entities contain one or more dependents that report directly to them. You define attributes for Entity dimension members, such as the default currency and security class, and to specify whether the entity allows adjustments and stores intercompany detail.
Value Dimension
The Value dimension represents the different types of values stored in your application, and can include the input currency, parent currency, adjustments, and consolidation detail such as proportion, elimination, and contribution detail. For example, the Entity Currency member stores the value for an entity in its local currency. The Parent Currency member stores the value for an entity translated the to currency of its parent entity.
Account Dimension
The Account dimension represents a hierarchy of natural accounts. Accounts store financial data for entities and scenarios in an application. Each account has a type, such as Revenue or Expense, that defines its accounting behavior. You define attributes for Account dimension members, such as the account type, the number of decimal places to display, and whether the account is a calculated, consolidated, or intercompany partner account.
Intercompany Dimension
The Intercompany dimension represents all intercompany balances that exist for an account. This is a reserved dimension that is used in combination with the Account dimension and any custom dimension. Financial Management can track and eliminate intercompany transaction details across accounts and entities. You can also run intercompany matching reports to view intercompany transactions.
20
View Dimension
The View dimension represents various modes of calendar intelligence; for example, Periodic, Year-to-Date, and Quarter-to-Date frequencies. If you set the view to Periodic, the values for each month are displayed. If you set the view to Year-to-Date or Quarter-to-Date, the cumulative values for the year or quarter are displayed.
Custom Dimensions
Four custom dimensions are available for analysis of detailed data. You can use custom dimensions to store additional details associated with accounts, such as products, markets, channels, balance sheet movement, or types of elimination. For example, custom dimensions could include Product Line, Region, Channel, or Customers.
User-Defined Elements
Many elements in Financial Management are user-defined. For example, when you create a journal, you give the journal a label and a description. User-defined elements, the minimum and maximum length for each element, and additional restrictions are listed below. The table groups the elements by the modules in which they are found.
Table 1
1 1
20 80
None
l
Must contain only alphanumeric characters. Cannot start with a number. Cannot contain spaces, symbols, or diacritical marks such as umlauts. Must contain only alphanumeric characters. Cannot start with a number. Cannot contain spaces, symbols, or diacritical marks such as umlauts.
View label
10
User-Defined Elements
21
Min. length 0 0
Max. length 40 40
10
Must contain only alphanumeric characters. Cannot start with a number. Cannot contain spaces, symbols, or diacritical marks such as umlauts. Note: Application labels are not casesensitive. For example, App1 and APP1 are considered the same application label.
40
80
Must be unique. The label can contain up to 80 characters including spaces, but cannot start with a space. Note: If you are using an Oracle database, member labels cannot contain spaces. You cannot use the following characters in the member name:
l l l l l l l l l
period ( . ) plus sign ( + ) minus sign ( - ) asterisk ( * ) forward slash ( / ) number sign ( # ) comma ( , ) semicolon ( ; ) at symbol ( @ )
22
Element
Min. length
Max. length
Restrictions
l
Note: You cannot use ALL as the name of an entity. Member description Alias label Security Security class Journals Journal label 1 80 Cannot include the following characters:
l l l l l l l l l l
0 0
40 80
80
None
period ( . ) plus sign ( + ) minus sign ( - ) asterisk ( * ) forward slash ( / ) number sign ( # ) comma ( , ) semicolon ( ; ) at symbol ( @ ) double quotation mark (") curly brackets ( { } ) Note: If you are using an Oracle database, journal labels cannot contain spaces.
Journal description Journal group Journal line item description Load/Extract Delimiter character
0 0 0
255 30 50
Must be one of the following characters and cannot be used in the file or in the file name:
l
comma ( , )
User-Defined Elements
23
Element
Min. length
Max. length
Restrictions
l l l l l l l l l l l
tilde ( ~ ) at sign ( @ ) dollar sign ( $ ) percent sign ( % ) ampersand (&) carat ( ^ ) line ( | ) colon ( : ) semicolon ( ; ) question mark ( ? ) back slash ( \ ) Note: The ampersand ( & ) is not a valid delimiter for metadata .app files. You must use the same delimiter character throughout the file. Using different delimiter characters within the same file causes an error when you load the file.
Data grids Cell description Line item detail Annotation Decimal character 1 1 0 1 1900 80 255 1 None None None The following characters are invalid decimal characters for data grids:
l l l l
Documents Document names (including folder and report names) 1 16 The following characters are invalid characters for document names:
l l l l
24
Element
Min. length
Max. length
Restrictions
l l l l l l l
forward slash ( / ) number sign ( # ) comma ( , ) semicolon ( ; ) colon ( : ) at sign ( @ ) double quotation mark (") curly brackets ( { } ) line ( | ) less than sign ( < ) greater than sign ( > ) period (.) at the end of a document name Note: Document names also cannot contain trailing or leading white space.
l l l l l
User-Defined Elements
25
26
2
In This Chapter
Starting Financial Management ..................................................................................................27 Opening Applications ..............................................................................................................28 Setting User Preferences ..........................................................................................................29 Enabling Multibyte Language Date and Time Formats .........................................................................32 Using Financial Management Help ...............................................................................................32 Exiting Financial Management ....................................................................................................33 Using Financial Management on the Desktop...................................................................................33 Using Financial Management on the Web .......................................................................................37
Double-click the Financial Management icon. Select Start, then Programs, then Oracle EPM System, then Financial Management and then Financial Management.
2 For Domain, enter the name of the domain to which to log on. 3 For User, enter your username. 4 For Password, enter the password that corresponds with your username.
27
5 Optional: Select Remember Password so that the system stores your password and you do not need to enter
it each time that you log on.
6 Click Logon.
application server is listening. For Apache Tomcat, the default port for EPM Workspace is 19000.
3 Enter your system user name. 4 Enter your system password. 5 Click Log On. 6 In EPM Workspace, select Navigate, then Applications, then Consolidation and select an application.
Opening Applications
An application is a set of dimensions and dimension members that meet a set of analytical or reporting requirements. For example, you can have an application to report on tax data and a separate application for sales analysis. You can open one application for each Financial Management session that you are running. However, you can have several Financial Management sessions open, with different applications open on each session.
28
Windows Procedure
To open applications:
1 From the desktop navigation frame, select Open Application. 2 From Cluster, select the application server or cluster on which the application to open is running.
If the server cluster is not listed, you may need to register it. a. b. c. d. Click .
Select Use Automatic Load Balancing to automatically balance the load among servers or Use One Server Only. For Server, enter the name of one of the servers in the cluster that you want to register. Click Register, and click Close.
3 Click Connect.
When you connect to an application server or cluster, the system authenticates your username and password. If you enter an invalid username-password combination, you cannot access or create applications.
To open applications:
1 Select File, then Open, then Applications, and then Consolidation. 2 From the list of applications, select the application to open.
Specifying Number Formatting on page 30 Specifying Language Support on page 30 Specifying File Extract Options on page 30 Specifying Startup Options on page 30 Setting User Preferences on the Web on page 31
29
30
3 For Thousands Separator Character, enter the character to use to separate thousands.
This can be only one character. The default setting is a comma (,).
4 From Default Language for Descriptions, select the language to use for descriptions. 5 Take one of the following actions:
l
To reset the user preferences to their original values, click Restore. To save your preferences, click Save. The preferences are saved to the database for the current application.
6 Log off, and log back on for the changes to take effect.
the list of applications, and Current WebServer and Current Cluster boxes, based on the Web Server and cluster that you used at logon.
Performance Management Workspace, Fusion Edition Web Server. For details on configuration, see the Oracle Hyperion Enterprise Performance Management System Installation and Configuration Guide. b. From the List of Clusters, select a new application server cluster.
31
5 For Thousands Separator Character, enter one character to use to separate thousands. 6 From Default Language for Descriptions, select the language to use for descriptions.
Note: The languages are listed in alphabetical order.
7 Optional: For Extract Options, select Save all files in Unicode format. 8 Take one of the following actions:
l
To reset the user preferences to their original values, click Reset. To save your preferences, click Save. The preferences are saved to the database for the current application.
9 Log off, and log on again for the changes to take effect.
Install files for complex script and right-to-left languages (including Thai) Install files for East Asian (multibyte) languages
3 If the required type is not checked, select it and click Apply. The system files will be installed and a reboot
may be required afterwards.
32
Select Help then Contents from the desktop, or click the Financial Management Help icon to show the Help contents. Click Help, or select Help on This Topic to access information about a dialog box. To access help in the Web, click Help at the top of any Financial Management Web page.
To exit Financial Management, from the Financial Management Desktop, select File, then
Exit. Web Procedure
l
To log off from a Financial Management Web page, select File, then Logoff, or click from the top menu and click Yes to confirm that you want to log off. The system returns you to the Logon dialog box, so that you can log on again if necessary.
33
Select View, then Navigation Frame, or click Navigation Frame frame, or deselect to hide it. Select View, then Toolbar to show the toolbar, or deselect to hide it.
Select View, then Status Bar to show the status bar, or deselect to hide it.
34
Select Year and highlight a member from the list of years. Select Period and highlight a member from the list of periods. Select View and highlight a member from the list of views. Select Entity and highlight a member from the list of entities. Select Value and highlight a member from the list of values. Select Account and highlight a member from the list of accounts. Select ICP and highlight a member from the list of intercompany partners. Select a custom dimension tab, and highlight a member from the list of custom members.
Note: Click
to select a member list for each dimension in the point of view and select individual members from the member list.
4 Optional: To select dimension members to display on the data grid rows and columns, select the check boxes
next to the dimension members.
Tip: Click Select All
to check all dimension members, or Deselect All dimension members for the grid.
to clear all
5 Optional: To display dimension descriptions in addition to labels, select Show Descriptions. 6 Click OK.
3 From Select Member List, select a member list. 4 Optional: For Parent Member, enter a parent member to further filter the list. This can be used as a starting
point for the list.
35
Note: This option is available only if the application is set up for Organization by Period.
4 Select Active Entities Only. 5 Select the scenario, year, and period. 6 Click OK.
36
Tip: You can use a partial name or description. For example, you can enter Qu to find
4 Click Next,
member.
, to display the next dimension member that contains the search criteria that you entered. , to view a previous
5 Continue until you find the appropriate dimension member, or click Previous, 6 Click OK.
The current dimension is represented by text, while the other dimensions are represented by links. The current dimension is enclosed by small, triangular characters. If you have set an alias for a custom dimension, the alias is displayed under the dimension name.
37
Tip: If you click a folder symbol, the folder name is displayed in the text box next to the member
list, so that you do not need to type the name. If additional members are available for the dimension, you can expand them by clicking the plus (+) sign.
4 To select a member from a member list other than the default of Hierarchy, select the member list from
5 Optional: To filter the list using a top member, type a member for Selector, and click Enter.
The updated list displays the top member and its descendants.
6 Optional: To display dimension descriptions in addition to labels, select Description. 7 Optional: To view only active entities, select Filter Active Entities only.
Note: This option is available only if the application is set up for Organization by Period.
8 To select a member for another dimension, click the link for the dimension at the top of the page and repeat
these steps.
Tip: To clear a dimension member, click Clear.
38
Member lists display a subset of related members that belong to one dimension. Using member lists can reduce the time that you spend browsing the hierarchy of members. System-defined member lists, such as Descendants and Children are enclosed in brackets ([ ]).
Tip: If you click a folder symbol, the folder name is displayed in the text box next to the member
3 Highlight the members to move them to Selected Values, or click Check All
arrow.
4 Optional: To move a selected member up or down in the list, highlight the member and click the up or down 5 Optional: To validate the members or member list syntax, click Validate
Selector.
Tip: The Hierarchy member list contains all members of a dimension.
6 To select a member from a member list other than the default of Hierarchy, select the member list from
7 Optional: To filter the list using a top member, type a member name for Selector and click Enter.
The updated list displays the top member and its descendants.
8 Optional: To display dimension descriptions in addition to labels, select Description. 9 Optional: To view only active entities, select Filter Active Entities only.
Note: This option is available only if the application is set up for Organization by Period.
39
The option to filter active entities is enabled only after you select a scenario, year, and period in the point of view. You can view or change the value for Active accounts through data grids. In the point of view, you must select Active as the account, and System as the Intercompany Partner dimension list.
5 Click OK.
5 Continue until you find the appropriate dimension member, or click Find Previous Value
member.
to view a previous
6 When you find and select the dimension member, click OK.
Managing Documents
From the Manage Documents dialog box, you can work with task lists, data grids, data forms, reports, links, related content or custom documents. From the tabs in the Manage Documents dialog box, you can create, edit, load, extract, and delete documents, add them to your Favorites,
40
or create document folders. You can create public documents that can be shared with other users. You can also create private documents, which are displayed in the Documents list of the user who created them. You can select the All tab to work with different types of documents. When you use the All tab, you can delete or extract documents, create folders for them, or add them to Favorites all at once instead of selecting each individual document tab.
Figure 1 Manage Documents Dialog Box
When you load or create files of varying case sensitivity, the system sorts the file names alphabetically in the Documents list. File names that start with uppercase letters are displayed alphabetically first in the list before those that start with lowercase letters.
41
5 For Content Type, select the type of documents for the folder.
Tip: If the folder will be used for all documents, select All.
7 From Security Class, select the security class to assign to the folder.
Note: Users of this folder must have access rights to the specified security class. This option is
only available if you have ALL access to at least one security class.
8 Click OK.
To show private documents, click Show Private Docs. The documents are indicated by an icon next to the name ( ). To hide private documents, click Hide Private Docs.
42
4 Click View.
The page opens in a new browser window to test connectivity.
5 To display the document or page within the current page, select Task List opens link within same page.
Note: If you do not select this option, the document or page opens in a separate browser window.
6 Optional: Select Prompt user before rendering link so that the system prompts you with a confirmation dialog
box before opening the document.
7 Optional: Select Include Single Sign On information in page request so that the single sign-on information
is appended to the URL to enable you to sign on when you open the link.
8 To save the document in the task list, click Save. 9 To close the Links window, click Cancel.
When you return to the Documents frame, the link is added.
on information is appended to the URL to enable you to sign on when you open the link.
43
3 From a Financial Management application, select Links, click New, and paste the document link.
Note: When you paste the link, make sure that you select Include Single Sign On information
in page request so that the single sign-on information is appended to the URL to enable you to sign on when you open the link. If you use the Firefox Web browser, you must enable the Clipboard feature before you can copy documents.
4 Set the Boolean value to true for Firefox or enter true or 1 for Mozilla. 5 Open a data form and select Administration, then Copy Data Link. 6 At the prompt to allow access to the clipboard, click Allow.
Set up a link to the related content resource server. You use the Financial Management configuration utility to set up the link.
44
Configure external authentication. If you are not using external authentication, the Related Content tab is not displayed in Manage Documents.
See the Oracle Hyperion Enterprise Performance Management System Installation and Configuration Guide.
Note: If external authentication is not enabled, the Related Content tab is not displayed.
3 Click New. 4 For Resource Server, select the resource document to access.
Tip: You can drill down to different directories by double-clicking folders.
5 Optional: To open the selected document, select When in a task list, open the selected document in the
client area.
Note: If you do not select this check box, the document that you select opens in a separate pop-
up window. You can select Close to close Related Content, or you can save the document.
e.
Optional: Select Private if you do not want to display this task list to other users.
Note: By default, if no security classes are available, the Private check box is grayed out
f. g.
To overwrite a task list format, select Overwrite existing file. Click OK.
Creating Task Lists on page 46 Editing Task Lists on page 47 Deleting Task Lists on page 48
46
Select File, then New, and then Tasklist. Select Administration, then Manage Documents, then Tasklists, and click New Tasklist. Click Manage Documents Folder Tasklist Custom Documents Data Forms Data Grids Links Related Content Reporting Tasks , select Tasklists, and click New Tasklist.
3 Select the items to add, and click Add to Tasklist. 4 Optional: To reorder items in a task list, highlight the item to move, and click the Up or Down arrow to change
the sequence.
Tip: To remove items from a task list, select the item and click Remove.
5 Click Save.
Note: If you do not want to save your changes, click Close.
colon (:); semi-colon (;), less than or greater than symbols (< >)..
7 Optional: For Description, enter a description. 8 From Security Class, select a security class, or use the Default security class. 9 Optional: Select Private if you do not want to display this task list to other users. 10 To overwrite a task list format, select Overwrite existing file. 11 Click OK. 12 Click Save.
47
Note: Removing items from a task list only removes them from the task list that you selected.
4 To reorder items, click the item to move, and click the Up or Down arrow to change the sequence. 5 Optional: To make the task list your default, select This is my default tasklist. 6 When you finish editing items, click Save. 7 Click OK.
Managing Favorites
You can add documents or task lists that you use frequently to your list of Favorites. You can view the list of documents marked as favorites, quickly access them from the Favorites section, or remove items as favorites. Any changes that you make to the Favorites list are saved when you log out of the application. See these procedures:
l
48
To add favorites:
1 Select Administration, then Manage Documents, or click Manage Documents
tab from which to add favorites. and select the documents
Removing Favorites
You can remove items from your list of Favorites.
You should review the error log frequently to ensure that the log tables growth is limited. Oracle recommends that you perform regular log maintenance, and that the log not exceed 500,000 messages.
Retrieving System Messages on page 50 Viewing and Printing System Messages on page 50 Deleting System Messages on page 50
49
Enter a start date. Enter an end date. Enter the server name. Enter the application name.
Note: You can leave the server name and application name blank to view system messages
3 Click View.
To delete individual messages, select the check box next to each message to delete, and click Delete. To delete all system messages, click Delete All.
50
3
In This Chapter
Managing Data
Working with Data Files ...........................................................................................................51 Load Methods ......................................................................................................................53 Loading Data .......................................................................................................................56 Loading Submission Groups ......................................................................................................59 Loading Drillable Region Definitions .............................................................................................60 Extracting Data .....................................................................................................................61 Copying Data .......................................................................................................................63 Clearing Data .......................................................................................................................66
Create a data file and load it into an application. Enter data in a data grid.
Creating and loading a data file is an alternative to manually entering data in a data grid. You create data files in an ASCII format supporting multibyte character sets (MBCS) or a file encoded with the Unicode format. By default, data files use the DAT file extension. A data file can contain these sections:
l
Sample data files are installed with Financial Management and are located in the Hyperion_Home\FinancialManagement\SampleApps directory.
51
Table 2
Data File Sections Description Specifies the order in which dimension members are displayed. The following syntax specifies the default column order:
!Column_Order = Scenario, Year, Period, View, Entity, Value, Account, ICP, Custom1, Custom2, Custom3, Custom4
You can change the column order to meet your needs. You can specify multiple Column Order sections in the data file. Each subsequent Column Order section overrides the previously defined section and the data within each section must use the defined column order. If you do not specify the scenario, year, or period dimensions in the column order sequence, it is assumed that they are specified in a separate section of the data file. If you do not include the ICP or custom dimensions in the sequence, they are assumed to be ICP None, and None respectively. View Specifies the default view for all data following it. You can specify multiple View sections in the data file; each section must start with a valid View dimension. Each subsequent View section overrides the previously defined section. If you do not specify a View section, the view must be specified in the point of view. Specifies numeric amounts for valid input cells. If accounts do not accept line item detail, you must load data into them. The syntax for this section is as follows:
<Scenario>; <Year>; <Period>; <View>;_ <Entity>; <Value>; <Account>; <ICP>;_ <Custom1>; <Custom2>; <Custom3>;_ <Custom4>; <Data>
Data
Note: Zeros are stored as data. Loading zeros into an application is not recommended because zeros can increase the size of the database and impact performance. You can specify several Data sections throughout the data file. If you place the Data section before the first Column Order section, the default column order is used. Ownership data is used to calculate the ultimate ownership and consolidation percentages for the dependents of the selected parent. Ownership information is managed within the ICP dimension by way of a member list called System that is automatically generated by the system. For percent consolidation data, you must know an entity members parent in the hierarchy. The parent is required for percent consolidation data but is ignored in all other circumstances. Line Item Detail You load line item detail to accounts that support line item detail and are valid dimension combinations. A line item is represented by a delimited pair that consists of a description and a value. You can specify several Line Item Detail sections throughout the data file. The following syntax specifies a sample point of view, line item detail, and line item value:
!Line_Item_Detail Actual; 2009; July; Periodic;_ Connecticut; USD; Salaries; [ICP None];_ Golfballs; Customer2; [None]; Increases;_ John Doe; 5000
You must load line item detail to one period. You cannot load it to a range of periods. The scenarios default view (YTD or Periodic) determines how the line item detail is loaded. The line item detail description cannot be blank, but you can leave the line item detail value blank. Descriptions do not need to be unique. If you do not enter a description and value pair after the point of view settings, an error occurs and you are prompted to enter a description for the line item detail. Note: Use only double quotation marks ( ) in line item detail. Single quotation marks ( ) are not supported.
52
Managing Data
Dimension Groupings
You can group sets of data by fixing one or more dimensions. One dimension must always remain unfixed. For every dimension except Period, you must specify one member. For the Period dimension, you can specify one or a range of periods. You can specify groupings for dimensions as many times as necessary throughout the data file. However, they must agree with the respective column order sequence. Each subsequent occurrence of a grouping overrides the previous grouping.
Note: You can use any of the valid characters as long as the character is not used in the file name
or in any other way in the file. For example, if you are using the ampersand ( & ) in an entity member name, you cannot use the ampersand as the delimiter character. You must use the same delimiter character throughout the file. Using different delimiter characters within the same file causes an error when you load the file.
!column_order = scenario, year, period, view, entity, value, account, ICP, custom1, custom2, custom3, custom4 !DATA Budget data for six months. Budget; 2009; July; Periodic; Connecticut; USD; Sales;_ [ICP None]; GolfBalls; Customer2; [None]; Increases; 1200000 Budget; 2009; August; Periodic; Connecticut; USD; Sales;_ [ICP None]; GolfBalls; Customer2; [None]; Increases; 1100000 Budget; 2009; September; Periodic; Connecticut; USD; Sales;_ [ICP None]; GolfBalls; Customer2; [None]; Increases; 11500000 Budget; 2009; October; Periodic; Connecticut; USD; Sales;_ [ICP None]; GolfBalls; Customer2; [None]; Increases; 1000000 Budget; 2009; November; Periodic; Connecticut; USD; Sales;_ [ICP None]; GolfBalls; Customer2; [None]; Increases; 1250000 Budget; 2009; December; Periodic; Connecticut; USD; Sales; [ICP None]; GolfBalls; Customer2; [None]; Increases; 1200000
Load Methods
Several options are available for loading data into an application. You can merge, replace, or accumulate the data into the application. You select one of these options for each load process.
Note: You cannot load calculated data into an application.
Load Methods
53
Merge
Select this option to overwrite the data in the application with the data in the load file. For each unique point of view that exists in the data file and in the application, the value in the data file overwrites the data in the application.
Note: If the data load file includes multiple values in the file for the same point of view, the
system loads the value for the last entry. The data in the application that is unaffected by the data load file remains in the application. If you select the Accumulate Within File option in conjunction with the Merge option, the system adds all values for the same point of view in the data file, and overwrites the data in the application with the total. For each unique point of view that is in the data file but does not have a value in the application, the value from the data file is loaded into the application.
Replace
Select this option to replace the data in the application with the data in the load file. For each unique combination of scenario, year, period, entity, and value in the data file, the system first clears all corresponding values from the application, then loads the value from the data file.
Note: If you have multiple values in the file for the same unique combination of dimensions,
the system loads only the value for the last entry. If you select the Accumulate Within File option in conjunction with the Replace option, the system clears the value from the application, adds all values for the same point of view in the data file, and loads the total. You can achieve the same result as using the Replace option with the Accumulate Within File option by using the Database Management module. You can organize the data in the file into groups based on Scenario, Year, Entity, Value, and Period. Use the Clear Data tab in the Database Management module to clear each unique combination of these dimensions, selecting all accounts including system accounts. Enter the data manually in a data grid, or load or copy the data into the application using the Merge or Accumulate load options. When you perform the Clear operation for a period in a subcube, data, cell text, and line item detail are cleared, but cell attachments are not cleared.
Note: You may need to create several small files to load a data file using the Replace mode,
especially if the data is very large or if the file contains ownership data. An error message is displayed if the file is too large when you try to load it.
54
Managing Data
Replace by Security
Select this option to perform a data load in Replace mode in which only the members to which you have access are loaded. This option enables you to perform a data load in Replace mode even if you do not have access to all accounts. When you perform the Clear operation for a period in a subcube, only the cells to which you have access are cleared. Data, cell text, and line item detail are cleared, but cell attachments are not cleared.
Accumulate
Select this option to accumulate the data in the application with the data in the load file. For each unique point of view that exists in the data file and in the application, the value from the load file is added to the value in the application.
Note: Data for system accounts is not accumulated.
Accumulate Within File You can use the Accumulate Within File option in conjunction with the Merge and Replace options. This option accumulates the data in the file first and loads the totals into the application based on the load option selected. File Contains Ownership Data If the file that you are loading contains ownership data, you must indicate this by selecting File Contains Ownership Data. If you do not select this option and the data file contains ownership data or shares data, an error occurs when you load the file.
Load Example
The following example shows how the load options work. The following data exists in the application for the Sales and Purchases accounts:
...Sales;... 15 ...Purchases;... 10
The following table displays the effect that load mode selections have on data loaded into an application:
Load Methods
55
Table 3
Load Options Result in Application Load Data Sales NODATA Because it is the last entry in the file, NODATA overwrites the Sales value. Purchases 10 This account does not exist in the file. Accumulate Within File Selected Sales 75 The values in the file are added up to equal 75. This value (75), overwrites the value of 10 in the application. 75 In the application, the value for this account is cleared. The values in the file are added up to equal 75. 75 is entered as the value. N/A Purchases 10 This account does not exist in the file.
NODATA In the application, the value for this account is cleared. Because it is the last entry in the file, NODATA is entered as the value. 90 The system adds the values for the same POVs in the data file and adds the total to the value in the application. Therefore, 75 is added to 15.
NODATA In the application, the value for this account is cleared. Because there is no data for this account in the file, NODATA is entered as the value. 10 There are no values in the file to add to the value.
NODATA In the application, the value for this account is cleared. There are no values in the file for this account, so NODATA is entered as the value. N/A
Accumulate
Loading Data
You should not run reports, books, or batches while data is being loaded. In the Web, specify the name of the data file to load, and make sure that you set up a directory for the Web log file. Oracle recommends that you add Financial Management to the exceptions for your Web popup blocker. When you perform some Financial Management tasks on the Web, such as loading data, a status window pops up showing the task status. If you have a pop-up blocker enabled on your computer, the status window is not displayed. In Windows, specify the name of the data file to load and a log file name.
Note: The log file stores information about the load process; for example, syntax errors and
invalid records.
56
Managing Data
Windows Procedure
To load data:
1 Open the application to which to load data. 2 From the navigation frame, select Load Data. 3 For Data Filename, enter the file name, or click
to find the file.
Note: You can click View to display the contents of the data file that you specified. By default,
data files use the DAT file extension. The load process accepts other file extensions such as TXT or CSV, however, Oracle recommends that you use the DAT file extension.
Merge to overwrite data in the application Replace to replace data in the application Replace by Security to replace data to which you have access, depending on your security rights Accumulate to add data to data in the application See Load Methods on page 53.
6 Optional: Select Accumulate Within File to add up multiple values for the same cells in the load file before
loading them into the application.
7 Optional: Select File Contains Ownership Data if the load file contains ownership data, such as shares owned.
Caution!
If ownership data is included in the file, you must select this check box, or an error occurs when you load the file.
8 For Delimiter Character, enter the character used to separate data in the file. Valid characters are as follows:
, ~ @ $ % & ^ | : ; ? \
Note: You can use any of the characters above as long as the character is not used in the file
name or in any other way in the file. For example, if you are using the ampersand ( & ) in an entity member name, you cannot use the ampersand as the delimiter character.
any errors.
10 Click Load.
Loading Data
57
Web Procedure
To load data:
1 Open the application into which to load data. 2 Select Browser View. 3 In the view pane, expand Tasks and select Load Tasks. 4 Select Load Data. 5 From Delimiter Character , select the default character used to separate the data in the file. Valid characters
are as follows: , ~ @ $ % & ^ | : ; ? \
Note: You can use any of the characters above as long as the character is not used in the file
name or in any other way in the file. For example, if you are using the ampersand ( & ) in an entity member name, you cannot use the ampersand as the delimiter character.
Merge to overwrite data in the application Replace to replace data in the application Replace by Security to replace data to which you have access, depending on your security rights Accumulate to add data to data in the application See Load Methods on page 53.
7 Optional: Select Accumulate Within File to add multiple values for the same cells in the load file before
loading them into the application.
8 Select File Contains Ownership Data if the load file contains ownership data, such as shares owned.
Caution!
If ownership data is included in the file, you must select this check box, or an error occurs when you load the file.
9 Select File Contains Process Management Data if the load file contains process management submission
phases.
10 For File, enter a file name, or click Browse to locate the file.
Note: By default, data files use the DAT file extension. The load process accepts other file
extensions such as TXT or CSV, however, Oracle recommends that you use the DAT file extension.
11 Optional: To override the default load options for a particular file, select Override, and select a different
delimiter, load mode, accumulate, or ownership setting for the file.
12 Optional: Click Scan to verify that the file format is correct. 13 Click Load.
58
Managing Data
The system displays the load task progress, and a log file for each load file when the process is finished. Any data load information, including errors and invalid records, is located in the log file.
From the Progress page, view the data load progress. From the Running Tasks page, select Data Load from Task Filter , and click View to view the progress.
From the Progress page, click Stop Task for the data load. From the Running Tasks page, select the Data Load task from Task Filter and click Stop Task.
59
In Replace mode, all data for the period is cleared before new group/phase assignments are processed for that period, and new data replaces old data. Example: Scenario=Actual; Period=January has the following assignments: Phase=1, Groups=1,3,5, and Phase=2, Groups=2, 4, 6. If you load the following data:
!SUBMISSION PHASE Actual;January;1;7,8,9
All data for January (including Phase 2 assignments) is cleared, and the final result is as follows:
Scenario=Actual;Period=January Actual;January;1;7,8,9
In Merge mode, the new group/phase assignments for the period override the assignments for the same groups, but keep the assignments for other groups. If an error is detected for a period, all new assignments for that period are ignored. After you load a submission group file to an application, users using the application are notified that the system has changed and that they must log off from the application and log back on. The load format is as follows:
!SUBMISSION PHASE <scenario>;<period>;<phase#>;<group assignment>
defined display name, which then opens the specified URL, such as the FDM or ERP Integrator page. A region definition load file consists of the following information:
l
Scenario, Year, Period, Entity, Account Display Name (for cell context menu) and URL (to drill to)
Extracting Data
You can extract base-level input data and some calculated data from an application. When you extract data, it is saved to an ASCII file that supports multibyte character sets (MBCS). By default, data files use the .DAT file extension. After you extract data to a data file, you can view and modify it in a text editor. When you extract data, you must specify a member for the Scenario and Year dimensions. You can specify one or more members for the Period, Entity, and Account dimensions. You can also extract these types of calculated data:
l
Consolidated data for parent entities Base accounts and custom dimension members that are calculated by rules Parent accounts intersecting with their respective CustomTop member and ICPTop member. If the CustomTop metadata attribute is blank or ALL, then the None member is used.
In the Web, specify the name of the file to extract and make sure that you set up a directory for log files and extracted Web files. In Windows, specify the name of the file to extract and a log file name.
Note: The log file stores information about the process, such as the start and end time of the
To extract data:
1 Open the application from which to extract data. 2 From the navigation frame, select Extract Data. 3 For Data Filename, enter a file name, or click
to find the file.
Note: You can click View to display the contents of the data file that you specified. By default,
4 For Log Filename, enter a file name, or click 5 Select a data view to extract:
Extracting Data
61
6 For Delimiter Character, enter the character used to separate the data in the file. Valid characters are as
follows:
, ~ @ $ % & ^ | : ; ? \ Note: You can use any of the valid characters as long as the character is not used in the file name
or in any other way in the file. For example, if you are using the ampersand ( & ) in an entity member name, you cannot use the ampersand as the delimiter character.
7 From Data Subset, specify the subset of dimension members or member lists as follows:
l
For Year and Scenario, highlight one year and one scenario member. For Period, Entity, and Account, select the check boxes next to the dimension members to specify.
to select a member list for each dimension and select individual members from the member list.
Tip: Click Select All or De-Select All to select or clear all check boxes.
To extract data:
1 Open the application from which to extract data. 2 Select the Browser View tab. 3 In the view pane, expand Tasks and select Extract Tasks. 4 Select Extract Data. 5 Select a member for the Scenario dimension and a member for the Year dimension. 6 Select one or more members for the Period, Entity, and Account dimensions. 7 Select a data view to extract:
l
62
Managing Data
8 Optional: Select Extract Calculated Data to extract calculated data. 9 Optional: Select Extract Process Management Data to extract submission phase data. 10 Click Extract. 11 Click the Click Here to Download link and select Save. 12 Enter a name for the extracted file and make sure that the location for the file is in the Web directory that
you set up.
Note: By default, data files use the DAT file extension.
13 Click Save.
Copying Data
You can copy input and derived entity and account data from a scenario, year, and period, or group of periods to a destination (provided that the destination is not locked). The frequency of the source and destination periods must be the same. If you copy a list of periods, the number of source and destination periods must be the same. To update values, you must reconsolidate after you copy the data.
Note: If you select multiple periods from which to copy the data, the number of destination
periods must be the same. Regardless of whether you copy data from one period or multiple periods, the frequency of the source and destination periods must also be the same. You can also define a factor by which to multiply the data that you are copying. The source amounts are multiplied by the factor before the data is copied to the destination. For example, you can increase data values in one scenario before you copy them to another scenario. The multiplication factor that you define is not applied to system accounts. You must also consider any business rules you created and loaded that may affect the account data; for example, a rule that can be used to calculate an account in one period but not in another period. The copy option that you select determines how data is copied into an application. You can select an option to merge, replace, or accumulate the data. The copy options are the same as the data load options. See Load Methods on page 53. You also specify a log file, which stores information about the copy process; for example, the start and end times for the copy process and access violations. Windows Procedure
To copy data:
1 Open the application from which to copy data. 2 From the navigation frame, click Database Management.
Copying Data
63
3 Select Copy Data. 4 From Source, select a scenario and year, and a period or a range of periods from which to copy data.
Note: To select multiple periods, press and hold Ctrl, and select the periods. If you select multiple
periods from which to copy data, the number of destination periods must be the same. Also, whether you copy data from one or multiple periods, the frequency of the source and destination periods must be the same.
5 From Destination, select a scenario, year, and the same number of periods to which to copy data.
Tip: To select multiple periods, press and hold Ctrl, and select the periods.
6 From Copy Members, select the entity and account data to copy.
Note: You must check the box next to the dimension members to copy. You can click
to select a member list for each dimension and select individual members from the member list. Use Select All or De-select All to select and clear Entity and Account dimensions.
Merge to overwrite data in the application Replace to replace data in the application Accumulate to add data to data in the application
8 From View, select YTD or Periodic view. 9 From Value Dimension, select one or both options:
l
Rates and System to copy data from system accounts Entity Currency to copy the data in the EntityCurrency member of the Value dimension
10 For Factor, enter a factor by which to multiply the data that you are copying.
Note: The factor that you specify is not applied to system accounts.
Copy Cell Text to copy cell text Copy Derived Data to copy derived data
to find the file.
12 For Log File, enter a log file name, or click 13 Click Copy Data.
Note: After you copy the data, you can click View next to the Log File text box to see if any errors
64
Managing Data
Web Procedure
To copy data:
1 Open the application from which to copy data. 2 Select Browser View. 3 In the view pane, expand Tasks and select Data Tasks. 4 Select Database Management and select Copy Data. 5 For Source, select a scenario and year, and a period or a range of periods from which to copy data. 6 For Destination, select a scenario, year, and the same number of periods to which to copy data. 7 For Copy Members, select the entity and account members from which to copy data. 8 In Options, from Mode, select an option:
l
Merge to overwrite data in the destination scenario Replace to replace data in the destination scenario Accumulate to add data to data in the destination scenario
9 From View, select YTD or Periodic view. 10 For Value Dimension, select one or both options:
l
Entity Currency to copy the data in the EntityCurrency member of the Value dimension Rates and System to copy data from system accounts
11 For Factor, enter a factor by which to multiply the data that you are copying.
Note: The factor that you specify is not applied to system accounts.
Copy Cell Text to copy cell text Copy Derived Data to copy derived data
13 Optional: To store the copy information in a log file, select Enable Detailed Logging. 14 Click Copy Data.
metadata. These behaviors result when line item detail is copied to a scenario:
Copying Data
65
If the source scenario has line item detail and the destination scenario can accept line item detail, all details and the corresponding total are copied to the destination scenario. If the source scenario has line item detail and the destination scenario cannot accept line item detail, only the total is copied from the source scenario to the destination scenario. No line item detail is copied to the destination scenario. If the source scenario does not have line item detail and the destination scenario cannot accept line item detail, no detail is copied. If the source scenario does not have line item detail and the destination scenario accepts line item detail, the total amount is copied from the source to the first line item detail data in the destination scenario with the description equal to the label of the scenario. If the source and destination scenario views are the same, Periodic to Periodic or YTD to YTD, all details and the corresponding total are copied to the destination scenario. The amount reflects the default view defined for the scenario. If the source and destination scenario views are not the same, Periodic to YTD or YTD to Periodic, the line item detail is the destination scenario may not match the total after the copy operation. Line item detail in the destination scenario only matches the total when you view the data in the nondefault view of the scenario.
If both the source and destination support intercompany transactions, the system copies the source amount to the destination. It also copies the corresponding intercompany transaction details to the destination cell. If the source supports intercompany transactions but the destination does not, the system does not copy the transaction. If the source does not support intercompany transactions but the destination does, the system does not copy the transaction. If the destination contains intercompany details, the system does not copy the transaction.
Clearing Data
You can clear data for selected entities and accounts for a scenario, year, and period or list of periods. When you clear data, base and parent entities are cleared, however, only base-level accounts are cleared. You also cannot clear any cells that contain posted intercompany transactions.
Note: Select only unlocked cells when you clear data. Otherwise, the data clear fails.
66
Managing Data
Windows Procedure
To clear data:
1 Open the application from which to clear data. 2 Select Database Management on the navigation frame. 3 Select Clear Data. 4 From Clear Members, select a dimension tab and specify a subset of dimension members as follows:
a. b. Highlight a scenario and year member. Select the check box next to the Period, Entity, and Account dimension members to clear.
Tip: Click
to select a member list for each dimension and select individual members from the member list. Use Select All toolbar or De-select All to select and clear dimension members.
Entity Currency to clear the data in the Entity Currency member of the Value dimension Rates and Systems to clear data from system accounts
to find the file.
6 For Log File, enter a file name, or click 7 Click Clear Data.
Note: After you clear data, you can click View next to the Log File text box to display any errors
To clear data:
1 Open the application from which to clear data. 2 Select Browser View. 3 In the view pane, expand Tasks and select Data Tasks. 4 Select Database Management and select Clear Data. 5 From the Point of View bar, select a scenario and year, and select the period, entity, and account dimension
members to clear.
Entity Currency to clear the data in the Entity Currency member of the Value dimension Rates and Systems to clear data from system accounts
7 Optional: To store the clear information in a log file, select Enable Detailed Logging. 8 Click Clear Data.
Clearing Data
67
68
Managing Data
4
In This Chapter
Starting Explore Data ..............................................................................................................69 Working with Data Grids...........................................................................................................69 Selecting Explore Data Settings ..................................................................................................70 Entering or Editing Data ..........................................................................................................72 Viewing Data in Data Grids........................................................................................................74 Running Allocations................................................................................................................79 Locking and Unlocking Data ......................................................................................................79 Running Explore Data Reports ....................................................................................................80
69
3 From Page Dimensions, select one or more dimensions to display on the grid rows by dragging them to Row 4 From Page Dimensions, select a dimension to display on the grid columns by dragging it to Column
Dimensions.
5 From Properties, select whether to display the row or column items based on Member List Selection or POV
Checked Items.
Note: The Selected Dimension Properties title changes to a dimension name when you select a
dimension. For example, if you select the Entity dimension, the Properties title changes to Entity Properties. The POV Checked Items are based on the check boxes that you select from the Point of View dialog box. See Setting the Point of View on the Desktop on page 34.
6 Select a display option: Data or Calculation Status. 7 From Metadata Display, select an option: Label, Description, or Both. 8 Click OK. 9 Select the slicer dimensions on the Point of View bar.
71
72
4 Repeat steps 2 and 3 until you have entered or edited all the necessary data. 5 To save the data, click Submit Data,
.
To add a number to the value of a cell, type number+. To subtract a number from the value of a cell, type number-. To multiply the current cell value by a number, type number*. To divide the current cell value by a number, type number/.
.
Default Data Cell Colors Indication This is an input cell. You can enter or edit data manually. Allows allocations/derived data. This cell is read-only. This cell has no write or read access/derived data. Invalid intersection of dimension members. You cannot enter data in invalid cells. Yellow indicates one of these conditions:
l l
Cell Color Off-white Light green Medium green Dark green Red Yellow
Data in the cells has been modified but has not yet been saved. The input status is OK, but the status of the adjustment is not OK (CH, CN or TRN). If the status is CN for node level adjustments, you must run Force Calculate Contribution to clear up the adjustment member status.
73
Indication This cell contains locked/derived data. This is a header cell. This is the active cell.
You cannot perform any actions on cells in invalid dimension intersections. Invalid dimension intersections do not accept data entry because the top parents detail members are not used, or restrictions have been set for those dimensions. You set restrictions for dimensions when you set up members in the metadata file. For example, if you set up the Sales account in the metadata file to accept data entry by customer, the intersection of Sales and None for the Custom dimension is an invalid intersection for data entry.
Refreshing Data
You can refresh the data that is displayed in data grids and display the data that is saved in the database. This enables you to make changes to the data and restore the original data. When you refresh data, you are prompted to save any changes that you made to the data. You can select whether to save the changes to the database or restore the data that is saved in the database.
Note: When multiple users are updating data values in the same cells in data grids, there is no
indication to users that cell data has been overwritten. If multiple users enter data in the same cell simultaneously, the database stores the data from the last user who saved data.
To refresh the grid with data stored in the database, click Refresh Grid.
74
Modifying entity attributes Entering data in data grids, or loading data from external sources Posting or unposting journals Posting or unposting intercompany transactions Reloading rules Changing percent consolidation Changing currency rates
The following table lists the calculation statuses and their descriptions.
Table 5
Calculation Statuses Description None of the data for the specified Scenario, Year, Period, Entity, and Value dimensions has changed. OK No data. The calculation has been effectively run, but no calculations were run for NODATA. OK System changed. Some of the data for the specified Scenario, Year, Period, Entity, and Value dimensions has changed. For example, a new rules file or metadata file has been loaded, or the currency rate has changed. Needs Calculation. At least one data cell for the specified Scenario, Year, Period, Entity, and Value dimensions has been changed, or metadata parameters or rules have changed. As a result, other data cells in this Scenario, Year, Period, Entity, or Value dimension may not be up to date because calculation logic has not been run. For base-level entities, the data cell may have been entered by manual data entry or by a bulk data file load. For any entity, the data cell may have been entered by a journal posting. Needs Calculation No Data. This indicates the first time that calculation will be performed on the cell. Needs Translation. The selected Value dimension member is not the entitys default currency, and its translated values may not be up to date. Needs Translation No Data. This indicates the first time that translation will be performed on the cell. Needs Consolidation. The data for the specified Scenario, Year, Period, Entity, and Value dimensions may not be up to date because data for a child entity has changed, data for the same entity's default currency has changed, or metadata parameters or rules have changed. Needs Consolidation. The parent has no data, but data for a child entity has changed. This indicates the first time that consolidation will be performed on the cell. The data for the specified Scenario, Year, Period, Entity, and Value dimensions has been locked by an administrator and can no longer be modified by manual data entry or calculations. No data exists for the specified Scenario, Year, Period, Entity, and Value dimensions. The user does not have rights for the specified dimension member.
Status OK OK ND OK SC
CH
CH ND TR TR ND CN
75
3 Change the dimension settings as necessary. See Selecting Explore Data Settings on page 70. 4 Select Calculation Status. 5 Click OK.
To view adjustments:
1 From the Financial Management Desktop, click Explore Data. 2 Select the cell for which to view the adjustment history.
76
3 Right-click and select Cell Adjustments. 4 View the cell's adjustment detail information and click Close.
77
If the cell has a blank row to enter line item detail, go to step 5. To insert a line at the end of the rows, highlight a row in the line item detail grid, right-click and select New Line Item. To insert a row between line item rows, place the cursor where you want to insert the line item, right-click, and select Insert Line Item.
5 Enter a description and value for the line item detail. 6 Click OK to save your changes, or click Cancel.
78
amount matches the sum of the line item data when you view line item detail in the default view of the scenario. If you view data in another view, the Total amount and the line item detail will not match for any subsequent periods other than the first period.
Running Allocations
You can run allocations from a data grid if you are assigned the Run Allocation security role. You can allocate data from a source account in an entity to a destination account in a list of entities. The entity for which you run allocations can be a base or parent entity. Before you can run allocations, you must first create rules for them. See the Oracle Hyperion Financial Management Administrators Guide.
To run allocations:
1 From the Financial Management Desktop, click Explore Data. 2 Select a cell for which to run allocations. 3 Right-click and select Allocate.
Note: The Allocation menu option is available only if the entity status is OK.
The entitys calculation status must be OK. See Viewing Calculation Status on page 74. All prior periods must be locked for the current year.
Running Allocations
79
If the entity is a parent, all of its children must also be locked. If you select the top parent, the system locks all of its children. The Validation account for the entity currency and entity currency adjustments must be zero.
When you unlock data, you must be in the Unlock Data security role. You must also unlock a parent entity before you unlock its children.
To lock data:
1 From a data grid, select a cell for which to lock data. 2 Right-click and select Lock.
To unlock data:
1 From a data grid, select the cell for which to unlock data. 2 Right-click and select Unlock.
80
5
In This Chapter
Creating Data Grids ................................................................................................................81 Opening Data Grids ................................................................................................................82 Data Grid Tasks ....................................................................................................................82 Working with Data Grids...........................................................................................................83 Entering or Editing Data ...........................................................................................................88 Viewing Data in Data Grids........................................................................................................91 Running Allocations................................................................................................................97 Locking Data .......................................................................................................................97 Unlocking Data .....................................................................................................................98 Viewing Destination and Source Transactions...................................................................................99 Running Entity Transaction Detail Reports.......................................................................................99 Drilling Through to Intercompany Transactions................................................................................ 103 Drilling Through to Source Data ................................................................................................ 103
81
2 Click New Data Grid. 3 Set the grid rows and columns. See Setting Grid Rows and Columns on page 83. 4 Set the grid display options. See Setting Display Options on page 84.
Setting Grid Rows and Columns Entering or Editing Data Setting the Point of View on the Web
Viewing Cell Information Adding Cell Text Viewing Cell Adjustments Adding Line Item Detail Calculation Process Translating Data Consolidating Data Locking Data Viewing Cell History Viewing Destination and Source Transactions Running Entity Transaction Detail Reports Running Allocations
You can select a cell and right-click to display a menu of these options. If an option does not apply to a particular cell, it is not selectable.
82
These options are also available from the Process Control module. See Chapter 13, Using Process Management.
Highlight a cell in a data grid that is set up for Process Management, right-click and select Manage Process. To use the Process Control module, in the File Browser, expand Tasks and Data Tasks, and select Process Control.
Setting Grid Rows and Columns on page 83 Setting Display Options on page 84 Saving Data Grid Settings on page 85 Creating Data Grid Folders on page 86 Loading Data Grids on page 86 Extracting Data Grids on page 87 Deleting Data Grids on page 87
83
that you did not include in the grid rows and columns are called slicer dimensions. You should select a member for each slicer dimension. You can select whether to display data, calculation status, process level, and metadata labels or descriptions in grids. See Setting Display Options on page 84. When you exit a grid, the user point of view is updated for all dimensions except the values in the dimensions defined in the rows and columns. Although the values for rows and columns are stored in the grid settings, these values are not used to update the User Point of View when you exit the grid.
Grid Settings.
3 From Layout, select row and column dimensions from Page Dimensions, and use the arrows to move them
To move a dimension to Column Dimensions, click To move a dimension to Row Dimensions, click To return a dimension to Page Dimensions, click . . .
To move dimensions between Row and Column, use the arrow keys.
4 Click OK.
84
To show calculation status, select Calculation Status. To show data, select Data. To show process review level, select Process Level. To display metadata labels, select Label. To display metadata descriptions, select Description. To display both metadata labels and descriptions, select Both. To suppress cells that do not contain data, select Suppress No Data. To suppress cells that contain zero values, select Suppress Zero. Enter a Columns Per Page value, or use the default value of 128. Enter a Rows Per Page value, or use the default value of 1024.
7 From Scale, select a scale value, or use the default scale defined for the currency assigned to the entity. 8 When you finish selecting display options, click OK.
4 Optional: Select a security class for the grid. 5 Optional: Select Private if you want the grid to be private. 6 To overwrite a file, select Overwrite an existing file. 7 Click OK.
85
8 From Security Class, select the security class for the folder.
Note: Users of this folder must have access rights to the specified security class.
9 Click OK.
86
Note: If you do not select Override, the system uses the settings in the grid XML file.
6 To update a data grid or reload a previously extracted grid, select Overwrite Existing Documents. 7 Click OK. 8 To add more grids, click Load more files, and repeat steps 1 through 7 until all grids are added. 9 When you finish loading grids, click Finished.
3 Select the check box next to the grid to delete and click Delete.
Note: You can also delete a folder, but you must first delete any Web grids that it contains.
87
current selection. For example, to select all 12 periods in a grid, you can click period 1, scroll to the right using the scroll bar, and shift-click period 12.
3 Enter a value in the cell and click Enter. 4 Repeat steps 1 through 3 until you have entered or edited all the necessary data.
Note: You can clear a value by entering NODATA in a cell.
5 Click Submit Data to save the data, or click Reset Data to refresh the database.
88
amount 100 in the summary level for quarter Q1, the system distributes the 100 amount as 30, 30, and 40 to January, February, and March, respectively.
To highlight a row, select the dimension heading to the left of the row. To highlight a column, select the dimension heading at the top of the column. To highlight a block of cells, select a cell, and drag the cursor until all desired cells are highlighted.
2 Select the cell or block of cells into which to paste the data. 3 Right-click and select Fill.
The system fills the highlighted input cells only. If a highlighted cell is read-only, it is skipped.
Clearing Data
You can clear the values from one cell or from a block of cells. The system clears the highlighted input cells only. Cells that are read-only are not cleared.
To clear data, from a data grid, select the cell or block of cells to clear, right-click and select
Clear.
89
Table 6
Default Data Cell Colors Indication This is an input cell. You can enter or edit data manually. This cell allows allocations/derived data. Invalid intersection of dimension members. You cannot enter data in invalid cells. Yellow indicates one of these conditions:
l l
Data in the cells has been modified but has not yet been saved. The input status is OK, but the status of the adjustment is not OK (CH, CN or TRN). If the status is CN for node level adjustments, you must run Force Calculate Contribution to clear up the adjustment member status.
This cell contains locked/derived data. This is a header cell. This cell has no write or read access/derived data. This cell is read-only.
You cannot perform any actions on cells in invalid dimension intersections. Invalid dimension intersections do not accept data entry because the top parents detail members are not used, or restrictions are set for those dimensions. You can set up restrictions for dimensions when you set up members in the metadata file. For example, if you set up the Sales account in the metadata file to accept data entry by customer, the intersection of Sales and None for the Custom dimension is an invalid intersection for data entry. To determine the data status, you must check both the calculation status and the process level of the data. See Viewing Calculation Status on page 91 and Viewing Process Level on page 92.
Refreshing Data
You can refresh the data that is displayed in data grids and display the data that is saved in the database. This enables you to make changes to the data and restore the original data. When you refresh data, you are prompted to save any changes that you made to the data. You can select whether to save the changes to the database or restore the data that is saved in the database.
Note: When multiple users are updating data values in the same cells, there is no indication to
users that cell data has been overwritten. If multiple users enter data in the same cell simultaneously, the database stores the data from the last user who saved data.
90
Changing the organization structure Adding or deleting accounts Modifying entity attributes Entering data in data grids, or loading data from external sources Posting or unposting journals Posting or unposting intercompany transactions Reloading rules Changing percent consolidation Changing currency rates
Calculation Statuses Description None of the data for the specified Scenario, Year, Period, Entity, and Value dimensions has changed. OK No data. The calculation has been effectively run, but no calculations were run for NODATA. OK System changed. Some of the data for the specified Scenario, Year, Period, Entity, and Value dimensions has changed. For example, a new rules file or metadata file has been loaded, or the currency rate has changed. Needs Calculation. At least one data cell for the specified Scenario, Year, Period, Entity, and Value dimensions has been changed, or metadata parameters or rules have changed. As a result, other data cells in this Scenario, Year, Period, Entity, or Value dimension may not be up to date because calculation logic has not been run. For base-level entities, the data cell may have been entered by manual data entry or by a bulk data file load. For any entity, the data cell may have been entered by a journal posting. Needs Calculation No Data. This indicates the first time that calculation will be performed on the cell.
Status OK OK ND OK SC
CH
CH ND
91
Status TR TR ND CN
Description Needs Translation. The selected Value dimension member is not the entitys default currency, and its translated values may not be up to date. Needs Translation No Data. This indicates the first time that translation will be performed on the cell. Needs Consolidation. The data for the specified Scenario, Year, Period, Entity, and Value dimensions may not be up to date because data for a child entity has changed, data for the same entity's default currency has changed, or metadata parameters or rules have changed. Needs Consolidation. The parent has no data, but data for a child entity has changed. This indicates the first time that consolidation will be performed on the cell. The data for the specified Scenario, Year, Period, Entity, and Value dimensions has been locked by an administrator and can no longer be modified by manual data entry or calculations. No data exists for the specified Scenario, Year, Period, Entity, and Value dimensions. The user does not have rights for the specified dimension member.
92
process management submission phases, cell information includes the submission phase to which the cell is assigned for the scenario and period. The cell information displays the base input currency value. The stored data is the amount stored in the database, which is always in units. The full resolution data is the amount entered, with the decimal and thousand separator defined in user preferences. The displayed data is the amount displayed for the cell using the decimal places for the account. The displayed data might appear different than the data stored because of rounding, based on the number of decimal places that you select to display. For example, suppose you have an account that specifies 0 for the decimal place, the currency of the entity has a scale of 3, and your user preferences specifies the comma (,) as the thousands separator and the period (.) as the decimal separator. If you enter the amount 12345.6789, the cell information is displayed as follows: Displayed data = 12,346 (rounding to display 0 decimal places) Full resolution data = 12,345.6789 Stored data=12345678.9 (stored in units)
To view adjustments:
1 Open a data grid. 2 Select the cell for the adjustment member for which to view the history. 3 Right-click and select Cell Adjustments. 4 View the cell's adjustment detail information, and click Close.
93
You can set a size limit for cell text in an application. The default cell text setting is a maximum of 8,000 bytes. You set the maximum size in the AppSettings attribute for the application metadata. After you add cell text, a blue border is displayed to indicate that there is text associated with the cell.
94
Line Item Detail Options Windows Data Grid No Yes Yes Yes No No Web Data Grid No Yes Yes Yes No No Data Forms Yes Yes Yes Yes Yes Yes
Task View Multiple Periods View Single Period Insert Line Item Detail Clear Line Item Detail from a Single Period Clear Line Item Detail from Multiple Periods Delete Line Item Detail from Multiple Periods
95
amount for each line item detail. After you save the detail, the system calculates the total amount for the travel expense account. You can enter line item detail only in the base frequency defined for the scenario. For example, if the scenario is Monthly, you cannot enter line item detail in Quarter1.
Note: Line item detail cannot contain single quotation marks ( ), and the maximum length for
the description is 80 characters. Line item detail applies only to the Entity Currency Value member, or to the default currency. The system does not consolidate, translate, or calculate contribution for line item detail. In a data grid, after you enter the line item detail for the cell, a blue border is displayed to indicate that there is line item detail associated with the cell.
96
Running Allocations
You can run allocations from a data grid if you are assigned the Run Allocation security role. You can allocate data from a source account in an entity to a destination account in a list of entities. The entity for which you run allocations can be a base or parent entity. Before you can run allocations, you must first create rules for them. See the Oracle Hyperion Financial Management Administrators Guide.
To run allocations:
1 Open a data grid. 2 Select a cell for which to run allocations. 3 Right-click and select Allocate.
Locking Data
You can lock an entity for a period or periods if you do not want users to be able to modify that data, and if you are in the Lock Data security role. When data is locked, you cannot change the data for that scenario, year, entity, parent, value, and period. When you lock data, the system locks recursively across the Entity and Value dimensions, so it is only necessary to select the top parent. When you lock a parent entity, the system locks recursively upward starting at all of the base entities. For each entity, Value members are locked in this order: Entity Currency, None, Parent Currency, Contribution Total. You can lock data for a period only if these conditions are met:
Running Allocations
97
The entitys calculation status must be OK. See Viewing Calculation Status on page 91. If process management is enabled for the scenario, the entity must have a process level of Published. If Process Management is enabled and the cell status is NODATA, you must promote the process unit before it can be locked. See Process Levels on page 245. All prior periods must be locked for the current year. If the entity is a parent, all of its children must also be locked. If you select the top parent, the system locks all of its children. The Validation account for the entity currency and entity currency adjustments must be zero.
To lock data:
1 From a data grid, select a cell for which to lock data. 2 Right-click and select Lock.
Unlocking Data
To unlock data, you must be in the Unlock Data security role. You must also unlock a parent entity before you unlock its children. When you unlock data, the system unlocks recursively across the Entity and Value dimensions, so you only need to select the top parent. If you need to unlock specific children under a parent entity instead of unlocking all the children, an administrator can disable recursive unlocking using the UseRecursiveUnlock registry setting.
To unlock data:
1 From a data grid, select the cell for which to unlock data. 2 Right-click and select Unlock.
4 Right-click and select New, then select DWORD Value. 5 For Name, enter UseRecursiveUnlock. 6 The default value is 1. To disable recursive unlocking, change the value to 0.
98
To view the destination data impacted by the consolidation, select Destination Transactions. The system displays all of the destination transactions generated from or affected by the selected cell. To view the source data from which the consolidation was run, select Source Transactions. The system displays all the source transactions that have affected the selected cell.
Starting the Entity Transaction Detail Report on page 100 Selecting Rows and Columns for the Report on page 100
99
Displaying Line Item Detail on page 102 Displaying Base Details on page 102 Displaying Source and Destination Transactions on page 102 Linking to Journal Detail on page 102 Printing Entity Transaction Detail Reports on page 103
Input
Value Dimension
Remark
l l l
Calculated Prior LID Derived Calculated Group Label Prior Journals Derived Nature Prior Transactions Derived
Adjustments
l l l l
Proportion/Elimination
l l l
You can suppress the display of some transaction details or dimensions by deselecting the applicable options. For example, if you want the report to show only the journal details, you can deselect all other row display options, leaving only the journals option selected. If you want to also suppress the Custom 1, 2, 3 and 4 columns because they are not used for the account, you can also deselect these options from the column display. The system always displays the Value and Amount columns. The Value column contains all of the Value members. If the currency of the parent member is the same as the currency of the entity, the system skips the display of the Parent Currency related Value members because it is duplicate information. The Amount column contains the amount from the data subcube. The amounts for each transaction detail are stored in the Debit or Credit column, depending on the sign of the data cell.
Base Details Line Items Journals Destination Transactions Source Transactions Entity Account Custom 1, 2, 3 or 4 ICP Debit Credit
Running Entity Transaction Detail Reports 101
ID Remarks
To print reports:
1 From a report, right-click and select Print. 2 From the Print dialog box, click Print.
6
In This Chapter
Consolidating Data
Consolidation Process ........................................................................................................... 105 Entering Currency Rates ......................................................................................................... 109 Entering Percent Consolidations................................................................................................ 110 Calculating Data ................................................................................................................. 110 Translating Data.................................................................................................................. 111 Consolidation Options ........................................................................................................... 112 Consolidating Data .............................................................................................................. 113 Consolidation Status ............................................................................................................ 115
Consolidation Process
Consolidation is the process of gathering data from dependent entities and aggregating the data to parent entities. After you enter or load data into base entities, you perform a consolidation to aggregate the data through the organization. As data consolidates, the system performs the necessary currency translation and intercompany eliminations, and equity adjustments or minority ownership calculations if needed on the data. Financial Management provides a default consolidation method. To enable statutory consolidations, you can customize the consolidation process. When you create an application, you can set the Consolidation Rules attribute. By default, when this setting is OFF, the system performs the default consolidation and eliminations. When this setting is ON, the system performs consolidation according to the rules written in the Sub Consolidate() routine, as defined by the user. See the Oracle Hyperion Financial Management Administrators Guide. You launch the consolidation process from data grids on the Desktop or on the Web. Launching consolidation runs the consolidation rules for the specified scenario, year, period, entity, and value. As part of that process, consolidation is run for all descendent entities and all prior time periods within the same year. The consolidation process runs all Calculate functions for each affected entity and value. Translation is run as required to convert from child entity currency to parent entity currency. If the child and parent entity are using the same currency, translation is not run. After you select the parent into which the dependent entities consolidate, this process takes place:
l
The system executes chart rules, and aggregates input and adjustment data in the local currency.
The system performs translation, if it has not been previously executed. The system also aggregates input and adjustment data by currency for a given entity. You can enter adjustments to data through journals. The consolidation process begins. The system generates proportion and elimination detail, and creates contribution data. You can make further adjustments to contribution data through journals.
At the entity level of the consolidation process, you enter data in input accounts and enter adjustments through journals in the entity currency. The system executes chart rules at the entity level, resulting in adjusted data for the entity. The following figure shows an example of the consolidation process:
Figure 2
Translation Process
Translation converts values from one currency to another. The data in the local currency of the dependent entity is translated to the currency of the parent using the local currency exchange rate. You can enter currency rates by entity for base entities. If you enter currency rates by entity, during translation, the system uses the current entity for the direct translation rate. For example,
if the entity currency rate is Euro, and the parent currency rate is USD, the system uses Rate.Euro.USD in the entity that is being translated. If you do not enter currency rates by entity, the system derives the direct rate from the indirect rate in the current entity. For example, it reverses the amount stored in Rate.USD.Euro to obtain Euro/USD. If the currency rate is not found in the current entity, the system uses the direct rate in the None entity. If the rate is not found, the system derives the direct rate from the indirect rate in the None entity. For example, the system reverses the amount stored in Rate.USD.Euro to obtain Euro/USD. See the Oracle Hyperion Financial Management Administrators Guide. After the translation rule is run, the translated currency dimension is stored. You can make adjustments to the translated amounts in each currency through journals. The total of these two levels (Translated and Adjusted data) represents the starting point of the consolidation process. The translation process does not take place if the entity and the parent have the same default currency. In this case, the system moves directly to the consolidation process. As a dependent entity's values roll up into its parent during consolidation, the system can store consolidation detail, such as Proportion and Elimination detail. Proportion detail contains the balances resulting from the execution of consolidation rules. It also reflects the results of the percent consolidation on the base values. Elimination detail contains any eliminating balances that result during consolidation based on elimination rules. The system derives as aggregation the contribution (before adjustment) values. It is still possible to adjust this data through journals. The system executes chart rules for adjustments to contribution after you post the journals. The total of the contribution data (before adjustments) plus the adjustments represents the contribution of the base entity to its parent. The system adds the contribution to the contributions of the other immediate dependents of the parent to obtain the parent consolidated data. The intermediate contribution level aggregations are not stored during calculation. However, the parent consolidated data is stored by the system.
Calculation Process
When you calculate data, the system runs calculation rules for the scenario, year, period, entity, and value that you specify. For example, you can calculate the current months opening balances by using the prior months closing balances. Calculation rules for all prior time periods within the same year are also run if they have not been run previously. Because calculation rules do not consolidate source entities or execute translation, the status (for example, needs translation or consolidation) is not removed from the cell. Even if the input accounts are not current, calculation uses that data to derive calculated accounts.
Row Dimension = Custom 1 Column Dimension = Custom 2 Row List and Column List = The member lists you created that contain the application currencies, or the Currencies system list
You enter currency rates in a data grid using this point of view:
Table 10
Point of View for Currency Rates Description Scenario for which the currency rate applies Year for which the currency rate applies Period for which the currency rate applies YTD Entity for which the currency rate applies, or None If None, the system uses the default currency rate.
Value Account
Entity Currency Account to contain currency rates Account type must be "currencyrate," which you specify in the metadata load file.
ICP None Source currency Select the Currencies system member list.
Custom Dimension 2
None None
You enter consolidation percentages using this point of view and entering data at the parent entity cell. The child entity cell is red.
Table 11
Point of View for Consolidation Percentages Description Scenario for which the consolidation percent applies Year for which the consolidation percent applies Period for which the consolidation percent applies (This does not need to be set if the grid is set as described above.)
View Entity Value Account ICP Custom Dimension 1 Custom Dimension 2 Custom Dimension 3 Custom Dimension 4
YTD Parent Entity None PCON Child Entity None None None None
Calculating Data
You calculate data from data grids on the Desktop or on the Web. In addition to data grids, you can also calculate data from the Process Control module on the Web. When you calculate data, calculation rules run for the selected scenario, year, period, entity, and value. In addition, all prior time periods within the same year that were not previously calculated are calculated. For example, if you calculate data for June, data that was not previously calculated for January through May is calculated.
110 Consolidating Data
You can calculate contribution values rather than parent values. Contribution values are values added to a parent by a dependent entity. When you select contribution values, this populates the Value dimension members of the current entity without rolling the contribution total up to the parent entity. You can also force calculation to generate contribution values. After you calculate data, the Calculate Data menu option is disabled. If you load or enter new data or metadata, the Calculate Data menu item is reenabled. If the Calculate Data option is not enabled, you can use the Force Calculate option to calculate data.
To calculate data:
1 From the data grid, select the point of view. 2 Select the cell for which to calculate data. 3 Right-click and take one of these actions:
l
To calculate the selected cells, select Calculate. To force calculation to run for all selected cells, select Force Calculate. To calculate contribution values, select Calculate Contribution. To force calculation to run for all selected contribution values, select Force Calculate Contribution.
Translating Data
Translation converts values from one currency to another. You can translate data from the entity's input currency to any other currency that has been defined in the application. Currencies are not associated with a parent-child entity pair, so you can translate data on demand, separately from the consolidation process. Launching translation runs the default translation rules for the specified scenario, year, period, entity, and value. As a part of the process, translation rules for all prior time periods within the same year are also run, if translation for those periods is required (TR status). Because translation rules do not cause dependent entities to be consolidated, they do not remove the status that indicates that a cell needs consolidation (CN status). Even if the data for the entity's default currency is not current, translation uses that data to derive the input accounts for the specified currency (Value dimension). Subsequently, the translation rules automatically invoke calculation so that the calculated accounts are populated for the specified currency. You translate data from data grids on the Desktop or on the Web. In addition to data grids, you can also translate data from the Process Control panel on the Web. After you translate data, the Translate Data menu command is disabled. If you load new data, the Translate Data menu option is reenabled. If the Translate Data menu option is not enabled, you can use the Force Translate menu command.
To translate data:
1 Select the point of view. 2 Select a cell for which to run translation rules.
Translating Data 111
To force translation to run for all selected cells, select Force Translate.
Consolidation Options
Consolidation is the process of gathering data from dependent entities and aggregating the data to parent entities. Invoking consolidation runs the consolidation algorithms for the specified scenario, year, period, entity, and value. As a part of that process, consolidation for all descendant entities and all prior time periods within the same year is run, if it has not been run previously. The consolidation process runs all calculation rules functions for each affected entity and value, and translation runs as necessary to convert from child entities to parent entities. The consolidation process does not run translation rules for currencies that are not used in the process of deriving parent entity data from its children. These options are available for consolidating data: Consolidate (Impacted), Consolidate All with Data, and Consolidate All.
Process units with a status of NODATA on the current period and all prior periods are skipped. Process units with a status of OK or OK SC on the current period are recalculated, retranslated, and reconsolidated. If the selected parent has a status of CN or CN ND in the prior period, consolidation runs for all periods from the first period in the current year where the parent is impacted until the current period.
Consolidate All
The Consolidate All option is available for any parent entity regardless of its status. When you select this option for a parent entity, the system performs calculations for every process unit within the consolidation path of the selected parent, regardless of its status. Process units with a status of NODATA on the current period are calculated, translated, and consolidated. Process units with a status of OK or OK SC on the current period are recalculated, translated, and reconsolidated. If the selected parent has a status of CN or CN ND in the prior period, consolidation runs for all periods from the first period in the current year where the parent is impacted until the current period. The Consolidate All option is useful when an update from prior periods is required, or when an entity with no data needs to be populated using allocations. This option should be used sparingly because the system does not skip entities with NODATA, which can have a significant impact on consolidation performance.
Consolidating Data
You can consolidate data by selecting cells in data grids on which to run consolidation. To use Consolidate, you must be assigned the Consolidate security role. To use Consolidate All, you must be assigned the Consolidate All security role. To use Consolidate All with Data, you must be assigned the Consolidate All with Data security role. You consolidate data from data grids on the Desktop or on the Web. In addition to data grids, you can also consolidate data from the Process Control panel on the Web. When the consolidation process is complete, the status of each successfully consolidated entity changes to OK.
Note: If the consolidation process is running for the selected entity, the system displays a warning
To consolidate data:
1 Select the point of view.
2 Select a cell for which to run consolidation. 3 Right-click and take one of these actions:
l
To consolidate the selected entity, select Consolidate. To consolidate all selected entities, regardless of whether they contain data, select Consolidate All.
Note: Consolidation is run for all cells in the current scenario, year, period, entity, and value.
To consolidate all selected entities that contain data, select Consolidate All with Data.
From the Consolidation Progress page, view the progress for the task that is running. From the Running Tasks page, select the Consolidation task from Task Filter and click View to view the progress.
From the Consolidation Progress page, click Cancel for the consolidation to cancel. From the Running Tasks page, select the Consolidation task from Task Filter and click Stop Task.
Consolidation Status
The consolidation status of a base level or parent entity can change as a result of several actions:
l
Changing the organization structure Adding or deleting accounts Modifying entity attributes Entering data in data grids, or loading data from external sources Posting or unposting journals Posting or unposting intercompany transactions Reloading rules Changing percent consolidation Changing currency rates
7
In This Chapter
Working with Data Forms........................................................................................................ 117 Opening Data Forms............................................................................................................. 118 Using the Data Form Toolbar.................................................................................................... 118 Viewing Data Form Instructions................................................................................................. 119 Entering Data in Data Forms .................................................................................................... 119 Shortcut Menu Commands...................................................................................................... 120 Working with Cell Text ........................................................................................................... 122 Attaching Documents to Data Forms........................................................................................... 123 Entering Line Item Detail in Data Forms ....................................................................................... 124 Viewing Line Item Detail in Data Forms........................................................................................ 125 Deleting Line Item Detail in Data Forms ....................................................................................... 125 Using Linked Forms .............................................................................................................. 125 Changing the Point of View in Data Forms..................................................................................... 126 Calculating Data in Data Forms ................................................................................................ 126 Exporting or Importing Data Forms to Excel ................................................................................... 129 Drilling Through to Intercompany Transactions................................................................................ 129 Drilling Through to Source Data ................................................................................................ 130
Forms may also be included in folders. The Data Forms administrator can create folders to organize the forms in an application. You can view the forms in a folder, but only the administrator can create or delete folders. You can only enter data on forms for which you have security rights. You can open, view, enter or edit data, and save data in data forms. Only an administrator with Manage Data Forms security rights can create, load, and delete forms. See the Oracle Hyperion Financial Management Administrators Guide. If you want to use data forms in Microsoft Excel, Oracle recommends that you access them directly through Oracle Hyperion Smart View for Office, Fusion Edition. See the Oracle Hyperion Smart View for Office Users Guide. See these topics:
l
Using the Data Form Toolbar on page 118 Entering Data in Data Forms on page 119 Attaching Documents to Data Forms on page 123 Calculating Data in Data Forms on page 126
Function Submit
Function Refresh Calculate Force Calculate Cell Text Instructions Print Export to Excel Import to Excel Suppress Rows Suppress Columns Suppress Lines
Toolbar Button
Note: If you use Firefox for a browser, you can use the ESC key to close any popup menus that
period and have it distributed across base-level periods. You cannot enter data into calculated or cells at invalid intersections, which are indicated in red. See Entering or Editing Data on page 88. To enter data in a data form, you must have access to the security class for the form and security rights for the data in the cells on the form. You can use the scroll bars for rows and columns to view various parts of the form.
3 When you finish entering data, click Submit. 4 To refresh the data, click Refresh.
automatically refreshed after the consolidation process. When the consolidation process is complete, from the data form, click Refresh to refresh the data in the form. If you choose to refresh the data in a data form while consolidation is running, you must manually close the Running Task window.
Table 13
Data Form Right-Click Menu Commands Description View cell text. See Viewing Cell Text in Data Forms on page 122. View intercompany transactions. See Drilling Through to Intercompany Transactions on page 129. Navigate to linked forms. See Using Linked Forms on page 125. View form properties. See Viewing Cell Information on page 92. For base entity, force calculation to run. See Calculating Data on page 110.
Menu Command Cell Text Intercompany Transactions Linked Form Properties Force Calculate
Menu Command Force Calculate Contribution Consolidate Calculate Contribution Consolidate All with Data Consolidate All Translate Force Translate Lock Unlock Manage Process Allocate Source Transactions Destination Transactions Entity Details Cell History Run EPU Force EPU FDM ERPI
Description For base entity, force calculate contribution to run. See Calculating Data on page 110. For parent entity, consolidate entities. See Consolidate (Impacted Consolidation) on page 112. For parent entity, calculate contribution. See Calculating Data on page 110. For parent entity, consolidate every dependent entity within the consolidation path of the selected parent that contains data, regardless of its status. See Consolidate All with Data on page 112. For parent entity, perform calculations for every process unit within the consolidation path of the selected parent, regardless of its status. See Consolidate All on page 113. Translate selected cells. See Translating Data on page 111. (only available if translation is available). Force translation to run. See Translating Data on page 111. (only available if translation is available). Lock data for a period. See Locking Data on page 97. Unlock data for a period. See Unlocking Data on page 98. View process unit status. See Viewing the Process Control Summary on page 255. For base entity, allocate data from a source account to a destination account. See Running Allocations on page 97. View source transactions. See Viewing Destination and Source Transactions on page 99. View destination transactions. See Viewing Destination and Source Transactions on page 99. View entity details. See Running Entity Transaction Detail Reports on page 99. View cell history. See Viewing Cell History on page 97. Run the Equity Pickup process. See Calculating Equity Pickup Adjustments on page 145. Force the Equity Pickup process to run. See Calculating Equity Pickup Adjustments on page 145. Drill through to source data through FDM. Only available if you loaded drillable regions for FDM. See Drilling Through to Source Data on page 130. Drill through to source data through ERPI. Only available if you loaded drillable regions for ERPI. See Drilling Through to Source Data on page 130.
Highlight a cell, right-click, and select Cell Text. Select a cell, and in the form toolbar, click Cell Text. If the administrator has set up the form with a cell text column, enter the cell text in the column.
Note: The cell point of view is displayed for informational purposes only.
4 In the text box below the cell point of view information, enter the text for that cell, and click OK.
Note: After you enter cell text, the cell has a blue triangular mark in the top left corner to indicate
that it contains cell text. Cells that contain both cell text and line item detail are indicated by a blue and red triangular mark.
Highlight a cell, right-click, and select Cell Text. Highlight a cell, and in the form toolbar, click Cell Text. If the administrator has set up the form with a cell text column, view the cell text in the column.
Note: The cell point of view is displayed for informational purposes only.
Highlight a cell, right-click, and select Cell Text. Highlight a cell, and in the form toolbar, click Cell Text. If the administrator has set up the form with a cell text column, edit the cell text in the column, or click Cell Text to add more text.
The attachment is displayed in the Attachments section of the Cell Text dialog box.
Tip: To detach a document from a cell, select the document to detach, and click Detach.
4 Enter the cell line item detail, and click Save. 5 To add a row, click New Entry.
Note: If the form was set up for multiple period line item detail, you can click Delete Row to
delete a row of line item detail. You can also click Clear Row to clear the line item detail from a row.
6 To refresh the data, click Refresh. 7 When you finish entering line item detail, click Close.
Note: After you save your entries, cells that contain line item detail are indicated by a red
triangular mark in the top left corner. A cell that contains both cell text and line item detail is indicated by a blue and red triangular mark.
corner.
corner.
3 Right-click and select Cell Line Item Detail. 4 Select the row to delete and select Delete Row. 5 Click Save, close the line item detail window, and click Refresh to refresh the data.
Click Calculate if you want the system to calculate the cells that have changed. Click Force Calculate to force calculation to run for each scenario, year, period, value, parent, entity defined in the grid, regardless of status.
Note: You must submit the data before you calculate.
option. Suppression of invalid cells is automatically enabled for all other users.
To suppress data:
1 Open a data form. 2 Take one or more of these actions:
l
To suppress rows, on the toolbar, click Suppress Rows , and select None, or one or more of these options: NoData, Zero, or Invalid. To suppress columns, on the toolbar, click Suppress Columns and select None, or one or more of these options: NoData, Zero, or Invalid. To suppress rows and columns, on the toolbar, click Suppress Lines and select None, or one or more of these options: NoData, Zero, or Invalid.
Tip: Another method of selecting suppression options is to place your cursor over a row or
column header, and right-click to change the row or column. To change both row and column options, place your cursor in the space at the top left of the form where the rows and columns intersect, right-click and select an option.
5 Click OK. 6 Enter data for the additional members. 7 Optional: Enter cell text by taking one of these actions:
l
Highlight a cell, right-click, and select Cell Text. Select a cell and click Cell Text. If the administrator has set up the form with a cell text column, enter the cell text in the column.
8 Optional: To calculate or force calculate the selected cells, click Calculate and Force Calculate, respectively.
Note: You must submit the data before you calculate.
Change the number of rows or columns displayed as necessary, or deselect the display of Headers, and click Update. To print the form, click Print.
8
In This Chapter
Managing Ownership
Managing Ownership ............................................................................................................ 131 Entering Ownership Information ................................................................................................ 133 Calculate Ownership Process ................................................................................................... 135 Calculating Ownership........................................................................................................... 136
Managing Ownership
You can set up the ownership and control of an organization by recording the shares of stock that the entities in the organization own in one another. You can record two types of shares for an organization: regular shares and voting shares. The system uses regular shares to calculate ownership and voting shares to calculate control. You can enter the number of shares that entities own. If you assign a holding company to a parent entity, the system can calculate the ultimate ownership and control percentages based on the share values. It can then use the ultimate percentages to propose the consolidation percentage and method for the entities below that parent. If you are using Financial Management on the Web, you can manage ownership information such as percent consolidation, percent ownership, percent control, and consolidation method. You can enter information for selected entities and these system accounts: Active, Method, PCON, POWN, PCTRL, DOWN, Consol1, 2, and 3. The grid also displays a column called PMIN, which is a calculated column using this calculation: PCON - POWN = PMIN. To enter ownership information, you must be assigned the Manage Ownership security role. See Entering Ownership Information on page 133. In addition, you can calculate values for ownership percentages based on the ownership of shares of entities. See Calculating Ownership on page 136. The following figure shows a sample ownership grid. The rows display the list of child entities based on the entity you are using as the parent entity in the point of view. The columns display system accounts for which you can enter values.
Figure 3
3 Optional: To display the entity description, select Show Entity Description. 4 Optional: To display the period description, select Show Period Description.
5 Optional: To select the columns to display, click Display Options. 6 Select the columns to display. 7 Click OK.
Select the check box next to the row or rows to fill. To select all, select the box at the top of the list next to Entities.
2 Highlight the account from which to fill values, and click Fill.
The system applies the current value to all the selected entities.
To save the current values to the database and refresh the data, click Save. To reset the data to the values that were last saved in the database, click Reset.
Note: For the PCON, POWN, PCTRL, and DOWN system accounts, no data is displayed as a
value of 100. For Consol 1, 2, 3, no data is displayed as 0. Table 14 shows the system accounts that appear in the columns and the possible values that you can enter for each. These columns are preset and cannot be changed. See the Oracle Hyperion Financial Management Administrators Guide.
Table 14
System Accounts for Ownership Management Possible Values Yes for active, No for inactive None, or a method selected from the list of available methods Positive or negative number between -100 and 100, including 0. Default value is 100. Positive number between 0 and 100. Default value is 100. A value calculated from the formula PMIN = PCON POWN. Positive number between 0 and 100. Default value is 100. Positive number between 0 and 100. Default value is 100. A number between 0 and 255 Yes for active, No for inactive
Account Active - Consolidation status of a child into its parent Method - Consolidation method assigned to the entity PCON - Percent consolidation. The percentage of an entitys value that consolidate to its parent. POWN - Percent ownership based on the entitys shares that other entities own. PMIN - Percent minority PCTRL - Percent control based on the entitys voting shares that other entities own DOWN - Percent of direct ownership Consol 1, 2, 3 - Consolidation methods Active - Consolidation status of a child into its parent
For Active, select Yes or No to specify whether the consolidation status of the child into its parent is active. For Method, select a consolidation method for the entity. For PCON, enter a value for percent consolidation. For POWN, enter a value for percent ownership. For PCTRL, enter a value for enter a value for percent control. For DOWN, enter a value for direct ownership.
For Consol1, Consol2, and Consol3, enter a consolidation method. To view additional entities, select the range to display, and select a value from Per Page . To save the changes to the database and refresh the grid, click Save. To reset the data to the values in the database without saving changes, click Reset.
Percent Control
Percent control represents the percentage of an entity based on voting shares that other entities own, directly or indirectly. When you select Percent Control, the system calculates the percentage that the selected parents holding company controls of each dependent based on the shares information stored in the Voting%Owned PCTRL system account using the ICP dimension. For example, if the calculation returns 80% for Entity A, the system stores 80 in the parent entitys PCTRL account, ICP=A.
Consolidation Method
Consolidation method is the set of rules that determine how to consolidate data from an entity to its parent. The system proposes this method based on the percent control and the consolidation methods in the Consolidation Method metadata table that have the UsedbyCalcRoutine attribute enabled. For each entity for which percent control is calculated, the system assigns the consolidation method corresponding to the percent control range for the consolidation method specified in the table. For example, if the percent control calculated for Entity A is 75%, and the consolidation method assigns the GLOBAL method when percent control is from 50% to 100%, the system stores 1 in the parent entitys Method account, Custom1=GLOBAL, ICP=A. The exception to this rule is the holding company for the parent. For the holding company only, the system does not use percent control to determine the consolidation method, but assigns the consolidation method that has the IsHoldingMethod attribute enabled.
Percent Ownership
Percent ownership represents the percentage of an entitys nonvoting shares that other entities own, directly or indirectly. When you select Percent Ownership, the system calculates the ultimate percent owned based on the share values stored in the Shares%Owned account. The calculation result is stored in the parent in the POWN system account using the ICP dimension. For example, if the calculation returns 90% for Entity A, the system stores 90 in the parent entitys POWN account, ICP=A.
Percent Consolidation
Percent consolidation is the percentage of an entitys values that consolidate to its parent. The system uses the methods defined in the Consolidation Method metadata table to determine the percent consolidation to apply for each entity. If there is no consolidation method assigned to the entity, or the method assigned to the entity does not match a method marked UsedByCalcRoutine, then the system uses the percent consolidation corresponding to the percent control range. For example, if the Method account], Custom1=Global, ICP=001 has a value of 1, and in the consolidation method table, the percent consolidation corresponding to method Global is 100%, the system stores 100 in the PCON account, ICP=001.
Calculating Ownership
You use the Calculate Ownership option to calculate values for ownership percentages based on the ownership of shares of particular entities. You can run the calculation procedures together or separately. You can calculate ownership for multiple parent entities and for multiple periods for a specific scenario and year. You must assign a holding company to the parent for the Calculate Ownership option to be available. See the Oracle Hyperion Financial Management Administrators Guide.
To calculate ownership:
1 From the Ownership Management grid, select the parent entity as the POV entity for which to calculate
ownership.
Note: The parent entity that the calculation uses is the Entity on the point of view. For example,
if the POV entity is Region.Europe, the calculation takes place for Europe, not Region.
2 Click Calculate Ownership. 3 Highlight one or more periods for which to calculate ownership. 4 Select one or more calculation options:
l
To calculate ultimate percent control, select Percent Control. To select a consolidation method for percent control, select Consolidation Method. To calculate ultimate percent ownership, select Percent Ownership. To calculate ultimate percent consolidation, select Percent Consolidation. To calculate direct percent ownership, select Direct Percent Ownership. To calculate ownership for the current entity only, select Current Entity. To calculate ownership for the current entity and all parent entities below it, select Descendants. To calculate ownership for all entities, select All Entities.
6 Click Calculate.
9
In This Chapter
About Equity Pickup ............................................................................................................. 139 Examples of Equity Pickup Adjustments ....................................................................................... 140 Managing Equity Pickup......................................................................................................... 143 Modifying the Display of the Manage Equity Pickup Table................................................................... 144 Calculating Equity Pickup Adjustments ........................................................................................ 145 Printing Equity Pickup Reports .................................................................................................. 146 EPU Calculation Process ........................................................................................................ 146
Adjustment amount in H related to investment in A = (80% * 1000) 100 = 700. Investments in A: 700 (Debit) Equity: 700 (Credit)
Note: The EPU adjustment impacts both assets and equity in the holding company.
For example, suppose that the holding company uses euros and the subsidiary uses dollars and the following conditions apply:
l
Exchange rate at the date of acquisition of A: 1 dollar = 1 euro Exchange rate at the date of the EPU adjustment: 1 dollar = 1.2 euro Investment in A at historical cost at historical rate: 100 euro Current equity of A at current rate = $1000 * 1.2 = 1,200 euro
The balance sheet of H is adjusted by the computed amount, similar to Example 1: Direct Ownership.
Note: In practice, the impact of exchange rate variations is probably cumulative, and these values
H owns 80% of A. Investment of H in A at historical cost: 400 Actual equity of A before any adjustment: 1000 A owns 30% of B Investment of A in B at historical cost: 70
Examples of Equity Pickup Adjustments 141
Actual equity of B: 500 The EPU calculation path starts with EPU adjustment in A:
Adjustment amount in A related to investment in B = (500 * .30) 70 = 80.
Investments in A: 80 (Debit) Equity: 80 (Credit) The balance sheet is adjusted as follows: Balance sheet of A before EPU adjustment:
l
Investment in B: 150 Other assets: 930 Total assets: 1080 Equity: 1080
After the EPU adjustment is posted in A, and the value of A's equity is adjusted to reflect the current value of its investment in B, the EPU adjustment related to the investment of H in A can be calculated. In this case, the formula to calculate the EPU adjustment is as follows:
Adjustment amount = (Percentage of ownership * Equity of entity owned after EPU adjustment) Investment at historical cost Adjustment in H = (1080 * .80) 400 = 464
Investments in A: 464 (Debit) Equity: 464 (Credit) The balance sheet is adjusted as follows: Balance sheet of H before EPU adjustment:
l
Investment in A: 400 Other assets: 1600 Total assets: 2000 Equity: 2000
Example 4: Cross-Ownership
In cases of cross-ownership or circular ownership, EPU adjustments must be calculated iteratively or through an equation. Example:
A owns 30% of B. A's equity value is 800. A's investment in B at historical cost is 70. B owns 40% of A. B's equity value is 500. Investment in A at historical cost is 200. In this case, the formula to calculate the EPU adjustment is as follows:
EpuA = (1/(10.40*0.30)) * ((80070) + 0.30 * (500200)) 800 EpuA = 131.82 EpuB = (1/(10.30*0.40)) * ((500200) + 0.4 * (80070)) 500 EpuB = 172.72
calculation status. Entity pairs with circular ownership are indicated by a circular icon in the Level column. The default point of view contains the default members for the current Scenario, Year, and Period dimensions. You can change the Point of View.
3 From the page drop-down lists, select how many items to display per page. 4 For the Manage EPU table, select row and column options. See Modifying the Display of the Manage Equity
Pickup Table on page 144.
Description Displays all possible combinations for the selected Owner/Owned entities. The percentage of ownership considered for EPU processing EPU calculation status
You can display labels, descriptions, or both labels and descriptions, and you can sort each column in ascending or descending order. You can filter rows using this criteria: Owner, Owned, Status, and %EPU. The %EPU amounts are positive amounts between 0 and 100, with decimals. You can include all pairs, exclude pairs with circular ownership, or include only pairs with circular ownership.
4 Select an option:
l
5 Click OK.
any EPU descendant of the Owned entity has changed. After EPU calculation, EPU status changes to OK, unless an additional change occurs due to another process. The Force Equity Pickup option runs EPU calculations on all pairs for the selected Scenario, Year, and Period, regardless of status. You can calculate EPU adjustments from the Manage Equity Pickup task, or from a data grid. To calculate EPU adjustments, you must be assigned the Allocation security role.
To calculate EPU:
1 Perform an action:
l
From the Manage Equity Pickup window, select Calculate, then Run Equity Pickup or Force Equity Pickup. From a data grid, right-click and select Run Equity Pick Up or Force Equity Pick Up.
2 Click Refresh.
1. For each pair of entities, the system calculates the owner and owned entities in the default currency. If the Calculation Status for Value Entity Curr Total is not OK or ND, the Calculate or Consolidate (if parent entity) process is run. 2. The system translates the Owned entity into the default currency of the Owner entity (if the value is not OK - already translated), and executes Calculate for Parent Curr Adjs if necessary (if Calculation status is not OK or ND). 3. The system runs the SUB EPU() routine in the Rule file. 4. The system calculates the Owner entity. If the Calculation status for Owner in Entity Currency is not ND, Calculate runs to set the entity to OK status. This final calculation should take place only if the Owner entity does not own the next pair and if new data was posted to the Owner entity. At the end of the calculation process, both the calculation and EPU status of the pair should be OK, unless another process changed the entities in the meantime.
10
In This Chapter
Opening Reports ................................................................................................................. 149 Viewing Reports .................................................................................................................. 150 Formatting System Reports ..................................................................................................... 151 Setting Report Descriptions from the Desktop ................................................................................ 154 Saving Reports ................................................................................................................... 154 Drilling Through to Intercompany Transactions................................................................................ 155 Printing Reports .................................................................................................................. 156 Deleting Reports ................................................................................................................. 156
Opening Reports
You can generate these types of Financial Management system reports:
l
Explore Data reports, which display information from data grids (on Windows Desktop only) Journal reports, which display information for a journal or list of journals based on criteria that you select in the Journals module Intercompany Partner (ICP) Matching reports, which display the intercompany transactions that are to be eliminated during consolidation Intercompany Transaction reports, which display a list of intercompany transactions IC Matching by Account reports, which display intercompany transactions based on selected accounts IC Matching by Transaction ID reports, which display intercompany transactions by transaction ID
You create reports using scripts. See the Oracle Hyperion Financial Management Administrators Guide. You can format, save, and print reports. You can also drill down from an Intercompany Matching Report to view intercompany transactions. You can open a report that is stored on a local computer or one that is stored remotely on a server. When you open reports that are stored on the server, you can select to show reports created by other users. You can only open reports on the server to which you have Read or All security access.
You can view the list of available reports by report type, or file type, and sort the list by report name or the date and time last modified. Windows Procedures
To sort by report name, click Report Name To sort by descriptions, click Report Description. To sort by date and time last modified, click Last Modified.
To open reports:
1 Select Administration, then Manage Documents, or click Manage Documents 2 From Report Type, select the report type to open. 3 From File Type, use the default option: Report Definition File. 4 Click the name of the report to open.
and select Reporting.
Viewing Reports
You can view reports that you create in the Journals and Explore Data modules, and reports that you create from System Reports on the Desktop. You can only view the reports on the server to which you have Read or All security access. The date, time, and user are automatically displayed as header information on all reports.
Windows Procedure
To view reports:
1 From the Financial Management Desktop, click System Reports. 2 Open a report. 3 Select View.
To run reports from the Journals or Explore Data modules, see Running Journal Reports on the Desktop on page 236 and Running Explore Data Reports on page 80. Web Procedure
To view reports:
1 Select Administration, then Manage Documents, or click Manage Documents 2 From Report Type, select a report type. 3 From File Type, use the default option: Report Definition File. 4 Click the name of a report.
and select Reporting .
BI Publisher reports provide these formats: PDF, RTF, HTML, and XLS. To customize the templates, you must install and configure Microsoft Office Word 2000 or later and Oracle BI Publisher Desktop. You can then use BI Publisher to customize templates and update reports. See Modifying BI Publisher Templates on page 152.
Note: If you want to retain a customized template when you upgrade or uninstall Financial
During the installation process, BI Publisher report templates are installed on the application server in the following directory: Hyperion_Home\products\FinancialManagement
\Server Working Folder\Report Style Sheets\Templates.
Style Sheets\Templates directory. For example, the Journals sample template is named journals.rtf.
4 If necessary for the report, select report overrides, and click OK.
Note: To print reports, see Printing Reports on page 156.
6 Optional: Preview your modifications. 7 Save the modified template to a new file name in the template directory that contains the sample templates:
Hyperion_Home\products\FinancialManagement\Server Working Folder\Report Style Sheets\Templates. Note: If you have multiple servers or clusters, you must store the templates on each server.
Windows Procedure
Saving Reports
You can save a report locally or on the server. When you save a report on the server, you can assign a security class to the report. To save a report on the server, you must be assigned the Save System Report on Server security role. The report name can contain a maximum of 20 characters. Do not use double quotation marks () or an equal sign (=) in the report name. Windows Procedures
Printing Reports
You can print reports that you created and saved on the local client computer or the server. When you select Print, the report is created based on the report selections. When you print an Intercompany Partner Matching report on the Web, you can choose to override the default report settings. For example, you could select a different partner entity for the report. You can also print the report using the default settings. Windows Procedure
To print reports:
1 Open a report and select View. 2 Right-click and select Print.
Web Procedure
To print reports:
1 From the list of reports, select the check box next to the report to print. 2 Click Print. 3 To override the values in the report, select the value to override, specify a new value, and click OK, or click
OK if you do not want to override any values.
Deleting Reports
You can delete reports that you no longer need. To delete a report from the server, you must have All access to the reports security class. Windows Procedure
Note: To delete a report from the root directory, skip this step.
3 Select the report to delete and click Delete. 4 At the system prompt, click OK.
Note: You can also delete folders, but you must first delete any reports that they contain.
11
In This Chapter
Intercompany Transaction Module Features................................................................................... 159 Intercompany Transaction Security Roles...................................................................................... 160 Sample Intercompany Transactions Task Flow ................................................................................ 161 Intercompany Transaction Load Files .......................................................................................... 162 Loading Intercompany Transactions............................................................................................ 165 Extracting Intercompany Transaction Files..................................................................................... 166 About the Process Transactions Window ...................................................................................... 166 Creating Intercompany Transactions ........................................................................................... 167 Viewing Intercompany Transactions ............................................................................................ 170 Editing Intercompany Transactions ............................................................................................. 174 Assigning Reason Codes to Intercompany Transactions ..................................................................... 174 Matching Intercompany Transactions .......................................................................................... 175 Unmatching Intercompany Transactions ....................................................................................... 185 Posting Intercompany Transactions ............................................................................................ 185 Unposting Intercompany Transactions ......................................................................................... 187 Viewing Intercompany Transaction Progress................................................................................... 188 Deleting Intercompany Transactions ........................................................................................... 188 Reporting on Intercompany Transactions ...................................................................................... 189 Running Transaction Detail Reports ............................................................................................ 189 Running Matching Reports ...................................................................................................... 192 Drilling Through to Transaction Details......................................................................................... 196 E-mail Alerts for Intercompany Transactions .................................................................................. 197
Intercompany Loans/Bonds
The Intercompany Transactions module provides an efficient way to identify, report, and reconcile intercompany account differences. With the ability to view detail transaction at any time, you can reconcile intercompany account differences frequently and thus minimize their impact on the closing cycle. The Intercompany Transaction module provides these capabilities:
l
Capture intercompany transaction details at the invoice level. Match transactions at the invoice level. Match transactions in the transaction currency and the reporting or parent currency. Drill down from an Intercompany Matching Report to the transaction details. Drill down from an account balance to transactional details through a data grid or data form on the Web. View an entity partners intercompany transaction details with the entity at any time. Enter text comments to help resolve mismatched entries. Analyze differences due to real errors in transaction currency or differences due to exchange rates. Lock data to prevent unauthorized input.
For intercompany administrative tasks, see the Oracle Hyperion Financial Management Administrators Guide.
Create transactions. Edit transactions. View list of transactions. Delete transactions. Load and extract transactions. Run transaction reports and matching reports. Drill through to transaction detail from other modules.
To perform matching tasks for transactions, you must be assigned one or more of these security roles for that task:
l
Intercompany Transaction Auto Match by Account Intercompany Transaction Auto Match by ID Intercompany Transaction Manual Match with Tolerance Intercompany Transaction Manual Match
To unmatch transactions, you must be assigned the Intercompany Transaction Unmatch security role. To post and unpost transactions, you must be assigned the Intercompany Transaction Post/ Unpost security role.
Sample Intercompany Transactions Task Flow Description The administrator defines reason codes in the application to be used for the intercompany matching process. Users can select from this list when processing intercompany transactions. Before you can perform any action on intercompany transactions, the administrator must open the transaction periods. During this process, the administrator also defines the Match/Validate Before Posting requirement and the matching tolerance to be used for the matching process. You can load transactions into the system using external ASCII files. You can also enter transactions manually. You can view the list of transactions in the Process Transactions window, change the entity and partner selections, and select other filtering criteria to view transactions. You can make changes to a transaction, such as adding comments to the transaction. You can run a transaction report to view a list of transactions based on the filter criteria. Before performing the matching process, you can run the matching report to see which transactions are to be matched. You can match transactions using the transaction ID or the reference ID. The system updates the transactions with a matched status and matched code. You can also save the matching settings to a matching template to be used later. This is another option to view the matching transactions report where the transactions are matched based on the accounts instead of a transaction or invoice.
Open period
Load transactions Process transactions Edit transaction Run transaction report Run matching report by transaction ID Auto-match by transaction ID Run matching report by account
Description This option is useful to match transactions when the application does not have an exact match of transaction ID and detail. To avoid a possible mismatch, you can perform automatching by ID first, then auto-matching by account. After you perform the auto-match process, you might find some transactions that should be matched even though they do not fit the matching criteria for the process. You can select certain transactions and manually match the transactions. The matching process updates the matched status and assigns a matched code. During the matching process, you might need to unmatch certain groups of transactions manually. When you select a transaction, the system displays the group of transactions that have the same matched code. You can then unmatch all transactions within the same matched group. After all transactions have been matched and you are ready to post the transactions to the system, you can select the transactions to post. After you post transactions, you can create a transaction report to view the status of each transaction. This report contains information on the posting status, and posting user, date and time. This can be used as a summary report so that you can quickly view the posting information. The administrator can lock entities to prevent users from adding new transactions or making changes to specific entities. When the entity is locked, no more matching can done for that entity, and no additional transactions can be posted for the entity. After you post transactions and the intercompany accounts reflect the account balance of these transactions, you can run the Intercompany Matching System Report to view the matching at the account level for individual transactions. When you are in a data grid or data form on the Web, you can view the corresponding intercompany transactions. You cannot modify transactions from data grids or forms.
Lock entities
Drill down to transaction details from the Intercompany Matching System Report Drill through to transaction details from data grids or data forms on the Web Close period
At the end of the closing cycle, the Intercompany Administrator closes the period for any additional modifications to the transactions for the period. The period is locked for any future transactions. However, you can continue to view transactions or run reports on transactions from the period.
Reason Code table: This section is loaded only if you have Intercompany Transaction Administrator security role access; otherwise, this section is ignored during the load. IC Transaction section: This section is used most frequently and is loaded if you have Intercompany Transaction User security role access.
During the load process, the system also does not load the posting or matching status from the load file.
Keywords for IC Transaction Load Files Description Indicates that the data represents intercompany detail. Indicates the order of the items in the file. (Optional). Indicates the delimiter used in the amount to separate the thousands. If this is not specified, the system uses the regional settings for the numeric value defined in the application server. (Optional). Indicates the character to be used for the decimal amount. If this is not specified, the system uses the regional settings for the numeric value defined in the application server.
Decimal
You can use any of the valid characters as long as that character is not used in the file name or in any other way in the file. For example, if you use the ampersand ( & ) in an entity member name, you cannot use the ampersand as the delimiter character. You must use the same delimiter character throughout the file. Using different delimiter characters within the same file causes an error when you load the file.
Note: If you are using an Oracle database, the system converts the transaction ID, sub ID,
reference ID, and reason code to upper case during the load process. For example, the system converts the t123 Transaction ID to T123 during the file load.
Example
!SCENARIO=Actual
!YEAR=2009 !PERIOD=January !DECIMAL=. !THOUSAND_SEPARATOR=, INTERCOMPANY DETAIL ! COLUMN_ORDER=ENTITY;PARTNER;ACCOUNT;C1;C2;C3;C4;TRANSID;SUBID;DATE;TRANSCUR R;TRANSAMT;ENTCURRAMT;RATE;REFID;COMMENT1;COMMENT2 China;France;ICPay;[None];[None];[None];[None];DE124;08/10/06;EUR;2000; 8000;Ref123;Text1234;Text9995 China;France;ICPurch;[None];[None];[None];[None];BX3212;08/12/06;EUR;2500; 10000; ;Text2345;Text8984 China;Germany;ICRef;[None];[None];[None];[None];AC4345;08/15/06;EUR;1700; 6970;ABC12;Text2323;Text9232 ...
Load Methods
When you load intercompany transactions, you can select to merge or replace the transactions.
Merge
Select this option to update the records with the new changes and create any new records. The system does not update any information in records with a Matched or Posted status. The load log file contains information about any transactions that were not loaded. The Merge mode does not delete any records in the database.
Table 17
Example of Load In Merge Mode Load File for Entity A N/A New Record 2 N/A New Record 4 New Record 5 New Record 6 Entity A After Load in Merge Mode Record 1 Record 2 - Matched (not affected by load process) Record 3 Record 4 - Posted (not affected by load process) New Record 5 New Record 6
Entity A - Existing Records Record 1 Record 2 - Matched Record 3 Record 4 - Posted Record 5 N/A
Replace
The Replace mode replaces all the transactions in the database for the given scenario, year, period, entity with the transactions specified in the load file. In the Replace mode, the system first clears all records for the entity for the scenario, year, period. If the system encounters any intercompany transactions for the entity that have a status of Posted or Matched, it does not clear those transactions; it skips them and continues with the load process. After clearing all applicable
164 Processing Intercompany Transactions
transactions for the entity, the system replaces all transactions for the entity with the records from the load file.
Table 18
Example of Load In Replace Mode Load File for Entity A N/A New Record 2 N/A New Record 4 New Record 5 New Record 6 Entity A After Load in Merge Mode N/A Record 2 - Matched (not affected by clear or load process) N/A Record 4 - Posted (not affected by clear or load process) New Record 5 New Record 6
Entity A - Existing Records Record 1 Record 2 - Matched Record 3 Record 4 - Posted Record 5 N/A
The scan and load status for each file is displayed in a new window.
5 Select one or more options in the extract process: UnMatched, Matched, MisMatched, Posted, UnPosted,
and Reason Codes.
6 To extract transactions with a specific transaction currency, from Transaction Currency Filter , select a
currency.
7 For Match Code, enter a match code value, or use the percent symbol (%) as a wildcard. 8 For Reason Code, select a reason code.
Tip: To extract a list of reason codes defined in your application, select the check box for
9 Click Extract. 10 Click the Click Here to Download link and select Save. 11 Enter a name for the extracted file and make sure that the location for the file is in the Web directory that
you set up.
Note: By default, transaction files use the TRN file extension.
12 Click Save.
Viewing Intercompany Transactions on page 170 Editing Intercompany Transactions on page 174 Matching Intercompany Transactions on page 175 Unmatching Intercompany Transactions on page 185 Posting Intercompany Transactions on page 185 Unposting Intercompany Transactions on page 187 Deleting Intercompany Transactions on page 188 Reporting on Intercompany Transactions on page 189
Transaction Detail Description Must be a valid scenario defined for the application. Must be a valid year defined for the application. Must be a valid base period defined for the scenario. This ID is required. You must enter an ID for the transaction, with a maximum of 40 characters. When combined with the Sub ID, this ID becomes a unique identifier for the entity/partner/account/ C1/C2/C3/C4 within the scenario/year/period combination. (Optional). You can enter a sub-ID for the transaction, with a maximum of 40 characters. This is useful if you need to handle one-to-many or many-to-many transactions between two entities. For example, if one transaction in the originating entitys book corresponds to multiple transactions in the partners book, you can use the Transaction ID for the common reference and use the Sub ID for the multiple transactions. Another use for the sub ID is when there is an adjustment needed to adjust the transaction in the Entity Currency instead of posting a journal adjustment in the Entity Curr Adjs. In this case, you can create a dummy transaction and use the same Transaction ID from the original invoice, but use the Sub ID to identify as an adjustment by entering ADJ1 in the sub ID to show that it is an adjustment instead of a real invoice.
Transaction Sub ID
Description (Optional). You can enter a reference ID to store any reference information for the transaction. For example, the entity might have its own set of invoice numbering that is different from the entity that issued the invoice. You can enter additional information in this Reference ID text box for information purposes only. You can also use the reference ID for the partners transaction ID. You can enter the entitys reference ID for the Transaction ID and enter the corresponding invoice number from the partner entity in this text box.
(Optional). This must be a valid date. The entity must be a valid ICP base entity, not a parent entity. The partner entity must be a valid ICP entity for the account. The account must be a valid ICP account and the cell must support transactions as specified in the Rules file. See the Rules section of the Oracle Hyperion Financial Management Administrators Guide. The custom member must be a valid custom member for the account. This is the invoice amount in the currency of the transaction. This is required only if the entity currency is not entered. This is the currency used for the Invoice transaction. It must be a valid currency defined in the application. This is the rate used to convert the transaction currency amount to the local reporting currency amount for the transaction. During the calculation of the local currency amount, if the operator is Divide, the system uses this formula: Local currency = transaction currency/rate. If the operator is Multiply, the system uses this formula: Local currency = transaction currency * rate. See the Oracle Hyperion Financial Management Administrators Guide.
Operator
The Multiply or Divide operator depends on the local currency of the transaction. You must first define the Multiply or Divide operation for a specific currency in the currency table of the application. The default value for the operator is Divide. See the Oracle Hyperion Financial Management Administrators Guide. This is the invoice amount in the local entity currency. The currency must be a valid currency defined in the application. This is required if the transaction amount is not entered. Otherwise, the system can recalculate this information if you enter the transaction amount and the conversion rate.
Comment 1 Comment 2
(Optional). You can enter comments for the transaction. You can enter a maximum of 256 characters. (Optional). You can enter additional comments for the transaction. You can enter a maximum of 256 characters. You can use Comment 2 to enter comments related to the partners transaction. For example, Entity A might enter comments in Comment 1 related to the transaction. Later, Entity A might run a matching report or view the partners transaction and realize that there are discrepancies with the partners amount. Entity A can then enter the additional comments in Comment 2 to state anything
Transaction Detail
Description related to the information in the partners record. This information is then part of the transaction and can be included in the matching report for informational or audit trail purposes. Note that while Comment can be used for partner information, only the entity can enter the information. The partner entity cannot enter information in the entitys record.
Reason Code
(Optional). The reason code must be a valid one defined by the administrator. The main purpose of the reason code is to indicate why a transaction has a MisMatched status; for example, because of a missing invoice from the partner entity, or an incorrect amount entered by the partner. If the transaction has a Matched status, you do not need to assign a reason code for the transaction. You cannot assign a reason code to a transaction with an UnMatched status.
6 Optional: For Transaction Sub ID, enter a sub identification for the transaction or invoice.
You can enter a maximum of 40 characters.
7 Optional: For Reference ID, enter reference information for the transaction.
You can enter a maximum of 40 characters.
8 Optional: For Transaction Date, enter a valid date, or click the pop-up calendar to select a date. 9 For Entity, enter an entity or click Pick Members to select a member. 10 For Partner Entity, enter a partner entity or click Pick Members to select a member. 11 For Account, enter an account or click Pick Members to select a member. 12 For Custom 1-4, enter a custom member or click Pick Members to select a member. 13 For Transaction Amount, enter the invoice amount and from Currency, select the currency used for the
transaction.
14 For Conversion Rate, enter the rate used to convert the transaction currency amount to the local reporting
currency amount.
Note: If you leave this text box empty and enter the entity currency amount, the system
15 For Entity Currency Amount, enter the invoice amount in the local entity currency, and enter the currency of
the reporting entity.
16 Optional: For Comment 1 and Comment 2, enter comments for the transaction.
In addition to the transaction detail that you entered, the transactions list displays systemgenerated information about the transaction that cannot be changed manually. For example, it displays the matching status, posting status, match code, user ID of the last user to modify the transaction, and the date and time the transaction was last modified. Matched transactions are indicated by double green boxes, and posted transactions are indicated by a green flag in the Status column. Mismatched transactions are indicated by a red triangle symbol.
You can set the Page setting by selecting the number of entries per page so that you can access a specific range of entries easily. If you change the row or column filter options to display a different range of transactions, you must reset the page setting.
The Selected Columns list shows a list of the columns as they are displayed from left to right in the Process Transactions window.
Tip: To return items to the Available Columns list, select items from Selected Columns, and
click
5 Optional: To move items up or down in Selected Columns, select an item, and click the up or down arrow. 6 If you selected to display Transaction Currency Amount and Entity Currency Amount, from the Common
Currency drop-down, you must select a currency for translation.
8 Click Close.
You can also specify a parent account and the system automatically enumerates all of the base members for that account. You can use the percent (%) symbol as a wildcard in these fields marked with an asterisk (*): Transaction ID, Transaction Sub ID, Reference ID, Match Code, or leave a text box blank to avoid filtering. The row settings are saved when you exit the session. If you do not specify row filters, the system displays all transaction rows.
172 Processing Intercompany Transactions
Note: Depending on the setup of your database, text boxes might be case-sensitive. For example,
filtering with testgroup might return different results than filtering with TestGroup.
5 From Include, select one or more options: Matched, Unmatched, Mismatched, Posted, or Unposted. 6 Optional: From Options, select a value for the Scale Factor and Decimal Override for the amounts displayed
for the transactions.
8 Click Close.
corresponding transactions for Entity B with Partner A, you can select to include both the Entity transactions and the Partner transactions.
partner in the transaction. You can also enter comments in the Comment 2 text box to add an explanation of the reason code assignment.
To assign a reason code to one transaction, from Reason Code, select a reason code. To assign a reason code to multiple transactions, select Edit, then Set Reason Code, select a reason code and click Set. The reason code that you select is assigned to all the selected intercompany transactions.
Auto-Matching Intercompany Transactions on page 179 Manually Matching Transactions with Tolerance Amount on page 180 Manually Matching Transactions without Tolerance Amounts on page 182
Auto-Match Process
The auto-match process performs the matching only on transactions with a status of UnMatched or MisMatched. These transactions must also be unposted transactions. When you select the auto-match process, you can select whether to match transactions by account, or by ID. You can filter the list to match only transactions with a specific transaction currency. Transactions that have been previously matched are excluded from the matching process because a match code has been assigned to those transactions.
After you include transactions in the matching process, the match status of the transactions becomes Matched or MisMatched. Any mismatched transactions can be included again in the auto-match process. When you auto-match intercompany transactions, a progress bar is displayed with the progress percentage, status, and last update time. You can also view the progress from the Running Tasks module. See Viewing Intercompany Transaction Progress on page 188.
Auto-Match by ID
Performing the auto-match process using the Transaction ID is the most common and accurate method of matching intercompany transactions. The system performs the matching process for the entity and partner that you specify. You can select the Transaction ID or the Reference ID for matching. The system matches the transactions based on the ID that you specify. You can specify an ID or use wildcards. If the ID is left blank, the system matches all transactions for the entity and partner. When matching transactions using the transaction ID or reference ID, the system always uses the transaction currency. There is no need to specify a tolerance amount because the transactions are considered Matched only if the amounts match without error. The system assigns a separate match code to each group of transactions. If you have transactions with different currencies but the same transaction ID or reference ID, during the auto-match process, the transactions are matched by currency group. If all the transactions in all the currency groups are matched, the system assigns one match code to all the transactions.
Table 20
Sample Transactions with Same ID and Different Currencies Entity A B A B Partner B A B A Currency EUR EUR USD USD
In this example, if the transactions in EUR are matched and the transactions in USD are matched, the system assigns one match code for all four transactions. If the transactions in EUR match but the transactions in USD are not matched, the system considers all of the transactions MisMatched. The following table shows the rules for matching transactions using IDs:
Table 21
Matching Process Using Transaction or Reference ID Entitys Transactions Transaction ID Partners Transactions Transaction ID Comments The system matches the entitys transaction ID with
Matching Process
Entitys Transactions
Partners Transactions
The system first matches the entitys transaction ID with the partners reference ID. If these do not match, the system performs the second test by comparing the entitys reference ID with the partners transaction ID. If still not matched, the system performs the third test by comparing the entitys reference ID with the partners reference ID.
Profit/Loss group
l
For each group of transactions, the system assigns a match status and separate match code. For example, the Balance Sheet group of transactions could have a Matched status and be assigned a match code, but the Profit/Loss group of transactions could have a MisMatched status. Example In the following example, the intercompany transactions all have the same transaction ID 123:
Entity A A B B
Partner B B A A
The system subdivides the transactions into the BS and PL groups as follows: BS Group A, B, Recltic, 100, Asset B, A, Payltic, 100, Liability Subgroup status: Matched. The system assigned a match code to this group. PL Group A, B, Sales, 110, Revenue B, A, COG, 100, Expense Subgroup status: MisMatched. No match code is assigned to this group.
Auto-Match by Account
In addition to performing the matching process using the transaction ID, you can match the transactions based on specific accounts and matching accounts. The system performs the matching process for the entity and partner that you specify. The transactions to be matched are grouped by transaction currency during the matching process and are assigned a separate match code for each currency group. For each transaction included in the matching process, the system first translates the transaction currency amount to the application currency, based on the default translation rules set up for the application. The translated amount is added to the total difference amount. The system performs the translation for each transaction in the auto-match process and the difference amount is calculated.
Note: The conversion rate used in translation is the rate that is stored in the Rate account for
the specific currency to the application currency. After the total difference amount is calculated, this amount is compared to the matching tolerance amount set for the period. The matching tolerance amount is represented in the application currency and the amount should be entered in the scale of the application currency. If the difference amount is within the tolerance level, the transactions are considered matched and the system assigns a match code to the group of transactions.
If the different amount is not within the tolerance level, the system performs the next step in the translation process by translating the entity currency amount to the application currency. For any transactions without a transaction currency, the system uses the entity currency amount. If the difference amount is within the tolerance level, the transactions are considered matched and the system assigns a match code to the group of transactions.
8 To auto-match by specific currency, select Include During Processing, and from the Only if Transaction
Currency = drop-down list, select a currency.
9 Select an option:
l
Match by ID, select Transaction ID or Reference ID, and enter an ID or use a wildcard. Match by Account, click Add to select the account dimension members or custom members, and in the Matching Accounts section, click Add to select the matching account dimension members or custom members.
Tip: You can click Remove to remove accounts and matching accounts.
To create an Auto-Match template, you must be assigned the Intercompany Transaction Match Template security role.
If the amount is within the tolerance level, the transactions are considered Matched and the system assigns a match code to the group of transactions. See Matching Status on page 183 and Match Code on page 184. If you have the Manual Match security role, the system does not check the tolerance amount. See Manually Matching Transactions without Tolerance Amounts on page 182. During the manual match process, transactions are not grouped by transaction currency. Therefore, you can select transactions in different transaction currencies and the system translates each transaction separately.
Profit/Loss group
l
Example In the following example, the intercompany transactions all have the same transaction ID 123:
Entity A A B B
Partner B B A A
The system subdivides the transactions into the BS and PL groups as follows: BS Group A, B, Recltic, 100, Asset B, A, Payltic, 100, Liability Subgroup status: Matched. PL Group A, B, Sales, 110, Revenue B, A, COG, 100, Expense Subgroup status: MisMatched. The result is that because only one subgroup is matched and the other is not, the system considers all transactions mismatched, and assigns all transactions in this manual match process a MisMatched status and no match code.
Matching Status
Intercompany transactions can have one of these matching statuses: UnMatched, Matched, or MisMatched. The matching status is updated by the system and cannot be changed manually. When you create or load a transaction, it has a default status of UnMatched. If the transaction is included in the auto-match process, the transaction is updated to Matched or MisMatched status. The MisMatched status means that the matching process has been done for the transaction but it was not matched, or was not within the matching tolerance level as defined for the application. You can resolve this by rerunning the auto-match process or by manually matching. See Auto-Matching Intercompany Transactions on page 179 and Manually Matching Transactions with Tolerance Amount on page 180. Changes from UnMatched to Matched or MisMatched During the auto-match or manual process, unmatched transactions can be changed to Matched or MisMatched status. Changes from MisMatched to UnMatched If a transaction has gone through the auto-match process and has a status of MisMatched, any changes to the transaction (with the exception of the comments and reason code) change the status to UnMatched. This applies to both manual entry and loading transactions.
Changes from Matched to UnMatched Since the system does not allow changes to matched transactions except for comments and reason code, you cannot change the matched status by manual entry or loading transactions. However, you can perform the Unmatch process manually, and the Matched status can be changed to UnMatched status.
Match Code
When you create a transaction, it has a status of UnMatched and a default of blank for the Match Code. After you perform the matching process, the system changes the matching status to Matched and generates a match code. It is for display only and you cannot change it manually. The same match code applies to all the matching transactions in a group. For example, if you match the following transactions, the same code applies to all the transactions in this group. If there are reversed transactions, the system considers them a separate group and assigns them a separate match code. During the match by ID process, the system subdivides all the intercompany transactions with the same transaction or reference ID into separate groups based on their account type. It then assigns a separate match code and match status to each group of transactions with the same ID. See Account Type Groups in the Auto-Match Process on page 177. When the system generates the match code during the matching process, it uses one of these prefixes to distinguish the different types of matching processes:
l
A - Auto-matching performed using accounts I - Auto-matching performed using the transaction ID R - Auto-matching performed using the reference ID M - Manual matching performed
Table 22
Match Code Example Partner B B A A Account ICRec1 ICRec2 ICPay1 ICPay2 Tran ID XY234 XY235 XY234 XY235 Tran Amt 100 300 100 300 Match Status Matched Matched Matched Matched Match Code A11 A11 A11 A11
Entity A A B B
For the Match by Account process, you can select the option to group by transaction currency. If one group of transactions has a different transaction currency than another group, the system generates separate match codes for the different groups.
4 Click Close.
When the unmatch process is completed, the match status for these transactions is Unmatched and the match code changes to blank.
amount has not yet been recorded in the ICRec account. The ICRec account balance is still zero until the transaction is posted. When the selected intercompany transactions are posted to the account, the system updates the status of the transactions to Posted, and the total transaction amount is reflected in the account balance. To post a transaction, you must be assigned the Intercompany Transaction Post/Unpost security role. If the period is set up with the Match/Validate requirement before posting, the system checks the transactions before posting to ensure that only transactions with the Matched status, or MisMatched status with a reason code, are posted to the account balance. If this requirement is not set for the period, no validation is needed. See the Oracle Hyperion Financial Management Administrators Guide. When you select Post All to post all transactions, a progress bar is displayed with the progress percentage, status, and last update time. You can also view the progress from the Running Tasks module. See Viewing Intercompany Transaction Progress on page 188. After an intercompany transaction has a status of Posted, no more changes can be made to it. If you need to make changes to the posted transaction, you must unpost it, make the changes, then match and post the transaction again. See Unposting Intercompany Transactions on page 187.
Posting Process
During the posting process, the system accumulates the transactions related to a particular account cell and accumulates the amount to the account balance. For example, if you have two transactions with a total of 100 for the ICRec account, the system applies the total amount of 100 to the ICRec account balance. If this is the first transaction, the ICRec account has a balance of 100. If you later post four transactions to this account for a total amount of 300, after posting, the ICRec account has a balance of 400, because the system adds the amount to the account balance. The system posts transactions to the Entity Currency Value dimension. If the account is a Balance type, the system posts the amount as YTD view regardless of the default view of the scenario.
From Process IC Transactions, select the point of view, and review the Status column for posted transactions. From Process IC Transactions, select the point of view, and sort by Post status. See Displaying Transaction Columns on page 171. From a Web data grid, drill down to view the transactions. See Drilling Through to Intercompany Transactions on page 103. From a data form, drill down to view the transactions. See Drilling Through to Intercompany Transactions on page 129.
To unpost a transaction, you must be assigned the Intercompany Transaction Post /Unpost security role. During the unpost process, the system reverses the amount out of the account balance and changes the status from Posted to Unposted. Unposting the transaction does not affect the matching status. When you select Unpost All to unpost all transactions, a progress bar is displayed with the progress percentage, status, and last update time. You can also view the progress from the Running Tasks module. See Viewing Intercompany Transaction Progress on page 188.
From the Process Intercompany Transactions page, view the progress bar for the task that is running. From the Running Tasks page, select the task from the Task Filter , and click View to view the progress.
or MisMatched. You cannot delete posted or matched transactions. Any posted transactions must be unposted first, and any matched transactions must be unmatched before you can delete them. You must be assigned the Intercompany Transaction User security role to delete transactions. When you select Delete All to delete all transactions, a progress bar is displayed with the progress percentage, status, and last update time. You can also view the progress from the Running Tasks module. See Viewing Intercompany Transaction Progress on page 188.
Transaction Detail Report, a system report (list) of transactions. See Running Transaction Detail Reports on page 189. Matching Report by Account, a matching report based on accounts selected. See Running a Matching Report by Account on page 194. Matching Report by Transaction ID, a matching report based on transaction ID. See Running a Matching Report by Transaction ID on page 195.
When you run a Transaction Report, Matching Report by Account, or Matching Report by ID, a progress bar is displayed with the progress percentage, status, and last update time. You can also view the progress from the Running Tasks module. See Viewing Intercompany Transaction Progress on page 188.
Formatting System Reports on page 151. You can create a Transaction Detail Report by these methods:
l
Using the Report Wizard. See Running Transaction Detail Reports on page 189.
Reporting on Intercompany Transactions 189
Writing a script in a text file. See the Oracle Hyperion Financial Management Administrators Guide.
Note: The output of this report is a list of selected transactions with various sorting and
grouping capability. This is not the matching report for reconciliation purposes. See Running Matching Reports on page 192.
To print or preview the report, click Print/Preview. To save the report locally, click Save Local. To save the report remotely on a server, click Save Remote.
Entity Column with Repeat Option Selected Partner B B B C D Account ICRec1 ICRec2 ICPay1 ICRec1 ICRec2
Entity A A A B B
Table 24
Entity Column without Repeat Option Selected Partner B B B C D Account ICRec1 ICRec2 ICPay1 ICRec1 ICRec2
Entity A A A B B
The Selected Columns list shows a list of the columns as they are displayed from left to right on the report.
Tip: To return items to the Available Columns list, select items from Selected Columns, and
click
6 Optional: To move items up or down in Selected Columns, select an item and click the up or down arrow. 7 If you selected to display Transaction Currency Amount and Entity Currency Amount, from the Common
Currency drop-down, you must select a currency for translation.
9 Click Close.
6 Click Close.
You can select columns and rows to display on the report, and change the column sort order. You can create a Matching Report by these methods:
l
Using the Report Wizard. See Running a Matching Report by Account on page 194. Writing a script in a text file. See the Oracle Hyperion Financial Management Administrators Guide.
General Options
You use the General Options tab to define the entity and partner information for the Matching Report. You can select single or multiple members and a list for the entity and partner selection. If you do not select any members for the entity and partner, the system displays transactions for all entities and partners. In addition to the entity and partner selection, you must specify the matching currency to use for the Matching Report.
Suppressing Details
If you want the Matching Report to display only the subtotal amount, you can select an option to suppress the intercompany details. When you select this option, the report displays only the total difference for each entity/partner section. If there is a discrepancy and you need to view each intercompany transaction, you can regenerate the report and show intercompany details.
Matched using Transaction Currency Amount Matched using Matching Currency Amount
Note: If both options are selected, the system suppresses the transaction only if both
conditions are met. Since the matching tolerance amount is always entered in the matching report currency and is in the scale of the matching report, the system must first translate the transaction currency
Running Matching Reports 193
amount or the entity currency amount, and the total difference is then compared to the matching tolerance amount. If you select to suppress matched transactions using the transaction or matching currency, the system suppresses the transactions if the entity and partner amounts are within the matching tolerance amount that you specify. For example, if an entity has an amount of 299 and the partner has 200, the difference is 99. If the matching tolerance amount is 100 and the difference between the entity and partner is less than 100 as in this example, the system suppresses the transactions because it is within the matching tolerance.
Account Options
You use the Account Options tab to define the accounts and matching accounts for the Matching Report. You can insert additional accounts and select accounts from the Member Selection dialog box.
Display Options
You can define the information to display in the report columns. For example, you can display transaction IDs, matching status, reason codes, and comments. In addition, you can select whether to display dimension member labels, descriptions, or both, and you can display the scale factor and decimal override.
6 Optional: From Style Sheet, select a report style sheet. 7 From Security Class, select a security class for the report, or use the Default security class. 8 From the Point of View bar, select a scenario, year, and base period. 9 For Entity, enter an entity or click Browse to select an entity. 10 For Partner, enter a partner entity or click Browse to select a partner entity. 11 From Matching Currency, select a currency, or leave it blank. 12 Optional: From Suppress, select Details or Matched, and enter a tolerance amount if required. 13 From Include During Processing, select one or more match statuses: Matched, Unmatched, or
MisMatched, and one or both post statuses: Posted or Unposted.
14 Optional: To filter by transaction currency, select Only if Transaction Currency = , and enter the currency. 15 From Accounts, click Add to select the Accounts and Matching Accounts to display on the report, or
Remove to remove accounts from the report.
16 Select Display Options, and from Display, select the items to display on the report. 17 From Options, select one or both options:
l
To display the dimension member label, select Member Label . To display the dimension member description, select Member Description.
18 Optional: From Options, select a value for the Scale Factor and Decimal Override for the amounts displayed
for the transactions.
19 Select an option:
l
To print or preview the report, click Print/Preview. To save the report locally, click Save Local. To save the report remotely on a server, click Save Remote. To close the report dialog box, click Close.
3 From Reports , select By Transaction ID. 4 From General, enter a report name. 5 Optional: Enter a report description. 6 Optional: From Style Sheet, select a report style sheet. 7 From Security Class, select a security class for the report, or use the Default security class. 8 From the Point of View bar, select a scenario, year, and base period. 9 For Entity, enter an entity or click Browse to select an entity. 10 For Partner, enter a partner entity or click Browse to select a partner entity. 11 From Matching Currency, select a currency, or leave it blank. 12 From ID, select an option and enter the IDs:
l
13 Optional: From Suppress, select Details or Matched and enter a matching tolerance amount if required. 14 From Include During Processing, select items to include on the report. 15 Optional: To filter by transaction currency, select Only if Transaction Currency = and enter the currency. 16 Select Display Options, and from Display, select the items to display on the report. 17 From Options, select one or both options:
l
To display the dimension member label, select Member Label. To display the dimension member description, select Member Description.
18 Optional: From Options, select a value for the Scale Factor and Decimal Override for the amounts displayed
for the transactions.
19 Select an option:
l
To print or preview the report, click Print/Preview. To save the report locally, click Save Local. To save the report remotely on a server, click Save Remote. To close the report dialog box, click Close.
Drill through from an Intercompany Matching Report (account balance level). See Drilling Through to Intercompany Transactions on page 155. Drill through from Web data grids. See Drilling Through to Intercompany Transactions on page 103. Drill through from Data Forms. See Drilling Through to Intercompany Transactions on page 129.
12
In This Chapter
Using Journals
About Journals ................................................................................................................... 199 Journal Security Roles ........................................................................................................... 200 Setting Up Journals .............................................................................................................. 200 Using Journal Templates ........................................................................................................ 201 Managing Journal Periods....................................................................................................... 209 Processing Journals.............................................................................................................. 210 Creating Journals................................................................................................................. 212 Scanning Journals ............................................................................................................... 217 Journal Status .................................................................................................................... 218 Managing Journal Groups ....................................................................................................... 218 Viewing Journal Lists............................................................................................................. 219 Editing Journals .................................................................................................................. 222 Selecting Dimension Members for Journal Detail ............................................................................. 223 Submitting Journals.............................................................................................................. 226 Unsubmitting Journals ........................................................................................................... 227 Approving Journals............................................................................................................... 228 Rejecting Journals................................................................................................................ 229 Posting Journals.................................................................................................................. 231 Unposting Journals............................................................................................................... 232 Reviewing Journals............................................................................................................... 233 Journal Validation ............................................................................................................... 234 Viewing Automated Consolidation Journals ................................................................................... 235 Running Journal Reports ........................................................................................................ 236 Deleting Journals................................................................................................................. 241
About Journals
After you load or enter data into the database, you might need to make adjustments to it. Journals enable you to make adjustments to accounts after the data is loaded or entered. They provide an audit trail of changes made in the application and indicate the accounts, entities, and periods that were affected.
You can create balanced journals, unbalanced journals, recurring journals for future periods, or auto-reversing journals to create reversing journal entries. In addition, you can use journal templates to post journals that have common adjustment information.
Journals Administrator (unrestricted journals access) Manage Templates Create Journals Create Unbalanced Journals Generate Recurring Read Journals Approve Journals Post Journals
To assign security roles, see the Oracle Hyperion Financial Management Administrators Guide.
Setting Up Journals
Before you process journals, you can create templates and perform these tasks:
l
Create, edit, and delete journal templates. View and sort lists of journal templates. Open and close periods.
You can also use the Set Up Journals module to create journals using recurring templates. See Creating Journals Using Recurring Templates on page 216.
To start Set Up Journals from the Financial Management Desktop, click Set Up Journals.
Note: To exit the Set Up Journals module, select another task from the navigation frame on the
Desktop.
Journal Templates: Create, edit, and delete standard and recurring journal templates, create journals using recurring templates, and view lists of journal templates. Manage Periods: View the status of periods, and open and close periods
Standard templates, which contain accounts and entities for adjustments that you enter frequently. See Creating Standard Journal Templates on page 201. Recurring templates, which contain complete information for identical journal entries that recur for more than one period. See Creating Recurring Templates on page 203.
Templates apply to all scenarios in an application. They are not dependent on scenario and year. Recurring templates are dependent on the Value dimension member. To access templates, you must be assigned the Manage Templates security role. See these procedures:
l
Viewing Template Lists on page 205 Editing Journal Templates on page 207 Creating Journals Using Recurring Templates on page 216 Deleting Journal Templates on page 208
entities or accounts, and use the template as the basis for journals that contain similar adjustment information. When you create a template, you select whether the journal is balanced, balanced by entity, or unbalanced. In a balanced journal, the total debits and credits must balance per journal entry before you can post the journal. In a balanced by entity journal, the debits and credits must balance for each entity included in the journal entry. In an unbalanced journal, the debits and credits do not need to balance before you can post the journal. Windows Procedure
not use these characters: . + - */ # {} ; , @ The description is optional and can be a maximum of 255 characters.
7 Select a balance type: Balanced, Unbalanced, or Balanced by Entity. 8 Optional: Enter a Journal Group for the journal
Note: The journal group that you assign must exist in the application.
9 Select the point of view. See Selecting Dimension Members for Journal Detail on page 223. If you select
the Use Single Entity option, you must select an entity.
Tip: You can also double-click a blank cell or an area of a cell not occupied by text to bring up
the Point of View dialog box. If the cell contains text, you must double-click within the cell to the right of any text to activate the Point of View dialog box.
10 Optional: Enter debit or credit amounts and a description. 11 Click OK. 12 Optional: To create additional templates from the Edit Template dialog box, click
dialog box and repeat steps 5 through 11. at the bottom of the
Web Procedure
2 Select Manage Journal Templates. 3 Select Standard and click New. 4 Enter a template label.
Note: The label can contain a maximum of 20 characters. Do not include spaces in the label and
6 From Balance Type, select a balance type: Balanced, Unbalanced, or Balanced by Entity. 7 Optional: From Security, select a security class. 8 Optional: Enter a template description. 9 For each dimension, enter a member or click Pick Members to select members.
Tip: You can also double-click the dimension to display the Pick Members dialog box, or you
can right-click and select Pick Members. When you select an account, only the valid ICP or Custom members for that account are displayed.
10 Enter an adjustment in the Debit or Credit column. 11 Take one of these actions:
l
To add rows to the template, click Add Rows. Rows are added to the bottom of the grid. To save the template, click Save. To restore the last saved version of the template, click Reset. To preview and print the template, click Print.
Note: The label can contain a maximum of 20 characters. Do not include spaces in the label and
do not use these characters: . + - */ # {} ; , @ The description is optional, and can be a maximum of 255 characters.
5 From Value, select a journal value. 6 Select a Balance type: Balanced, Unbalanced, or Balanced by Entity. 7 Optional: Enter a journal group for the journal.
Note: The journal group that you assign must exist in the application.
8 Select the point of view. See Selecting Dimension Members for Journal Detail on page 223.
Note: If you select the Use Single Entity option, you must select an entity.
9 Enter the accounts, debit or credit amounts, and a description for the detail, and click OK.
Note: The description is optional.
10 Optional: To create additional templates from the Edit Template dialog box, click
dialog box and repeat the steps to create a template.
5 From Balance Type, select a balance type: Balanced, Unbalanced, or Balanced by Entity. 6 Optional: From Security Class, select a security class. 7 Select a Value dimension for the journal. 8 Optional: Enter a template description. 9 For each dimension, enter a member or click Pick Members to select members.
Tip: You can also double-click the dimension to display the Pick Members dialog box, or you
can right-click and select Pick Members. When you select an account, only the valid ICP or Custom members for that account are displayed.
10 Enter an adjustment in the Debit or Credit column, and take one of these actions:
l
To add rows to the template, click Add Rows. Rows are added to the bottom of the template.
To save the template, click Save. To restore the last saved version of the template, click Reset. To preview and print the template, click Print.
To view template lists, in the File Browser, expand Tasks, select Journal Tasks, and select Manage
Journal Templates.
3 From Display Columns, select the columns to display. 4 Drag the selected column to Displayed, or click
.
In Displayed, drag the columns to rearrange their order. In Set Up Journals, drag the columns to rearrange their order.
6 Click OK.
3 From Displayed, select the columns by which to sort. 4 Drag the selected column to Sorted or click
Tip: To select all columns, click
.
, and select Ascending or
5 To change the sort order, select the column to change, click Sort Order
Descending.
6 Click OK.
4 To change the sort order for each column, from Sort, select Ascending or Descending. 5 Click OK.
sensitive. For example, filtering with testgroup might return different results than filtering with TestGroup.
Web Procedure
Web Procedure
Viewing Periods
You can filter the list of journal periods by selecting a scenario and year and by selecting the period status; for example, Opened, Closed, or Unopened. Windows Procedure
To view periods:
1 Click Set Up Journals. 2 On the Set Up Journals process bar, click Manage Periods. 3 From Scenario and Year , select a scenario and year for which to view periods. 4 Select the periods to view: Opened, Closed, or Unopened.
Web Procedure
To view periods:
1 In the Browser View, expand Tasks and select Journal Tasks. 2 Select Manage Periods. 3 From Scenario and Year, select a scenario and year for which to view periods.
By default, all periods have an initial status of Unopened. You can open and close periods as needed. However, after you open a period, it can never revert to the Unopened status. You cannot close a period if there are unposted auto-reversals in the period. If you close a period that contains approved journals, a warning message is displayed. Windows Procedure
Click Open to open the selected periods. Click Close to close the selected periods.
Web Procedure
To open the selected periods, click Open. To close the selected periods, click Close.
Processing Journals
After you set up journals, you can enter journal information and process journals. See these procedures:
l
Creating Journals on page 212 Scanning Journals on page 217 Viewing Journal Lists on page 219 Editing Journals on page 222 Submitting Journals on page 226
Unsubmitting Journals on page 227 Approving Journals on page 228 Rejecting Journals on page 229 Posting Journals on page 231 Unposting Journals on page 232 Reviewing Journals on page 233 Running Journal Reports on page 236 Deleting Journals on page 241
From the Financial ManagementDesktop, click Process Journals. From the Web, in File Browser, expand Tasks and select Journal Tasks, and select Manage Journal Templates.
Note: To exit the Process Journals module, select another task from the navigation frame
Journals Process Bar Buttons Tasks View and open journals with Working and Rejected status, and create, edit, and submit journals for approval.
Button
View and open journals with Submitted status, and edit, unsubmit, and approve journals for posting, or reject journals. A journal must be approved before you can post it to the database.
View and open journals with Approved status, post a journal to the database, or reject journals. A journal must be submitted and approved before you can post it to the database.
View and open journals with Posted status, and unpost a journal from the database.
Button
Tasks View and open journals with all statuses, submit, unsubmit, approve, reject, post, and unpost journals. Depending on your security rights, you can also process journals directly from Working to Posted status.
Creating Journals
You use journals to enter adjustments to account balances and maintain an audit trail of changes to your data. You create journals by entering a journal label and description, balance type, point of view, and adjustment amounts. You can create single entity or multiple-entity journals. You can also enter a security class for the journals, and a journal group that you can use to filter and sort journals. After you create a journal, its status is Working. Before you create a journal, check the point of view to be sure that the scenario, year, period, and value are the ones to which you want to enter adjustments. See Opening and Closing Periods on page 209. When you enter adjustments, you can scan the detail lines and ensure that the lines are valid. In this way, you can make any necessary changes before you post the journal. See Scanning Journals on page 217. In addition to standard journals, you can create auto-reversing journals. You can also create journals using a recurring or standard template. See Creating Auto-reversing Journals on page 214 and Using Journal Templates on page 201. Windows Procedure
If you are not creating a journal from a template, select Start with Blank Journal. If you are creating a journal from a template, deselect Start with Blank Journal and select a journal template from the template list.
5 Optional: To create a journal for one entity, select Create Single Entity Journal. 6 Click OK. 7 Enter a journal label and description.
Note: The label can be a maximum of 80 characters. Do not use these characters: . + - */ # {} ; ,
9 Select a balance type: Balanced, Unbalanced, or Balanced by Entity. 10 Optional: Enter a journal group for the journal.
Note: The journal group that you assign must exist in the application.
11 Select the point of view. See Selecting Dimension Members for Journal Detail on page 223.
Note: If you selected Create Single Entity Journal from the New Journal dialog box, the line
items do not include parent and entity. You must select an entity in the header point of view at the top of the journal.
12 Enter an adjustment amount in the Debit or Credit column, and enter an adjustment description in the
Description column.
Note: The description is optional.
13 Click OK. 14 Optional: To create additional journals from the Edit Journal dialog box, click
at the bottom of the dialog box and repeat steps 7 through 13. When you use this method, the New Journal dialog box is not displayed.
Web Procedure
To create a journal from a template, click Create from a template, select the template from the list, and click OK. If you are not creating a journal from a template, select Start with Blank Journal, and click OK. To create a journal for one entity, select Create as Single Entity Journal, and click OK.
Note: When you create a single-entity journal, the system displays the corresponding
currency in the top right of the detail window for the entity being adjusted. The system displays the currency of the entity or the parent, depending on the type of adjustment.
# {} ; , @
Note: The journal group that you assign must exist in the application. See Viewing Journal
7 From Balance Type, select a balance type: Balanced, Unbalanced, or Balanced by Entity. 8 Optional: From Security class, select a security class. 9 Optional: Enter a journal description. 10 For each dimension, enter a member or click Pick Members to select members.
Tip: You can also double-click the dimension to display the Pick Members dialog box, or you
can right-click and select Pick Members. When you select an account, only the valid ICP or Custom members for that account are displayed.
12 Optional: To scan the detail lines and ensure that the lines are valid, click Scan. See Scanning Journals
on page 217.
To add rows to the journal, click Add Rows. Rows are added to the bottom of the grid. To save the journal, click Save. To restore the last saved version of the journal, click Reset.
Windows Procedure
If you are not creating a journal from a template, select Start with Blank Journal. Clear Start with Blank Journal and select a journal template from the template list.
6 Optional: To create a journal for one entity, select Create Single Entity Journal. 7 Click OK. 8 Enter a journal label and description.
Note: The label can contain a maximum of 80 characters. Do not use these characters: . + - */
9 Select a balance type: Balanced, Unbalanced, or Balanced by Entity. 10 Optional: Enter a journal group for the journal.
Note: The journal group that you assign must exist in the application.
11 Select the point of view. See Selecting Dimension Members for Journal Detail on page 223.
Note: If you selected Create Single Entity Journal from the New Journal dialog box, the line
items do not include Parent and Entity. You must select an entity in the header point of view at the top of the journal.
12 Enter an adjustment amount in the Debit or Credit column, enter an adjustment description in the Description
column, and click OK.
Note: The description is optional.
13 Optional: To create additional journals from the Edit Journal dialog box, click
box and repeat the steps to create a journal.
When you use this method, the New Journal dialog box is not displayed. Web Procedure
3 Set the journal point of view and click New. 4 Click Auto-reversing, and select an option:
l
To create a journal from a template, click Create from a template, select the template from the list, and click OK. If you are not creating a journal from a template, select Start with Blank Journal, and click OK. To create a journal for one entity, select Create as Single Entity Journal, and click OK.
# {} ; , @
7 From Balance Type, select a balance type: Balanced, Unbalanced, or Balanced by Entity. 8 Optional: From Security class, select a security class. 9 Optional: Enter a journal description. 10 For each dimension, enter a member or click Pick Members to select members.
Tip: You can also double-click the dimension to display the Pick Members dialog box, or you
can right-click and select Pick Members. When you select an account, only the valid ICP or Custom members for that account are displayed.
12 Optional: To scan the detail lines and ensure that the lines are valid, click Scan. 13 Take one of these actions:
l
To add rows to the journal, click Add Rows. Rows are added to the bottom of the grid. To save the journal, click Save. To restore the last saved version of the journal, click Reset.
The system uses the security class assigned to the template as the security class for the journal. If you need to modify the security class assignment for the journal, you must reject the journal and then resubmit it. To edit a journal, you must have All access to the security class assigned to the journal. To modify the template, you must have All access to the security class assigned to the template. Windows Procedure
Scanning Journals
When you enter adjustments, you can scan the detail lines and ensure that the lines are valid. In this way, you can make any necessary changes before you post the journal. When you run a scan, if the journal contains errors, a separate window is displayed with the scan results by row number. If all of the entries are valid when you run a scan, no message is displayed.
To scan journals:
1 Create a journal or open a journal. 2 Click Scan. 3 Review the results, and click Back to Journal.
Journal Status
The journal status indicates the current state of the journal. The status of a journal changes when you create, submit, approve, reject, or post the journal. The following table describes the journal statuses:
Table 26
Journal Statuses Description Journal is created. It has been saved, but it can be incomplete. For example, it might need to have a label or single entity assigned. Journal is submitted for approval. Journal is approved for posting. Journal is rejected or unposted. Journal adjustments are posted to the database.
The journal actions that are available from the Process drop-down list depend on the journal status. For example, if the journal has a status of Approved, the only actions available are Reject or Post.
Creating Journal Groups on page 218 Removing Journal Groups on page 219
2 Select Manage Groups. 3 For New Group Label, enter group name.
Note: Group labels can contain up to 30 alphanumeric characters and spaces and cannot use
Select one or more journal groups to remove and click Remove. Click Remove All to delete all journal groups.
Web Procedure
To view the journal list, in the Browser View, expand Tasks and select Journal Tasks, and select
Process Journals.
3 From Display Columns, select the columns to display. 4 Drag the selected column to Displayed or click
Tip: To select all columns, click
In Displayed, drag the columns to rearrange their order. On the Process Journals, workspace, drag the columns to rearrange their order.
6 Click OK.
.
, and select Ascending or
6 To change the sort order, select the column to change, click Sort Order,
Descending.
7 Click OK.
sensitive. For example, filtering with testgroup might return different results than filtering with TestGroup.
5 Optional: Enter a journal label by which to filter journals. 6 Optional: Enter a journal group by which to filter journals. 7 Optional: Enter a journal description by which to filter journals. 8 Optional: Select a status, type, or balance type by which to filter journals. 9 Click OK.
For each column that you select to display, you can also select whether to sort the column in ascending or descending order.
sensitive. For example, filtering with testgroup might return different results than filtering with TestGroup.
Editing Journals
You can edit a journal that you previously created. For example, you can change the description of a journal, insert rows in a journal to add adjustments, or change the balance type. You can edit only Working, Submitted, and Rejected journals. You cannot edit Approved or Posted journals. You must have All security access to the security class for a journal to edit the journal. See the Oracle Hyperion Financial Management Administrators Guide.
Windows Procedure
To edit journals:
1 Click Process Journals. 2 Select Working, Submitted, or Rejected on the process bar to view journals with those statuses.
Tip: To view journals with all statuses, select Advanced on the process bar.
3 From Process Journals, select a scenario, year, period, and value. 4 Double-click the selected journal, or select the journal and click Open. 5 Edit the journal information.
Tip: For a single entity journal, you can change the entity by clicking the member name in the
6 Click OK.
Web Procedure
To edit journals:
1 On the Process Journals page, set the journal point of view. 2 From the list of journals, select a journal with a status of Working, Submitted, or Rejected by clicking the
journal label.
Tip: You can also select the check box next to the journal, and click Open.
3 Change the dimension members or edit the line items. 4 Optional: To scan the detail lines and ensure that the lines are valid, click Scan. 5 Click Save to save your changes, or click Reset to restore the last saved version of the journal. 6 Click Close.
The system displays entities based on the Value dimension that you select for the journal. If the selected Value dimension is Entity Currency Adjs or Parent Currency Adjs, the system displays a list of entities that have the Allow Adjustments application attribute enabled. If the selected Value dimension is Contribution Adjs or Parent Adjs, the system displays a list of entities that have the Allow Adjustments from Children application attribute enabled. You can select the journal detail when the journal status is Working, Submitted, or Rejected. You cannot make changes to the journal detail when the journal status is Approved or Posted. Windows Procedure
Journals module. The values are Contribution Adjustments, Parent Adjustments, Entity Currency Adjustments, and Parent Currency Adjustments.
4 Double-click the selected journal, or select the journal and click Open. 5 Click in a cell grid. 6 Right-click and select Set Point of View.
Tip: You can also double-click a blank cell or an area of a cell not occupied by text to bring up
the Point of View dialog box. If the cell contains text, you must double-click within the cell to the right of any text to active the point of view.
7 To edit the information on the journal, take one or more of these actions:
l
If you did not select Create Single Entity Journal, you must select an entity from the point of view. To select an entity, select Entity, and select a member. To select an account, select Account, and select a member from the list of accounts. To select an intercompany partner, select ICP, and select a member from the list of intercompany partners. To select a custom dimension, select a custom dimension tab, and select a member from the list of custom members.
8 Click OK.
Web Procedure
2 Select a member for the scenario, year, period, and value. 3 Click OK.
3 Left-click and drag the column grid line to the new position.
3 Left-click and drag the column grid line to the new position.
Select Expand All Columns to expand all of the columns in the grid to their default width. Select Expand ICP Column to expand only the ICP column to the default width. Select Expand Custom 1 Column to expand only the Custom 1 column to the default width. Select Expand Custom 2 Column to expand only the Custom 2 column to the default width. Select Expand Custom 3 Column to expand only the Custom 3 column to the default width. Select Expand Custom 4 Column to expand only the Custom 4 column to the default width.
Submitting Journals
After you create a journal, you can submit it for approval before posting. You can submit a journal from the Edit Journal dialog box when you create it, or you can submit it later by selecting it from the journals list on the Process Journals workspace. You can submit journals one at a time or in batches. After you submit a journal, the status changes to Submitted. Windows Procedures
2 On the process bar, click Working or Advanced. 3 From Process Journals workspace, select a scenario, year, period, and value. 4 Double-click the selected journal, or select the journal and click Open. 5 Click Submit.
Tip: To submit multiple journals from the Edit Journal dialog box, use the arrows at the bottom
of the dialog box to scroll to the next journal in the list (for example, Journal 2 of 10).
6 Click OK.
Web Procedure
To submit journals:
1 On the Process Journals page, set the journal point of view. 2 From the list of journals, select the Working or Rejected journal to submit. 3 From Process, select Submit.
Tip: You can also select Submit from the Process drop-down list from within a journal.
Unsubmitting Journals
You can unsubmit a journal that you previously submitted. When you unsubmit a journal, the status reverts from Submitted to Working. Windows Procedures
Tip: To unsubmit multiple journals from the Edit Journal dialog box, use the arrows at the
bottom of the dialog box to scroll to the next journal in the list (for example, Journal 2 of 10).
6 Click OK.
Web Procedure
To unsubmit journals:
1 On the Process Journals page, set the journal point of view. 2 Select the submitted journal to unsubmit. 3 From Process, select Unsubmit.
Tip: You can also select Unsubmit from the Process drop-down list from within a journal.
Approving Journals
After you submit a journal, you can approve it for posting. You can approve a journal from the Edit Journal dialog box after you create and submit it, or you can approve it later by selecting it from the journals list in Process Journals. You can approve journals one at a time or in batches. After you approve a journal, the status changes to Approved and the journal cannot be edited. Windows Procedures
Tip: To approve multiple journals from the Edit Journal dialog box, use the arrows at the bottom
of the dialog box to scroll to the next journal in the list (for example, Journal 2 of 10).
6 Click OK.
Web Procedure
To approve journals:
1 On the Process Journals page, set the journal point of view. 2 Select the submitted journal to approve. 3 From Process, select Approve.
Tip: You can also select Approve from the Process drop-down list from within a journal.
Rejecting Journals
After a journal is submitted for approval, or approved, you can reject it. You can reject journals one at a time or in batches. After you reject a journal, the status changes to Rejected.
Tip: To reject multiple journals from the Edit Journal dialog box, use the arrows at the bottom
of the dialog box to scroll to the next journal in the list (for example, Journal 2 of 10).
6 Click OK.
Web Procedure
To reject journals:
1 On the Process Journals page, set the journal point of view. 2 Select the submitted journal to reject. 3 From Process, select Reject.
Tip: You can also select Reject from the Process drop-down list from within a journal.
of the dialog box to scroll to the next journal in the list (for example, Journal 2 of 10).
6 Click OK.
Web Procedure
Posting Journals
You can post a journal after it is approved. You can post a journal from the Edit Journal dialog box after you submit and approve it, or you can post it later by selecting it from the journals list on the Process Journals workspace. From Process Journals, you can also select the Advanced process bar button to post a journal directly from Working or Submitted status without submitting or approving it first. The scenario view to which a journal is posted depends on the setting for the Scenario attribute ZeroViewForAdj. If this attribute is set to Periodic, the journal is posted to the Periodic value. If this attribute is set to YTD, the journal is posted to the YTD value. You can post journals one at a time or in batches. You must have the journal period open before you can post. You must have All access to the security classes of every entity for the detail lines to post the journal. Your ability to post a journal also depends on the process level of the data in the journal. For example, if you have a process management security role of Reviewer 2 and the data that the journal affects is at Process Level 6, you cannot post the journal. See Process Levels on page 245. These four Value dimension members are valid for posting journals: Entity Currency Adjustments, Parent Currency Adjustments, Parent Adjustments, and Contribution Adjustments. You can post a journal to a specific parent and child combination (node) by using one of these Value dimensions:
l
Parent Adjs - Applied to the node before consolidation. Contribution Adjs - Applied to the contribution when determining the contribution total.
Note: Node adjustments are posted in the currency of the parent.
When you post a journal, the system recalculates the account balances so that the database reflects the adjustments. The journal status changes to Posted, and you can view the adjustment in a data grid.
Note: Do not delete or rename a posted journal, as this will result in hanging data for the
of the dialog box to scroll to the next journal in the list (for example, Journal 2 of 10).
6 Click OK.
Web Procedure
To post journals:
1 On the Process Journals page, set the journal point of view. 2 Select the journals to post.
You cannot post previously posted journals.
Unposting Journals
You can unpost a journal after it is posted. For example, suppose you post several journals with adjustments to an entity, and you receive new data for that entity. You can unpost the journals, load the new data, and post the journals again.
When you unpost a journal, the journal status changes to Rejected. When you unpost an autoreversal journal, the journal status changes back to Approved. Windows Procedures
of the dialog box to scroll to the next journal in the list (for example, Journal 2 of 10).
6 Click OK.
Web Procedure
To unpost journals:
1 On the Process Journals page, set the journal point of view. 2 Select the posted journal to unpost. 3 From Process, select Unpost.
Tip: You can also select Unpost from Process in a journal.
Reviewing Journals
You can review journals that have been created, edited, submitted, unsubmitted, approved, rejected, or posted. You can review journals before they are posted, or after they are posted and before you run a journal report.
Windows Procedure
To review journals:
1 From the Financial Management Desktop, click Process Journals. 2 On the process bar, click Advanced. 3 From Process Journals, select a scenario, year, period, and value. 4 Double-click the selected journal or select the journal and click Open.
Tip: To review multiple journals from the Edit Journal dialog box, use the arrows at the bottom
of the dialog box to scroll to the next journal in the list (for example, Journal 2 of 10).
To review journals:
1 From the Process Journals Web page, view the list of journals. 2 Click a journal to open and review it.
Journal Validation
When you submit, approve, or post a journal, the system validates the journal. The system checks for these conditions:
l
The period must be a base period for the scenarios base frequency. When you post or unpost a journal, the period must be opened The Value dimension must be an adjustment dimension. The journal must have the appropriate status for the action to be performed. Line items must exist for the journal. The entity and the parent must be valid dimensions. For regular journals, the entity must allow adjustments. If you are posting a journal to Parent Currency Adjs, you must enter a valid parent. Also, the entity must be a child of the specified parent for the journal entity. If you are posting a journal to a node, the parent must allow adjustments for child entities. The entity must be a child of the specified parent. Node journals must have valid parent-entity combinations. The system also checks for the Organization by Period application setting when you attempt to post node journals. The entity must be active for the parent for the period in which you are posting. The account must be valid. It must be an Asset, Liability, Revenue, Expense, Balance, Flow, or Balance Recurring account. The account must be a base account and cannot be calculated (that is, designated as calculated in metadata). It cannot be calculated through a roll-up; that is, the account cannot have children.
All other dimensions must be valid. The ICP dimension cannot be ICP Top, ICP Entities, or left blank, but you can select ICP None. If an ICP is specified, the account must be set up as an ICP account. The custom dimensions cannot be designated as calculated in metadata and cannot be calculated through a roll-up; that is, the custom dimensions cannot have children. For a balanced journal, the total debits must equal the total credits. For a balanced by entity regular journal, the total debits must equal the total credits for each entity. For a balancedby-entity node journal, the total debits must equal the total credits for each node. For a balanced-by-entity node journal, the parent and children entities must have the same currency. If the Value dimension is Entity Currency, the parent entities in the journal can have different currencies, but they must have the same currency as their children entities. All intersections must be valid. The subcube containing the line item cell cannot be locked. The cell cannot be designated as a NoInput cell using rules.
consolidation journals. You can only open and view them, run reports, and extract them. To run a journal report on automated consolidation journals, see Running Journal Reports on page 236. To print a report, see Printing Journal Reports on page 240.
Select the Scenario, Year, and Period for the consolidation data that you want to view. For the Value member, select [Proportion] or [Elimination], then click OK.
The system displays a list of journals generated during the consolidation process.
in the Point of View and to the journal security class. In addition, you must have the Read Journals or Journals Administrator security role.
6 To change the column order, drag the columns to rearrange their order. 7 Click OK.
3 From Displayed, select the columns to sort. 4 Drag the selected column to Sorted, or click
Tip: To select all columns, click
5 To change column attributes, select the column in Sorted, and take one or more of these actions:
l
To have the column repeated for each journal, click Display, Repeat. To display totals for the column, click Totals, hide totals.
6 Click OK.
Formatting System Reports on page 151. You can save the report locally or remotely, and you can print reports for groups of journals or for individual journals. See Saving Journal Reports on page 239, Printing Journal Reports on page 240, and Printing Reports for Individual Journals on page 240.
3 From Properties, enter a report Label and Description. 4 From the Point of View bar, select a scenario, year, period, and value for the report.
Note: To run a journal report for automated consolidation journals, you must select
To display the dimension member label, select Label. To display the dimension member description, select Description. To display both the dimension member label and description, select Both.
7 Optional: To repeat the information in every row, select Repeat. 8 Optional: To display the subtotal for the amounts, select Totals.
Tip: To restore the columns to their default settings, click Restore Defaults.
9 Click Close.
sensitive. For example, filtering with testgroup might return different results than filtering with TestGroup.
4 Save as a report definition, XML, or HTML file. 5 From Security Class, select a report security class. 6 To overwrite a file, select Overwrite an existing file. 7 Click OK, and click Close.
the columns or format. For instructions on selecting options for reports, see Printing Journal Reports on page 240.
Deleting Journals
You can delete unposted journals that you no longer need. You cannot delete Approved or Posted journals.
Note: Do not delete a posted journal, as this will result in hanging data for the adjustment
To delete journals:
1 Click Process Journals. 2 Select Working or Submitted on the process bar to view journals with those statuses. 3 From Process Journals , select a scenario, year, period, and value. 4 Select the journals to delete. 5 Press Delete. 6 Click Yes.
Web Procedure
To delete journals:
1 From the journals list, select the journal to delete, and click Delete. 2 Click OK.
Tip: You can also delete a journal if you have the journal open.
13
In This Chapter
About Process Management .................................................................................................... 243 Starting Process Management .................................................................................................. 246 Using Process Control ........................................................................................................... 247 Promoting Process Units ........................................................................................................ 261 Submitting Process Units........................................................................................................ 262 Approving Process Units......................................................................................................... 263 Rejecting Process Units ......................................................................................................... 264 Signing Off on a Process Unit .................................................................................................. 265 Publishing Process Units ....................................................................................................... 266 Locking and Unlocking Process Units .......................................................................................... 267 Viewing Process Review History................................................................................................. 267 E-mail Alerts for Process Control ............................................................................................... 268 Process Management Validation .............................................................................................. 268 Process Management and Consolidation...................................................................................... 269
you select January, but is not available when you select a quarter, such as Q1. In addition, if you select multiple cells and your selection includes a data cell in which Process Management is not supported, the Process Management option is not available. If Process Management is enabled for a scenario, the system performs validation checks for each process unit as the data moves from one level to the next. See Process Management Validation on page 268.
Your assigned security role. See Process Management Security Roles on page 244. The current process level of the process unit. See Process Levels on page 245. Your access rights to the process unit. Access rights can be None, Read, Promote, or All.
m
If your access rights are None, you have no access to the process unit. If you have Read access rights, you can only view data for the process unit. If you have Promote access rights, you can view data and also promote an entity even if you do not have All access. If you have All access rights, you have complete access to the process unit, including the ability to view and to modify the data. See the Oracle Hyperion Financial Management Administrators Guide.
Process Management Security Roles Description The Review Supervisor has the access rights to start a process unit that allows input to the entitys data, and has the access rights to approve and publish the data. To promote or reject a process
Security Role
Description unit, the Review Supervisor may also need the Reviewer 1-10 role, depending on the process level. See Process Levels on page 245.
Submitter
The Submitter has the access rights to move the process unit to the final stage of the review process so that it is ready for approval. Although the default action is to promote the process unit to the next level, a Submitter can skip many levels of review and go directly to the last process level (Submitted) before final approval. This user cannot promote a process unit to any level, because there is no next level available. To move the process unit to the Submitted level for final approval, the user must also have the security role of Submitter. This user is able to reject a process unit. This user can promote a process unit to the next level, or reject a process unit. See Process Levels on page 245.
Reviewer 10
Reviewer 1 through 9
Process Levels
The possible process levels are shown in Table 28 with a description of each level and the access rights that are required.
Table 28
Process Levels Description Process unit has not been started by the Review Supervisor and no data can be entered by any users except the Supervisor. Only the Supervisor who has All access rights to the entity can change the process unit level to First Pass. Process unit has been started and is in the initial stage for data to be entered by any user with the proper access rights. Any user with Read or Promote access to the entity can view the entitys data. Any user with All access to the entity can modify the entitys data. No security role is checked when the process unit is in the First Pass level. Process unit is at the beginning of the review process after initial data entry. To view data, a user needs access rights of Read, Promote, or All, and a security role of less than or equal to the process level of the data. To modify data or change the status, a user needs access rights of All and a security role equal to the process level of the data. Process unit has been submitted and is ready for final approval. To view data, a user needs access rights of Read, Promote, or All, and any security role. To modify data or change the status, a user needs access rights of All and the Review Supervisor security role. Submitted level is the common final process level before a process unit can be approved. If you have the Submitter security role, you have the option to skip levels of review and promote the process unit directly to the Submitted level.
First Pass
Submitted
Approved
Process unit has been approved. To view data, a user needs access rights of Read, Promote, or All, and any security role. To modify data or change the status, a user needs access rights of All and the Review Supervisor security role. Process unit has been published for public access. To view data, a user needs access rights of Read, Promote, or All, and any security role. To modify data or change the status, a user needs access rights of All and the Review Supervisor security role.
Published
Note: The ability to modify data also includes the ability to post journals.
You can start Process Management from a data grid or from the Process Control module. When you start a process unit from the Process Control module, you can select a data view and filter and sorting options. See Using Process Control on page 247.
5 Optional: To change the top member for the entity list, use one of these methods:
l
Enter a top member in the Top Member text box, and click Update to refresh the list. Click Browse, and select a top member. Click the Entity link at the top of the entity column, and select a top member.
6 Optional: Select the options for displaying, filtering, and sorting members.
See Setting Process Control Options on page 250.
7 Select the process unit to start. 8 Click Manage Process and select Start, or select Manage Process, then Start from Actions. 9 Optional: Enter a comment in Comments, or attach a document for more detail.
See Attaching Documents to a Process Unit on page 260.
10 Optional: If you are using the Tree view, select Selected Entity Only or Selected Entity and Descendants. 11 Click Start.
currency rate information. In addition, you can generate and receive e-mail alerts about process management status.
To access the Process Control module, in the File Browser expand Tasks, select Data Tasks, and
select Process Control.
Selecting the Data View on page 249 Selecting Entities for Process Control on page 249 Setting Process Control Options on page 250 Starting Process Management on page 246 Promoting Process Units on page 261 Submitting Process Units on page 262 Approving Process Units on page 263 Viewing Process Review History on page 267 Signing Off on a Process Unit on page 265 Publishing Process Units on page 266 Calculating Data from Process Control on page 260 Translating Data from Process Control on page 260 Consolidating Data from Process Control on page 261 Viewing the Process Control Summary on page 255 Viewing the Pass or Fail Status on page 256 Viewing Validation Detail on page 257 Viewing Calculation Status on page 258 Viewing Journal Status on page 258 Viewing Rate Data on page 259 Viewing Manage Ownership Information on page 259
Local View
When the Local Data View is selected, the Calculation Status (Calc Status) column is based on the Entity Currency Total member (Entity Curr Total) of the Value dimension. The Journal Status column (ECA Status) is based on the Entity Currency Adjustment member (Entity Curr Adjs) of the Value dimension.
Translation View
When the Translation Data View is selected, the Calculation Status (Calc Status) column is based on the Parent Currency Total member (Parent Curr Total) of the Value dimension. The Journal Status column (PCA Status) is based on the Parent Currency Adjustment member (Parent Curr Adjs) of the Value dimension.
Consolidation View
When the Consolidation Data View is selected, the Calculation Status (Calc Status) column is based on the Contribution Total member (Contribution Total) of the Value dimension. The Journal Status columns (PA and CA Status) are based on the Parent Adjustment (Parent Adjs) and Contribution Adjustment (Contribution Adjs) members of the Value dimension.
are not available for rows. When you use a list view, sorting and filtering are available. See Setting Process Control Options on page 250.
4 Select the options to display the list of entities. See Setting Process Control Options on page 250.
To select multiple rows, from the Process Control module, use these options:
l
To select contiguous rows, highlight a row and drag to select additional rows. To select noncontiguous rows, highlight a row, press and hold Ctrl, and select additional rows. To select all rows, click the top left cell corner of the grid.
Review Level, for example, Started, First Pass, Review Level 1, Approved. See Process Levels on page 245. Pass/Fail status, which displays whether the process unit is ready for promotion to the next level. See Viewing the Pass or Fail Status on page 256. Validation status, which displays the validation status for the entity based on the amount stored in the Validation account for the entity. See Viewing Validation Detail on page 257.
Calculation status, for example, OK, NODATA, CH. See Viewing Calculation Status on page 258. Journal status, which displays a red or green flag for the status of journals for the entity, such as Entity Currency Adjustments, Parent Currency Adjustments, Parent Adjustments, or Contribution Adjustments. See Viewing Journal Status on page 258.
Style
You can display the entity list as a flat list or Tree hierarchy format. You can only use a Tree view if you select the Hierarchy system list. All other lists are displayed in the flat list view. When the entities are displayed in a Tree view, you can expand and collapse the hierarchy using the plus (+) and minus (-) signs next to the entity. When changing the process level in a Tree view, you can choose to apply the action to the current selected entity only or to the selected entity and its descendants. Using the entity and descendants option allows you to perform an action without having to manually expand the entire organization. When the list is displayed in a Tree view, no sorting or filtering is available for rows.
Filters
When you use a list view, sorting and filtering are available. For example, you can filter rows based on the review level and display all rows above or below a specific review level, such as all levels above First Pass. You can sort rows by review levels in descending or ascending order. You can filter rows by validation status, such as Pass Only or Fail Only. You can also filter rows by calculation status, such as OK, CN, or TR. See Viewing Calculation Status on page 91. After you set sorting and filtering options, the settings are displayed in tool tips for the columns in the Process Control window.
Period View
You can view one period or all periods. When you select All, you must also select Process Review Level or Calculation Status to display in the columns. The selected information is displayed across the columns for all the periods in the scenario.
Entity View
You can view entity information using the entity label, description, or both. The default setting is to display the label.
Page Size
Depending on the entity list selection, it is possible to display many entities in the Process Control window. To minimize the performance issue with a large number of entities, you can select the number of entities to display on the page. You can also use the Up and Down arrows in the toolbar to navigate to the next or previous pages.
).
To display the entities in a list view, select List. To display the entities in Tree hierarchy format, select Tree.
Note: When you select the Tree view option, it sets your system list to Hierarchy and displays
5 Optional: If you use a list view, you can select filter and sorting options as follows:
l
To filter the list by review levels, from Review Levels, select a review level, and select an option:
m
and Above and Below Only If you do not change the default value of All, all review levels are displayed.
None Descending Ascending Pass Only Fail Only Pass and Fail
To filter the list by Pass or Fail status, from the Show drop-down list, select an option:
m
If you select All, from Display select an option to display in the columns:
m
Process Level Calc Status The selected information is displayed across the columns for all the periods within the scenario.
To view the entity information using the label, select Label. To view the entity information using the description, select Description. To view the entity information using both the label and description, select Both.
8 Optional: To show only active entities for the parent entity, select Show Active Only.
Note: This option is available only if the application is set up for Organization by Period.
9 Select one or more Review Options: Review Level, Pass/Fail, Validation. 10 Optional: Select one or both of these statuses: Calc Status, Journal Status. 11 Optional: To set the rows per page, enter a Rows Per Page value or use the default value. 12 When you finish selecting options, click OK to save the settings.
To display the entities in a list view, select List. To display the entities in Tree hierarchy format, select Tree.
Note: When you select the Tree view option, it sets your system list to Hierarchy and display
To view the entity information using the description, select Description. To view the entity information using both the label and description, select Both.
4 Optional: To show only active entities for the parent entity, select Show Active Only.
Note: This option is available only if the application is set up for Organization by Period.
5 Optional: If you use a list view, you can select filter and sorting options as follows:
l
To filter by phases, select a phase. To filter by review levels, from Review Levels, select a review level, and select an option:
m
and Above and Below Only If you do not change the default value of All, all review levels are displayed.
To filter the list by Pass or Fail status, from the Show drop-down list, select an option:
m
To filter the list by status, select an option: All, Calc Status, or Journal Status.
6 Optional: To set the rows per page, enter a Rows Per Page value or use the default value.
Validation are included for each phase. Since Calculation Status and Journals apply to the entire processing unit, they are displayed only once regardless of how many phases are selected. If you select All period view, you can select Calculation Status or Review Level information for the columns. If you select Review Level information, you should select one submission phase for display. When you select All periods, or Tree for the display, the filter option is unavailable.
Process Control Toolbar Buttons Toolbar Button Description Specify options for displaying, filtering, and sorting. Refresh the grid after performing process control actions. Start, promote, submit, approve, reject, sign off, and publish a process unit. Consolidate, consolidate all, consolidate all with data, calculate contribution, or force calculate contribution of data. Calculate or force calculation of data. Translate or force translation of data. View review level summary or calculation status summary. Link to a predefined data grid with Rate data. Note: The predefined data grid must have the name Rates as the grid label.
Consolidate
Manage Ownership
a summary by calculation status for all entities included in the Process Control window, not just the ones displayed on the current page.
2 Click Summary and select Review Level Summary or Calculation Status Summary.
Tip: You can also access the Summary option from the Actions menu or by right-clicking on a
Data View and Value Dimension for Process Control Value Dimension Entity Curr Total Parent Curr Total Contribution Total
If the calculation status is OK or NODATA and if the Validation account amount is zero or NODATA, the Pass/Fail column displays a check mark indicating that the unit is ready for promotion. If the process unit fails, the Pass/Fail column displays an X. When the system checks for Pass/Fail status, it checks for derived data in the current period. A period can contain derived data if the validation account is a Flow account and if the ZeroViewforNonAdj metadata attribute is set to Periodic for the scenario. A unit with a calculation status of NODATA passes only if there is no data in prior periods. If a unit has a calculation status of NODATA but data exists in the prior period, the process unit displays a Fail status. For example, if you have no data in January, the calculation status for January is NODATA with a status of Pass. If you have data in January but no data in February, the status is Fail because February has derived data from January. In this case, you must perform calculation in the current
256 Using Process Management
period to ensure that the data is valid for promotion. After calculation, the calculation status is updated to OK, and the status of the column changes to Pass. See Viewing Validation Detail on page 257.
To view the Pass/Fail status, from Process Control, select the entities for which to show status.
The Pass/Fail status is displayed in the Pass/Fail column.
Depending on the Data View option that you selected for the process unit, the system displays different data values. For example, if the Data View is Local Data, the system displays Entity Curr Total, Entity Curr Adjs and Entity Currency. If the Data View is Translate Data, the system displays Parent Curr Total, Parent Curr Adjs and Parent Currency. If the Data View is Consolidation Data, the system displays the Parent Adjs , Proportion, Elimination, Contribution Adjs and Contribution Total. The Raw Data option displays the data in units. The Formatted Data option displays data in the scaled value based on the scale of the currency assigned to the entity. For example, suppose the Entity dimension member, WestSales, displays an X in the Validation column. To view more information, you can click the X in the column. The following figure shows the Validation account detail for the WestSales account.
Figure 5 Sample Validation Detail
In the example, there are two validation accounts: Surplus and ICMatch. The Surplus account contains a balance, causing West Sales to fail validation. WestSales is not ready for promotion
because the Validation account does not equal zero. It cannot be promoted until the Surplus account has been balanced.
To display the data in units, select Raw Data. To display the data in the scaled value based on the scale of the currency assigned to the entity, select Formatted Data.
To view calculation status, from the Process Control window, select the entity top member for
which to show calculation status. The calculation status is displayed in the Calc Status column.
that you can view the unposted journals for the process unit that you selected. You can then post the journals.
Note: Only the list of unposted journals to which you have security access is displayed.
2 Optional: If the column displays a red flag indicating unposted journals for a process unit, click the flag to
open the Journals module and view the unposted journals.
Tip: To return to Process Control, select it from the view pane.
The system opens the Rates data grid that you previously defined. If you do not have a Rates data grid, an error message is displayed.
The document is associated with the scenario, year, period, and entity combination and the process level.
security roles. Any user who has All access to the entity can modify the data. The process unit must have a calculation status of OK, OK SC, or NODATA, and a zero balance in the validation account before you can promote it. When you attempt to promote the parent entity data to the next process level, validation checks are performed to verify that the children entities are at the level to which you are trying to promote the parent. A parent can only be promoted to a level that is less than or equal to the lowest level of its immediate children. If your application uses phase submissions, when you select a cell , the system determines the submission phase that applies to the cell. There can only be one review status for each submission phase, so when you promote the cell, you promote all the cells for that submission phase. When you promote multiple cells in the data grid, the system determines all submission phases that apply to those cells and promotes the phases at the same time, depending on the review level dependency rules.
After you promote a process unit, its process level changes to the next process level. You can promote a process unit up through Review Level 10, which is the last process level. When a process unit has a status of Review Level 10, you can submit it for approval. See Submitting Process Units on page 262.
Note: If you receive javascript errors during the promotion process, you might need to increase
the timeout setting for the Oracle's Hyperion Reporting and Analysis proxy server. See the Oracle Hyperion Enterprise Performance Management System Installation and Configuration Guide.
4 Select the process unit to promote. 5 Click Manage Process and select Promote. 6 From Review Level, select a review level to which to promote the process unit. 7 Optional: Enter a comment in Comments, or attach a document for more detail. 8 Optional: If you use the Tree view, select Selected Entity Only or Selected Entity and Descendants. 9 Click Promote.
However, the submitter can skip levels of review and go directly to the process level before final approval. The submitter must also have the reviewer role for the current level to promote a process unit. For example, a submitter who has Review Level 5 and Submitter security roles can promote a process unit to Review Level 6 or submit the process unit. The process unit must have a status of OK, OK SC, or NO DATA before you can submit it. After you submit a process unit, its process level changes to Submitted. When a process unit has a Submitted status, you must be assigned the Review Supervisor security role to change the data, promote it to Approved status or reject it.
4 Select the process unit to submit. 5 Click Manage Process and select Submit. 6 Optional: Enter a comment in Comments, or attach a document for more detail.
See Attaching Documents to a Process Unit on page 260.
7 Optional: If you use the Tree view, select Selected Entity Only or Selected Entity and Descendants. 8 Click Submit.
4 Select the process unit to approve. 5 Click Manage Process and select Approve. 6 Optional: Enter a comment in Comments, or attach a document for more detail.
See Attaching Documents to a Process Unit on page 260.
7 Optional: If you use the Tree view, select Selected Entity Only or Selected Entity and Descendants. 8 Click OK.
4 Select the process unit to reject. 5 Click Manage Process and select Reject. 6 Optional: Enter a comment in Comments, or attach a document for more detail. 7 Click Reject.
4 Select the process unit on which to sign off. 5 Click Manage Process and select Sign Off. 6 Optional: Enter a comment in Comments, or attach a document for more detail.
See Attaching Documents to a Process Unit on page 260.
7 Optional: If you use the Tree view, select Selected Entity Only or Selected Entity and Descendants. 8 Click OK.
4 Optional: Enter a comment in Comments, or attach a document for more detail. 5 Click Sign Off.
security roles. Any user who has Read or All access to the entity can view the entitys data, but it is available only for viewing.
7 Optional: If you use the Tree view, select Selected Entity Only or Selected Entity and Descendants. 8 Click Publish.
To lock data:
1 From a data grid, select the cells for which to lock data. 2 Right-click and select Lock.
To unlock data:
1 From a data grid, select the cells for which to unlock data. 2 Right-click and select Unlock.
4 Select the process unit for which to view history. 5 Right-click and select Process Flow History.
The process history is displayed in a separate window.
6 When you finish viewing the process history, click Close Window.
not have one of these statuses, you must recalculate, translate, or consolidate the data before you can perform any process management action. The system also checks the process unit to see if the data is locked. You cannot perform any process management actions until the data is unlocked. You can only lock data when it is published. See Locking Data on page 97. The process level of the parent entity must always be lower than or equal to all of its immediate children. The process level of the child entity must always be greater than or equal to all of its immediate parents.
It checks the process level of direct descendants to ensure that you are not promoting an entity to a level that is higher than the lowest level of all of the entitys dependents. If you are using a different currency for the entity, the system checks the process level for the entitys input currency to ensure that a current translation is being used. If you are using a node component, the system checks the currency process unit that applies to the parents input currency to ensure that the node values are correct.
The system also performs validation checks for child entities with 0% consolidation (unowned entities). Before you can promote the parent entity, you must promote the unowned entities to a specific level; for example, the lowest level of all of the child entities.
It checks the process level of the immediate parents to ensure that you are not rejecting an entity to a level that is lower than all of the entitys parents. If the Value dimension equals the input currency for an entity, the system checks the input currency for all of the parents. If the parents input currency is the same as the entitys input currency, the system checks the node process unit. If the parents input currency is different, the system checks the process level of the parents currency at the entity level. If the Value dimension uses a currency other than the input currency for an entity, the system checks the level of the node process unit. If the Value dimension indicates that you are using a node process unit, the system checks the process level for the parents input currency process unit.
initial process level is Not Started. After consolidation, the parent data status changes to OK, but the process level is still Not Started. The Review Supervisor can then start the process unit. If any of the children contain NODATA, the consolidation process can still occur. When you attempt to promote the parent data to the next process level, the system performs validation checks. The initial process level is Not Started. After you consolidate, the parent process level is still Not Started. You can manually change the process level of the NODATA process unit. After the NODATA process unit has been changed, the parent can then be promoted to a level that is less than or equal to the lowest of all of its immediate children.
14
In This Chapter
About E-mail Alerts .............................................................................................................. 271 Generating Alerts for Intercompany Transactions ............................................................................. 272 Generating Alerts for Process Control .......................................................................................... 276
The security class assigned to the scenario and entity for the alert must support e-mail alerts. See the Oracle Hyperion Enterprise Performance Management System Security Guide. Users must be assigned a security role to receive e-mail alerts. See the Oracle Hyperion Enterprise Performance Management System Security Guide. The SMTP mail server must be configured. See the Oracle Hyperion Enterprise Performance Management System Installation Start Here.
Generating Alerts for Intercompany Transactions on page 272 Generating Alerts for Process Control on page 276
Intercompany Transactions Process window Intercompany Transactions Monitor window Intercompany Transaction Report by ID Intercompany Transaction Report by Account Intercompany Matching Partner Reports
If you generate e-mail for a unique entity, the system sends alerts to the users who have access to the entity for the selected transactions. If multiple transactions are selected for the same entity, the system generates only one alert for each entity. Only the users who meet certain security criteria receive the alert. See Receiving Intercompany Transaction E-mail Alerts on page 276. If you generate e-mail for a unique partner, the system sends alerts to the users who have appropriate access to the partner entity. If you generate e-mail for both the entity and partner, the system sends alerts to the users who have appropriate access to the entity or partner entity.
You can include comments in the e-mail content in addition to the transaction information included by the system. When you generate an e-mail alert, you receive a confirmation log that includes the information for the alerts sent to various users.
Figure 6
Generate email for unique entity Generate email for unique partner Generate email for both entity and partner
5 Click Send.
2 From the toolbar, click Alert. 3 Optional: In Comment for all alerts, enter a comment.
The comment is used for all the alerts that are generated.
4 Click Send.
2 From the report, select Alert next to the transaction for which to send an alert. 3 Optional: In Comment for all alerts, enter a comment.
The comment is used for all the alerts that are generated.
4 Click Send.
Because the e-mail is generated for the report, the system automatically sends alerts to the users responsible for the entity or partner entity, therefore only the option to generate e-mail for both the entity and partner is available. The system generates an alert to the user responsible for the entity, and to the user responsible for the partner entity. You can include comments in the e-mail content in addition to the transaction information included by the system. When you generate an e-mail alert, you receive a confirmation log that includes the information for the alerts sent to various users.
2 From the report, select Alert next to the group for which to send an alert. 3 Optional: In Comment for all alerts, enter a comment.
The comment is used for all the alerts that are generated.
4 Click Send.
Intercompany Transaction Admin or Intercompany Transaction User security role for intercompany transactions. You do not need these roles to receive email for Intercompany Matching Reports. Receive E-mail Alerts for IC Transactions security role Security access rights of All, Read, or Promote to the data cell for the transaction Security class attribute of SupportAlert=Y for both the scenario and entity
When you receive an e-mail alert for intercompany transactions, it displays the module from which the alert was generated; for example, Intercompany Transactions. It also displays the point of view used in the transaction for which the alert was generated. The comment that was used when generating the alert is displayed for all users. However, the specific information in the alert varies depending on your security role and the security class assigned to the transaction. For security reasons, no data is displayed in e-mail alerts. The e-mail serves to alert you of a change in status, or that you must perform an action about the item in the alert.
When the e-mail alert is generated, the user who performed the action receives a confirmation e-mail. The confirmation e-mail contains the action performed, the process units affected by the action, and the names of the users receiving the e-mail alerts for each process unit.
2 Optional: To add a comment, from Process Control, select a process unit and enter a comment in
Comments.
As a result of the review action, an alert is generated to the appropriate users. The comment is used for all the alerts that are generated.
The e-mail content contains the following information regarding the action performed and the process unit:
Action: review action performed Comment: additional comments to be included in the e-mail Process unit information: list of entities in the review action Entity label - Entity description, Period, Year, Scenario, Review Level prior to action, Review Level after the action
The process for sending process control alerts is different from that of intercompany transactions, where you can enter comments when you send the alert. Since the system generates process control alerts, it enables you to include additional comments in the content, and then includes the comments when generating the alerts. The additional comments are included in all the alerts generated from one review action. Therefore, all users in a specific distribution list receive the same comment information.
Receive E-mail Alerts for Process Management security role Security access rights of All or Promote to the security classes for the scenario and entity in the process unit. Alertable rights to the security classes for the scenario and entity in the process unit. The security class attribute for SupportAlerts=Y for both the scenario and entity. A security role that requires an alert based on the original process unit status or the new process unit status
When you receive an e-mail alert for process management, it displays the module from which the alert was generated; for example, Process Control. It also displays the point of view used in the process unit for which the alert was generated. The comment that was used when generating the alert is displayed for all users. For security reasons, no data is displayed in e-mail alerts. The e-mail serves to alert you of a change in status, or that you must perform an action about the item in the alert.
15
In This Chapter
Automating Tasks
Overview .......................................................................................................................... 279 Financial Management Tasks Available for Automation...................................................................... 280 Prerequisites for Task Automation.............................................................................................. 280 Managing Taskflows ............................................................................................................. 280 Creating Taskflows .............................................................................................................. 281 Viewing Taskflows ................................................................................................................ 290 Editing Taskflows ................................................................................................................ 290 Copying Taskflows ............................................................................................................... 291 Deleting Taskflows .............................................................................................................. 291 Running Taskflows Manually for Testing ....................................................................................... 291 Managing Access Permissions to Taskflows ................................................................................... 292 Assigning Access Permissions to Taskflows ................................................................................... 293 Viewing Taskflow Status ......................................................................................................... 294
Overview
Task Automation is a Web-based module that provides a method for linking a series of tasks into a taskflow. You can use task automation to automate tasks that you commonly perform using Financial Management. When you work with Financial Management, you routinely perform tasks such as loading data, running calculations and translations, consolidating parent entities, and extracting data through data extract or extended analytics. You can create and maintain taskflows to schedule critical tasks to be run as required. To create taskflows, you must be assigned the Task Automation security role. From the Administration menu, you can manage taskflows and view taskflow status. See these procedures:
l
Overview 279
Allocate Calculate Calculate Contribution Translate Consolidate Load Journals Extract Journals Load Data Extract Data Execute Journal Action Extended Analytics Process Management
You must install Oracle's Hyperion Shared Services. See the Oracle Hyperion Enterprise Performance Management System Installation and Configuration Guide. You must configure Financial Management to use external authentication. See the Oracle Hyperion Enterprise Performance Management System Installation and Configuration Guide. You must register the application with Shared Services. Registering the application facilitates communication and enables Shared Services links to be displayed on the Home page. See the Oracle Hyperion Enterprise Performance Management System Installation and Configuration Guide. You must be assigned the Task Automation security role in Financial Management.
Managing Taskflows
A taskflow is a sequence of tasks that you can create in task automation. For example, you can create a taskflow to load, calculate, and consolidate data. From the Manage Taskflows option, you can create, edit, save, copy, and delete a taskflow, view a list of available taskflows, assign access to a taskflow, and run a taskflow manually for testing. See these procedures:
l
Viewing Taskflows on page 290 Copying Taskflows on page 291 Deleting Taskflows on page 291 Running Taskflows Manually for Testing on page 291 Assigning Access Permissions to Taskflows on page 293
Creating Taskflows
You create a taskflow to link a series of tasks and specify the time to run them. When you create a taskflow, you assign it a name and description. Then you add task stages and links between tasks. Stages define specific tasks, such as data loads. Links specify how the system should proceed after completion of the step.
To create taskflows:
1 Select Administration, then Manage Taskflows. 2 From the Taskflow Listing Summary page, click New. 3 For Name, enter a taskflow name.
The name can contain up to 40 characters. The Application text box displays the name of the current application.
Adding Stages
A stage describes a step in a taskflow. Each stage has an action. These actions have parameters for which values are supplied at runtime, such as load data. You define a stage using these three tabs:
l
General: Defines the stage name, description and user ID of the user responsible for completing the stage. The user can be an initiator, which is the owner of the first stage in the taskflow, or another user for the other stages. Processing: Defines the action to be performed when the stage is run and any required parameters. Starting Event: Defines the event that initiates the taskflow, and the scheduled times for the event to occur. The scheduled time is based on the time of the application server, not on the time of the local user's computer. You can schedule the taskflow to run according to a schedule such as weekly, monthly, at the first of the month, or so on. This tab is displayed only for the first stage in the taskflow. It displays the scheduled event (taskflow start time), or is disabled (for the manual start of a taskflow executed by the Run Now option).
To add stages:
1 From the taskflow editor, click Add Stage.
A new stage is displayed in the left panel, and stage details are displayed in the right panel. If stages exist in the taskflow, the new stage is created at the end of the taskflow.
Figure 7 Task Automation General Tab
b. c.
Optional: For Description, enter a taskflow description; for example, Load a monthly data file. From Run As, select UserName, and enter a username and password for the user who launches the taskflow.
Note: Stage 1 requires that you enter a username and password. When you create future
stages, you can select to run as the Initiator, which tells the system to use the user ID and password that was defined in Stage 1.
c.
From Type for each parameter, select Picklist, Text Box, or URL, depending on the action, and enter values for the parameter. For example, for the LoadData action, the Mode option contains a picklist from which you can select Merge, Accumulate, or Replace. To edit the Point of View, click Edit, then select members for the Point of View. For the data file and log file names and paths, you must manually enter the information in a text box. The taskflow is executed from the server, so you must make sure that the file names and paths are valid and can be accessed from the server running the task. Therefore, you should not enter a path such as c:\file.dat that references your own hard drive. You must identify the computer name and share directory for the file using Universal Naming Convention (UNC); for example, \\HFMServer\share\path\file.dat.
Figure 8 Sample Parameters for LoadData
Figure 9
b. c.
For Start Date, enter the date for the task to be run, or click the pop-up calendar and select a date. From Start Time, select a time for the task to be run.
Note: This time is based on the application server, which is identified on the Server Date
line. d. e. For a recurring task, select Recurrence, and from Recurrence Pattern, select the task frequency. Select an option for the task end date and time:
l
No End Date End After occurrences, and enter the number of occurrences End Date, enter an end date and select an End Time.
5 Optional: To add a stage, click Add Stage and complete the stage information for General and Processing
Note: The Starting Event tab is available only for the first stage.
Table 31
Stage Actions and Parameters for Financial Management Parameter Name POV Type URL Possible Values Point of View Purpose Indicates the point of view for which the allocation is run. See Running Allocations on page 97. Indicates the point of view for the data to be calculated. See Calculating Data on page 110. Indicates whether to force calculation to run for selected cells, regardless of status. Indicates the point of view for the contribution data to be calculated. See Calculating Data on page 110. Indicates whether to force contribution to be calculated for all input periods. Indicates the point of view for the data to be translated. See Translating Data on page 111. Indicates whether to force translation to run for selected cells, regardless of status. Indicates the point of view for the data to be consolidated. See Consolidating Data on page 113. Indicates the type of consolidation to be performed. Indicates the journal file to load. See the Oracle Hyperion Financial
Action Allocate
Calculate
POV
URL
Point of View
Calculate
Force
Picklist
l l
True False
Calculate Contribution
POV
URL
Point of View
Calculate Contribution
Force
Picklist
l l
True False
Translate
POV
URL
Point of View
Translate
Force
Picklist
l l
True False
Consolidate
POV
URL
Point of View
Consolidate
Type
Picklist
l l l
Load Journals
Journals File
Textbox
Action
Parameter Name
Type
Possible Values
Textbox Textbox
Path for log file Delimiter in the journal file. Default is a semicolon (;). Name and path of file
Displays the journal load status. Separates the data in the file. Indicates the journal file to extract. See the Oracle Hyperion Financial Management Administrators Guide. Displays the journal extract status. Separates the data in the file. Indicates whether to extract journal templates. Indicates whether to extract recurring templates. Indicates whether to extract journals. Indicates the point of view for which journals are extracted. Indicates the data file to load. See Loading Data on page 56. Displays the data load status. Separates the data in the file. Indicates the mode to use for loading data.
Extract Journals
Journals File
Textbox
Textbox Textbox
Path for log file Delimiter in the journal file. Default is a semicolon (;).
l l
Extract Journals
Extract Templates
Picklist
Extract Journals
Picklist
l l
Extract Journals
Picklist
l l
Extract Journals
POV
URL
Point of View
Load Data
Data File
Textbox
Textbox Textbox
Path for log file Delimiter in the data file. Default is a semicolon (;).
l l
Load Data
Mode
Picklist
Action
Parameter Name
Type
Possible Values
l l
Purpose
Replace Accumulate True False True False Indicates whether to accumulate data in the data file. Indicates whether the file contains ownership data. Indicates the data file to extract. See Extracting Data on page 61. Displays the data extract status. Separates the data in the file. Indicates the view to use for extracting data. Indicates the point of view for which data is extracted. Indicates whether the data is calculated. Indicates the type of action to perform for the journal. See Processing Journals on page 210.
Load Data
Picklist
l l
Load Data
Picklist
l l
Extract Data
Textbox
Textbox Textbox
Path for log file Delimiter in the data file. Default is a semicolon (;).
l l l
Extract Data
View
Picklist
Extract Data
POV
URL
Point of View
Extract Data
Calculated
Picklist
l l
Journal Action
Picklist
l l l l l l l
POV
URL
Point of View
Indicates the point of view for which journal actions are performed. Identifies the journal on which to perform the action.
Journal Label
Textbox
Type Textbox
Purpose Indicates the data source name. See the Oracle Hyperion Financial Management Administrators Guide. Contains keys to the dimension tables. Indicates whether to create or update a star schema. Indicates the mode to use for extracting data.
Textbox Picklist
Create Update Standard Metadata All Selected Metadata only SQL Aggregation Essbase Data Warehouse Extract to Flat File True False
Extended Analytics
Extract Type
Picklist
l l l
l l l l
Extended Analytics
Picklist
l l
Indicates whether to exclude dynamic accounts from the extract. Indicates the point of view to use for Extended Analytics. Indicates the point of view to use for process management. See About Process Management on page 243. Text of comment for process unit Indicates the type of action to perform on the process unit.
Extended Analytics
POV
URL
Point of View
Process Management
POV
URL
Comment Action
Textbox Picklist
Comment text Start Promote Reject Sign Off Submit Approve Publish
l l l l l l l
Type Picklist
Possible Values
l l
Stage Actions and Parameters for Shared Services Parameters Action that enables e-mail messages to be sent automatically to an e-mail address. Complete these parameters for the e-mail action:
l l l
Action Email
To: Type an e-mail address for the recipient Subject: Type a subject for the e-mail Message: Select a variable (by double-clicking a variable from the variables list) to display success or failure Variables: Lists the available variables for the e-mail action
Execute
Action that runs external programs from a command line. Complete these parameters for the execute action:
l
Command: Type a command to run an external program. The external program can be a valid command line script (such as a bat script on Windows or a sh script on UNIX) and any valid program execution command. Make sure that your bat file does not resolve the path dynamically; if the files uses any variables to resolve the path, it will not work. The command must include the full path to the executable. For example, to launch Internet Explorer, type: C:\Program Files\Internet Explorer\IEXPLORE.EXE.
Adding Links
A link is the point during the taskflow execution at which the activity in one stage is completed and the taskflow ends or control passes to another stage, which starts. A link can be unconditional, where the completion of one stage always leads to the start of another, or conditional, where the sequence of operation depends on one or more link conditions. A link specifies the action for the system to take next. Every stage needs a link. In general, most stages have two links: success and failure. For the success link, you can specify that if the first stage succeeds, the system should proceed to the second stage (Receiving stage). For the failure link, you specify the action to be performed if problems occur in the first stage. For example, you can set a success link so that if the first stage of LoadData succeeds, the system should proceed to the Receiving stage of Consolidation. You can set a failure link so that if failure occurs or any problems are encountered in the LoadData stage, the system should proceed to the Receiving stage of End, which ends the process and terminates the taskflow.
The last stage in the taskflow must have a final link with End as the target to complete the taskflow. You can specify variables for an event. For example, you can add a variable for a load data task such as LoadData_Result= =Success. You must enter two equal signs (== =) after the variable, and place single quotation marks () around the condition. The value can be True or False.
To add links:
1 Click Add Link. 2 Select General and for Name, enter a link name.
The name can contain up to 30 characters.
4 From Receiving Stage select a stage. 5 Select Condition tab if applicable, and from Variable, select a variable, for example, LoadData_Result.
Tip: To delete a condition, click Delete.
Viewing Taskflows
You store and manage taskflows in Shared Services. The Taskflow Listing Summary shows the available taskflows by application, the user who created the taskflow, and a description.
Editing Taskflows
After you create a taskflow, you can edit the taskflow description, and create, edit, or delete taskflow variables. You can also add or delete a stage or a link.
To edit taskflows:
1 Select Administration, then Manage Taskflows. 2 Select the taskflow to edit and click Edit. 3 In the taskflow editor, select an option:
To add a stage, click Add Stage. See Adding Stages on page 281. To add a link, click Add Link. See Adding Links on page 289. To delete a stage or link, click Delete.
Note: If you delete a stage, all links associated with it are also deleted.
To edit the taskflow description, click Properties. To save the edits, click Save. To cancel the edits, click Cancel. The system returns you to the Taskflow Listing Summary without saving your changes.
Copying Taskflows
After you define a taskflow for an application, you can copy it to a different application.
To copy taskflows:
1 Select Administration, then Manage Taskflows. 2 Select the taskflow to copy and click Save As. 3 Enter a new name and description for the taskflow. 4 Click Submit.
Shared Services adds a copy of the taskflow with a new name to the Taskflow Listing Summary.
Deleting Taskflows
You can delete a taskflow that you no longer need.
To delete taskflows:
1 Select Administration, then Manage Taskflows. 2 From the list of taskflows, select the taskflow to delete, and click Delete.
2 From the Taskflow Listing Summary, select the taskflow to run and click Run Now.
Task Flow Permissions Description View a taskflow. Edit a taskflow. Write permission does not automatically include Read permission. You must assign Read permission explicitly, in addition to Write permission, if you want a user to have both.
Manage
Create new users and change permissions for users. Manage permission does not automatically include Read and Write permissions. You must assign Read and Write permissions explicitly, in addition to Manage permission, if you want a user to have all these permissions.
You can apply permissions to groups and to individual users. Users are automatically granted the permissions of the groups to which they belong. You can, however, explicitly add or deny permissions to a user to override group permissions. For each type of access permission (Read, Write, and Manage), you must apply one of these actions:
l
Grant: Explicitly grant the permission to the user or group. Granting permissions to a member of a group overrides permissions inherited from the group. For example, if a group is denied a permission, you can explicitly grant the permission to a member of the group.
Deny: Explicitly deny the permission to the user or group. Denying permissions to a member of a group overrides permissions inherited from the group. For example, if a group is granted a permission, you can explicitly deny the permission to a member of the group.
4 For Available Users/Groups, select users or groups to assign to this taskflow (press Ctrl to select multiple
users).
5 Click Add to move the selected users and groups to Selected Users/Groups or click Add All to move all users
and groups to Selected Users/Groups.
Note: Group names are preceded by an asterisk (*).
6 For the Read, Write, and Manage permissions, select an access type: Grant, Deny, or None. 7 Click Add to assign the permissions.
4 Select one of the Grant, Deny, or None options for the Read, Write, and Manage permissions. 5 Click one of these options:
l
To view changes to taskflow access, you must log out of the product application, close the browser, and re-log on to the product application.
Figure 10
Element Status
Application participating in the taskflow Taskflow name Enter or select by clicking the date or range of dates in which the taskflow was initiated Click to display in the Taskflow Listing area a list of taskflows that meet the search criteria that you specify Displays taskflows that meet the search criteria that you specify, such as:
l l l l l l l
ID Application* Taskflow* Initiator* Started* (lists the latest taskflow first) Status* Description
*Indicates data that is sortable. You may sort taskflows by Application, Taskflow, Initiator, Started, or by Status by clicking on the column header. Stop Delete Stop an active taskflow instance. Delete the selected taskflow instance. Note: The taskflow must be stopped before you can delete it.
Description Delete all of the selected taskflow instances. Display in the Taskflow Listing area the first page of taskflow instances that meet the specified search criteria. Display in the Taskflow Listing area the previous page of taskflow instances that meet the specified search criteria.
Page
Select a page to display in the Taskflow Listing area. Display in the Taskflow Listing area the page you selected in the Page drop-down list. Display in the Taskflow Listing area the next page of taskflow instances that meet the specified search criteria. Display in the Taskflow Listing area the last page of taskflow instances that meet the specified search criteria.
Refresh
From the Taskflow Status Summary, you can also stop an active taskflow. See Stopping Active Taskflows on page 296.
3 In the Taskflow Listing area, find the taskflow for which to view the participant summary and click the taskflow
ID.
Taskflow Participant Summary Window Elements Description Summary information for the selected taskflow (items appear in the order of completion):
l l l l l l l
Stage participant name. Participants are selectable. Click a participant to view details about a taskflow participant. Stage name Stage status:
l l l l
3 In Taskflow Listing, find the taskflow for which to view the participant summary and click the taskflow ID. 4 Click a participant to view taskflow participant details.
Oracle's Hyperion Shared Services displays the Taskflow Participant Details window and sorts the participant events chronologically.
Glossary
! See bang character (!). #MISSING See missing data (#MISSING). access permissions A set of operations that a user can
permission.
adjustment See journal entry (JE). Advanced Relational Access The integration of a relational
perform on a resource.
accessor Input and output data specifications for data
mining algorithms.
account blocking The process by which accounts accept input
database with an Essbase multidimensional database so that all data remains in the relational database and is mapped to summary-level data residing in the Essbase database.
agent An Essbase server process that starts and stops
data in the consolidated file. Blocked accounts do not receive their value through the additive consolidation process.
account eliminations Accounts which have their values set to
applications and databases, manages connections from users, and handles user-access security. The agent is referred to as ESSBASE.EXE.
aggregate cell A cell comprising several cells. For example, a
sign behavior. Account type options can include expense, income, asset, liability, and equity.
accountability map A visual, hierarchical representation of
data cell that uses Children(Year) expands to four cells containing Quarter 1, Quarter 2, Quarter 3, and Quarter 4 data.
aggregate function A type of function, such as sum or
the responsibility, reporting, and dependency structure of the accountability teams (also known as critical business areas) in an organization.
accounts dimension A dimension type that makes accounting
than Hold.
activity-level authorization Defines user access to applications
and the types of activities they can perform on applications, independent of the data that will be operated on.
ad hoc report An online analytical query created on-the-fly
designed to support large-scale, sparsely distributed data which is categorized into many, potentially large dimensions. Upper level members and formulas are dynamically calculated, and selected data values are aggregated and stored, typically with improvements in overall aggregation time.
aggregate view A collection of aggregate cells based on the
by an end user.
adapter Software that enables a program to integrate with
levels of the members within each dimension. To reduce calculation time, values are pre-aggregated and stored as aggregate views. Retrievals start from aggregate view totals and add up from there.
Glossary 299
the allocation model that controls the direction of allocated costs or revenue flow within Profitability and Cost Management.
attribute Characteristic of a dimension member. For
identifiable column descriptor you can display the alias instead of the member name.
alias table A table that contains alternate names for
example, Employee dimension members may have attributes of Name, Age, or Address. Product dimension members can have several attributes, such as a size and flavor.
attribute association A relationship in a database outline
members.
alternate hierarchy A hierarchy of shared members. An
alternate hierarchy is based upon an existing hierarchy in a database outline, but has alternate levels in the dimension. An alternate hierarchy allows the same data to be seen from different points of view.
ancestor A branch member that has members below it. For
whereby a member in an attribute dimension describes a characteristic of a member of its base dimension. For example, if product 100-10 has a grape flavor, the product 100-10 has the Flavor attribute association of grape. Thus, the 100-10 member of the Product dimension is associated with the Grape member of the Flavor attribute dimension.
Attribute Calculations dimension A system-defined dimension
example, the members Qtr2 and 2006 are ancestors of the member April.
appender A Log4j term for destination. application (1) A software program designed to run a specific
that performs these calculation operations on groups of members: Sum, Count, Avg, Min, and Max. This dimension is calculated dynamically and is not visible in the database outline. For example, using the Avg member, you can calculate the average sales value for Red products in New York in January.
attribute dimension A type of dimension that enables analysis
task or group of tasks such as a spreadsheet program or database management system. (2) A related set of dimensions and dimension members that are used to meet a specific set of analytical and/or reporting requirements.
application currency The default reporting currency for the
application.
area A predefined set of members and values that makes up
a partition.
arithmetic data load A data load that performs operations on
attribute type that enables different functions for grouping, selecting, or calculating data. For example, because the Ounces attribute dimension has the type numeric, the number of ounces specified as the attribute of each product can be used to calculate the profit per ounce for that product.
authentication Verification of identity as a security measure.
example, scripts, forms, rules files, Interactive Reporting documents, and financial reports. Also known as an object.
assemblies Installation files for EPM System products or
components.
asset account An account type that stores values that
Authentication is typically based on a user name and password. Passwords and digital signatures are forms of authentication.
authentication service A core service that manages one
authentication system.
auto-reversing journal A journal for entering adjustments that
300 Glossary
every report and book in the batch. While scheduling the batch, you can set the members selected on the batch POV.
batch processing mode A method of using ESSCMD to write
for measurement and categorization. (2) A report aspect used to arrange and relate multidimensional data, such as filters, pages, rows, and columns. For example, for a data query in Simple Basic, an axis can define columns for values for Qtr1, Qtr2, Qtr3, and Qtr4. Row data would be retrieved with totals in the following hierarchy: Market, Product.
backup A duplicate copy of an application instance. balance account An account type that stores unsigned values
a batch or script file that can be used to automate routine server maintenance and diagnostic tasks. ESSCMD script files can execute multiple commands and can be run from the operating system command line or from within operating system batch files. Batch files can be used to call multiple ESSCMD scripts or run multiple instances of ESSCMD.
block The primary storage unit which is a multidimensional
total credits.
bang character (!) A character that terminates a series of
report commands and requests information from the database. A report script must be terminated with a bang character; several bang characters can be used within a report script.
bar chart A chart that can consist of one to 50 data sets, with
categorizing and storing data based on the sparsity of data values defined in sparse dimensions. Data values are stored in blocks, which exist only for sparse dimension members for which there are values.
Blocked Account An account that you do not want calculated
any number of values assigned to each data set. Data sets are displayed as groups of corresponding bars, stacked bars, or individual bars in separate rows.
base currency The currency in which daily business
one or more attribute dimensions. For example, assuming products have flavors, the Product dimension is the base dimension for the Flavors attribute dimension.
base entity An entity at the bottom of the organization
displayed on a personal page of a user. The two types of bookmarks are My Bookmarks and image bookmarks.
bounding rectangle The required perimeter that encapsulates
the Interactive Reporting document content when embedding Interactive Reporting document sections in a personal page, specified in pixels for height and width or row per page.
broadcast message A simple text message sent by an
in batch; for example, a calculation script or a full database calculation. Dynamic calculations are not considered to be batch calculations.
batch file An operating system file that can call multiple
ESSCMD scripts and run multiple sessions of ESSCMD. On Windows-based systems, batch files have BAT file extensions. On UNIX, batch files are written as a shell script.
batch loader An FDM component that enables the
administrator to a user who is logged on to a Planning application. The message displays information to the user such as system availability, notification of application refresh, or application backups.
budget administrator A person responsible for setting up,
configuring, maintaining, and controlling an application. Has all application privileges and data access permissions.
Glossary 301
Choice of a build method is based on the format of data in data source files.
business process A set of activities that collectively
example, Month.
cause and effect map Depicts how the elements that form
your corporate strategy relate and how they work together to meet your organization's strategic goals. A Cause and Effect map tab is automatically created for each Strategy map.
CDF See custom-defined function (CDF). CDM See custom-defined macro (CDM). cell (1) The data value at the intersection of dimensions in
consolidated or aggregated. A calculation script may also contain commands that specify allocation and other calculation rules separate from the consolidation process.
calculated member in MaxL DML A member designed for
a multidimensional database; the intersection of a row and a column in a worksheet. (2) A logical group of nodes belonging to one administrative domain.
cell note A text annotation for a cell in an Essbase database.
analytical purposes and defined in the optional WITH section of a MaxL DML query.
calculated member in MaxL DML A member designed for
analytical purposes and defined in the optional WITH section of a MaxL DML query.
calculation The process of aggregating data, or of running a
visual nature expedites analysis, color-coding, and visual cues that aid comparisons.
chart template A template that defines the metrics to display
in Workspace charts.
child A member with a parent above it in the database
Planning, Financial Management, and Essbase users can design, validate, and administer business rules in a graphical environment.
calculation status A consolidation status that indicates that
outline.
choice list A list of members that a report designer can
some values or formula calculations have changed. You must reconsolidate to get the correct values for the affected entity.
calendar User-defined time periods and their relationship
specify for each dimension when defining the report's point of view. A user who wants to change the point of view for a dimension that uses a choice list can select only the members specified in that defined member list or those members that meet the criteria defined in the function for the dynamic list.
clean block A data block that where the database is fully
to each other. Q1, Q2, Q3, and Q4 comprise a calendar or fiscal year.
cascade The process of creating multiple reports for a subset
of member values.
Catalog pane Displays a list of elements available to the active
calculated, if a calculation script calculates all dimensions at once, or if the SET CLEARUPDATESTATUS command is used in a calculation script.
cluster An array of servers or databases that behave as a
section. If Query is the active section, a list of database tables is displayed. If Pivot is the active section, a list of results columns is displayed. If Dashboard is the active section, a list of embeddable sections, graphic tools, and control tools are displayed.
single resource which share task loads and provide failover support; eliminates one server or database as a single point of failure in a system.
clustered bar charts Charts in which categories are viewed
side-by-side; useful for side-by-side category analysis; used only with vertical bar charts.
302 Glossary
characters. Different code pages support different sets of characters. Each computer contains a code page setting for the character set requirements of the language of the computer user. In the context of this document, code pages map characters to bit combinations for non-Unicode encodings. See also encoding.
column A vertical display of information in a grid or table.
the consolidation of the node of the hierarchy. This rule can contain customer specific formulas appropriate for the correct consolidation of parent balances. Elimination processing can be controlled within these rules.
content Information stored in the repository for any type of
file.
content browser A Component that allows users to Browse
A column can contain data from one field, derived data from a calculation, or textual information.
committed access An Essbase Kernel Isolation Level setting
that affects how Essbase handles transactions. Under committed access, concurrent transactions hold long-term write locks and yield predictable results.
computed item A virtual column (as opposed to a column
that is physically stored in the database or cube) that can be calculated by the database during a query, or by Interactive Reporting Studio in the Results section. Computed items are calculations of data based on functions, data items, and operators provided in the dialog box and can be included in reports or reused to calculate other data.
configuration file The security platform relies on XML
certification and assessment information, especially helpful for meeting Sarbanes-Oxley requirements.
conversion rate See exchange rate. cookie A segment of data placed on your computer by a Web
site.
correlated subqueries Subqueries that are evaluated once for
documents to be configured by the product administrator or software installer. The XML document must be modified to indicate meaningful values for properties, specifying locations and attributes pertaining to the corporate authentication scenario.
connection file See Interactive Reporting connection file
every row in the parent query; created by joining a topic item in the subquery with a topic in the parent query.
critical business area (CBA) An individual or a group
organized into a division, region, plant, cost center, profit center, project team, or process; also called accountability team or business area.
critical success factor (CSF) A capability that must be
(.oce).
consolidated file (Parent) A file into which all of the business
established and sustained to achieve a strategic objective; owned by a strategic objective or a critical process and is a parent to one or more actions.
crosstab reporting Categorizes and summarizes data in table
dependent entities to parent entities. For example, if the dimension Year consists of the members Qtr1, Qtr2, Qtr3, and Qtr4, its consolidation is Year.
consolidation file (*.cns) The consolidation file is a graphical
interface that enables you to add, delete or move Strategic Finance files in the consolidation process using either a Chart or Tree view. It also enables you to define and modify the consolidation.
format. The table cells contain summaries of the data that fit within the intersecting categories. For example, a crosstab report of product sales information could show size attributes, such as Small and Large, as column headings and color attributes, such as Blue and Yellow, as row headings. The cell in the table where Large and Blue intersect could contain the total sales of all Blue products that are sized Large.
cube A block of data that contains three or more
Glossary 303
options for a model to build an outline and load data into an Essbase application and database.
cube schema In Essbase Studio, the metadata elements, such
provide an interactive summary of your business. Dashboards enable you to build and deploy analytic applications.
data cache A buffer in memory that holds uncompressed
data blocks.
data cell See cell. data file cache A buffer in memory that holds compressed
in a database from one currency into another. For example, to convert one U. S. dollar into the European euro, the exchange rate (for example, 0.923702) is multiplied with the dollar (1* 0.923702). After conversion, the European euro amount is .92.
Currency Overrides In any input period, the selected input
method can be overridden to enable input of that period's value as Default Currency/Items. To override the input method, enter a pound sign (#) either before or after the number.
currency partition A dimension type that separates local
the database from an interface such as a Web browser, and to view and analyze data or related text. Certain dimension member values are fixed, giving users a specific view into the data.
data function That computes aggregate values, including
averages, maximums, counts, and other statistics, that summarize groupings of data.
data load location In FDM, a reporting unit responsible for
currency members from a base currency, as defined in an application. Identifies currency types, such as Actual, Budget, and Forecast.
custom calendar Any calendar created by an administrator. custom dimension A dimension created and defined by users.
submitting source data into the target system. Typically, there is one FDM data load location for each source file loaded to the target system.
data load rules A set of criteria that determines how to load
data from a text-based file, a spreadsheet, or a relational data set into a database.
data lock Prevents changes to data according to specified
developed in Java and added to the standard Essbase calculation scripting language using MaxL. See also customdefined macro (CDM).
custom-defined macro (CDM) Essbase macros written with
Essbase calculator functions and special macro functions. Custom-defined macros use an internal Essbase macro language that enables the combination of calculation functions and they operate on multiple input parameters. See also custom-defined function (CDF).
cycle through To perform multiple passes through a database
properties used to connect to data sources and enables database references to be portable and widely used.
304 Glossary
dimension where measures are represented. The cell values are displayed as formatted dates. Dates as measures can be useful for types of analysis that are difficult to represent using the Time dimension. For example, an application may need to track acquisition dates for a series of capital assets, but the acquisition dates span too large a period to allow for feasible Time dimension modeling. See also typed measure.
Default Currency Units Define the unit scale of data. For
that you see in a Summary chart. Detail charts appear in the Investigate Section in columns below the Summary charts. If the Summary chart shows a Pie chart, then the Detail charts below represent each piece of the pie.
dimension A data category used to organize business data for
example, if you select to define your analysis in Thousands, and enter 10, this is interpreted as 10,000.
dense dimension In block storage databases, a dimension
retrieval and preservation of values. Dimensions usually contain hierarchies of related members grouped within them. For example, a Year dimension often includes members for each time period, such as quarters and months.
dimension build The process of adding dimensions and
likely to contain data for every combination of dimension members. For example, time dimensions are often dense because they can contain all combinations of all members. Contrast with sparse dimension.
dependent entity An entity that is owned by another entity in
that Essbase uses to modify an outline. The modification is based on data in an external data source file.
dimension tab In the Pivot section, the tab that enables you
the organization.
derived text measure In Essbase Studio, a text measure whose
values are governed by a predefined rule expressed as a range. For example, a derived text measure, called "Sales Performance Index," based on a measure Sales, could consist of the values "High," "Medium," and "Low." This derived text measure is defined to display "High," "Medium," and "Low" depending on the range in which the corresponding sales values fall. See also text measure.
descendant Any member below a parent in the database
about a specific business process. (2) In Essbase Integration Services, a container in the OLAP model for one or more relational tables that define a potential dimension in Essbase.
dimension type A dimension property that enables the use of
outline. In a dimension that includes years, quarters, and months, the members Qtr2 and April are descendants of the member Year.
Design Report An interface in Web Analysis Studio for
(and the order in which they are represented) in a set. For example, the following set consists of two tuples of the same dimensionality because they both reflect the dimensions (Region, Year): { (West, Feb), (East, Mar) }
direct rate A currency rate that you enter in the exchange
an intersection within the database where allocated values are stored. (2) Within a Profitability and Cost Management assignment, the receiving point for allocated values.
destination currency The currency to which balances are
rate table. The direct rate is used for currency conversion. For example, to convert balances from JPY to USD, In the exchange rate table, enter a rate for the period/scenario where the source currency is JPY and the destination currency is USD.
dirty block A data block containing cells that have been
converted. You enter exchange rates and convert from the source currency to the destination currency. For example, when you convert from EUR to USD, the destination currency is USD.
changed since the last calculation. Upper level blocks are marked as dirty if their child blocks are dirty (that is, they have been updated).
display type One of three Web Analysis formats saved to the
Glossary 305
that is based on user-defined criteria. The list is refreshed automatically whenever it is referenced in the application. As dimension members are added and deleted, the list automatically reapplies the criteria to reflect the changes.
dynamic reference A pointer in the rules file to header records
dimensional hierarchy. Drilling down moves the user perspective from aggregated data to detail. For example, drilling down can reveal hierarchical relationships between years and quarters or quarters and months.
drill-through The navigation from a value in one data source
in a data source.
dynamic report A report containing data that is updated when
mathematical relationship between the sources that utilize the driver, and the destinations to which those sources allocate cost or revenue.
duplicate alias name A name that occurs more than once in
account values are calculated dynamically from the data that is displayed.
Eliminated Account An account that does not appear in the
consolidated file.
elimination The process of zeroing out (eliminating)
an alias table and that can be associated with more than one member in a database outline. Duplicate alias names can be used with duplicate member outlines only.
duplicate member name The multiple occurrence of a member
name in a database, with each occurrence representing a different member. For example, a database has two members named New York. One member represents New York state and the other member represents New York city.
duplicate member outline A database outline containing
business objects. Employees need not work for an organization; for example, they can be consultants. Employees must be associated with user accounts for authorization purposes.
encoding A method for mapping bit combinations to
outline that Essbase calculates only upon the first retrieval of the value. Essbase then stores the calculated value in the database. Subsequent retrievals do not require calculating.
Dynamic Calc members A member in a block storage outline
characters for creating, storing, and displaying text. Each encoding has a name; for example, UTF-8. Within an encoding, each character maps to a specific bit combination; for example, in UTF-8, uppercase A maps to HEX41. See also code page and locale.
ending period A period enabling you to adjust the date range
that Essbase calculates only at retrieval time. Essbase discards calculated values after completing the retrieval request.
dynamic calculation In Essbase, a calculation that occurs only
in a chart. For example, an ending period of month, produces a chart showing information through the end of the current month.
Enterprise View An Administration Services feature that
when you retrieve data on a member that is tagged as Dynamic Calc or Dynamic Calc and Store. The member's values are calculated at retrieval time instead of being precalculated during batch calculation.
dynamic hierarchy In aggregate storage database outlines
enables management of the Essbase environment from a graphical tree view. From Enterprise View, you can operate directly on Essbase artifacts.
entity A dimension representing organizational units.
Examples: divisions, subsidiaries, plants, regions, products, or other financial reporting units.
306 Glossary
variance between its return and the market return, indicated by an index called beta. For example, if a stock's return normally moves up or down 1.2% when the market moves up or down 1%, the stock has a beta of 1.2.
essbase.cfg An optional configuration file for Essbase.
Administrators may edit this file to customize Essbase Server functionality. Some configuration settings may also be used with Essbase clients to override Essbase Server settings.
EssCell A function entered into a cell in Essbase Spreadsheet
handles the selection, orientation, grouping, and ordering of raw data extracted from a database; begins with the less than (<) character.
fact table The central table in a star join schema,
characterized by a foreign key and elements drawn from a dimension table. This table typically contains numeric data that can be related to all other tables in the schema.
Favorites gadget Contains links to Reporting and Analysis
Essbase database.
file delimiter Characters, such as commas or tabs, that
can define formatting indicators or notify subscribing users when exceptions are generated.
exchange rate A numeric value for converting one currency
criteria; for example, to exclude certain tables, metadata, or values, or to control access.
flow account An unsigned account that stores periodic and
to another. For example, to convert 1 USD into EUR, the exchange rate of 0.8936 is multiplied with the U.S. dollar. The European euro equivalent of $1 is 0.8936.
exchange rate type An identifier for an exchange rate.
year-to-date values.
folder A file containing other files for the purpose of
structuring a hierarchy.
footer Text or images at the bottom of report pages,
Different rate types are used because there may be multiple rates for a period and year. Users traditionally define rates at period end for the average rate of the period and for the end of the period. Additional rate types are historical rates, budget rates, forecast rates, and so on. A rate type applies to one point in time.
expense account An account that stores periodic and year-
containing dynamic functions or static text such as page numbers, dates, logos, titles or file names, and author names.
format Visual characteristics of documents or report
objects.
format string In Essbase, a method for transforming the way
of tags used to assign attributes to data that can be interpreted between applications according to a schema.
external authentication Logging on to Oracle's Hyperion
applications with user information stored outside the applications, typically in a corporate directory such as MSAD or NTLM.
Glossary 307
installed.
host properties Properties pertaining to a host, or if the host
provide easy viewing of EPM content and enable access to core Reporting and Analysis functionality.
genealogy data Additional data that is optionally generated
has multiple Install_Homes, to an Install_Home. The host properties are configured from the CMC.
Hybrid Analysis An analysis mapping low-level data stored in
after allocation calculations. This data enables reporting on all cost or revenue flows from start to finish through all allocation steps.
generation A layer in a hierarchical tree structure that defines
a relational database to summary-level data stored in Essbase, combining the mass scalability of relational systems with multidimensional data.
hyperlink A link to a file, Web page, or an intranet HTML
page.
Hypertext Markup Language (HTML) A programming language
member relationships in a database. Generations are ordered incrementally from the top member of the dimension (generation 1) down to the child members. Use the unique generation name to identify a layer in the hierarchical tree structure.
generic jobs Non-SQR Production Reporting or non-
external authentication.
image bookmarks Graphic links to Web pages or repository
items.
IMPACTED status Indicates changes in child entities
that is effective until replaced by another global command or the file ends.
grid POV A means for specifying dimension members on a
grid without placing dimensions in rows, columns, or page intersections. A report designer can set POV values at the grid level, preventing user POVs from affecting the grid. If a dimension has one grid value, you put the dimension into the grid POV instead of the row, column, or page.
group A container for assigning similar access permissions
which enables the loading of a source data file to an FDM data load location.
inactive group A group for which an administrator has
to multiple users.
GUI Graphical user interface head up display A mode that shows your loaded Smart Space
an administrator.
income account An account storing periodic and year-to-
ZoomChart details may be highlighted, indicating value status: red (bad), yellow (warning), or green (good).
Historical Average An average for an account over a number
of historical periods.
combinations to retrieve data in block storage databases. (2) The index file.
308 Glossary
index cache A buffer containing index pages. index entry A pointer to an intersection of sparse dimensions.
Index entries point to data blocks on disk and use offsets to locate cells.
index file An Essbase file storing block storage data retrieval
to data blocks.
input data Data loaded from a source rather than calculated. Install_Home A variable for the directory where EPM System
hierarchies based on the inherent relationships in the database. Contrast with scraping.
Investigation See drill-through. isolation level An Essbase Kernel setting that determines the
products are installed. Refers to one instance of an EPM System product when multiple applications are installed on the same computer.
integration Process that is run to move data between EPM
lock and commit behavior of database operations. Choices are: committed access and uncommitted access.
iteration A pass of the budget or planning cycle in which
System products using Shared Services. Data integration definitions specify the data moving between a source application and a destination application, and enable the data movements to be grouped, ordered, and scheduled.
intelligent calculation A calculation method tracking updated
communication protocol used by Java based clients and relational databases. The JDBC interface provides a calllevel API for SQL-based database access.
job output Files or reports produced from running a job. jobs Documents with special properties that can be
database connection information, including: the database API (ODBC, SQL*Net, etc.), database software, the database server network address, and database user name. Administrators create and publish Interactive Reporting connection files (.oce).
intercompany elimination See elimination. intercompany matching The process of comparing balances
launched to generate output. A job can contain Interactive Reporting, SQR Production Reporting, or generic documents.
join A link between two relational database tables or topics
for pairs of intercompany accounts within an application. Intercompany receivables are compared to intercompany payables for matches. Matching accounts are used to eliminate intercompany transactions from an organization's consolidated totals.
intercompany matching report A report that compares
based on common content in a column or row. A join typically occurs between identical or similar items within different tables or topics. For example, a record in the Customer table is joined to a record in the Orders table because the Customer ID value is the same in each table.
journal entry (JE) A set of debit/credit adjustments to account
intercompany account balances and indicates if the accounts are in, or out, of balance.
interdimensional irrelevance A situation in which a dimension
and provides access to Smart Space Collaborator. For example, you can have a KeyContacts gadget for your marketing team and another for your development team.
latest A Spreadsheet key word used to extract data values
does not intersect with other dimensions. Because the data in the dimension cannot be accessed from the nonintersecting dimensions, the non-intersecting dimensions are not relevant to that dimension.
Glossary 309
hierarchical structure, specified by generation (top down) or level (bottom up). (2) Position of objects relative to other objects. For example, in the Sample Basic database, Qtr1 and Qtr4 are in the same layer, so they are also in the same generation, but in a database with a ragged hierarchy, Qtr1 and Qtr4 might not be in same layer, though they are in the same generation.
layout area Used to designate an area on a Workspace Page
reference folders, files, shortcuts, and other links. (2) In a task flow, the point where the activity in one stage ends and another begins.
link condition A logical expression evaluated by the taskflow
in a repository.
linked partition A shared partition that enables you to use a
categories of a dimension.
level A layer in a hierarchical tree structure that defines
database member relationships. Levels are ordered from the bottom dimension member (level 0) up to the parent members.
level 0 block A data block for combinations of sparse, level 0
data cell to link two databases. When a user clicks a linked cell in a worksheet, Essbase opens a new sheet displaying the dimensions in the linked database. The user can then drill down those dimensions.
linked reporting object (LRO) A cell-based link to an external
members.
level 0 member A member that has no children. liability account An account type that stores point in time
file such as cell notes, URLs, or files with text, audio, video, or pictures. (Only cell notes are supported for Essbase LROs in Financial Reporting.) Contrast with local report object.
local currency An input currency type. When an input
balances of a company's liabilities. Examples of liability accounts include accrued expenses, accounts payable, and long term debt.
life cycle management The process of managing application
currency type is not specified, the local currency matches the entity's base currency.
local report object A report object that is not linked to a
Financial Reporting report object in Explorer. Contrast with linked reporting object (LRO).
local results A data model's query results. Results can be used
in local joins by dragging them into the data model. Local results are displayed in the catalog when requested.
locale A computer setting that specifies a location's
represented by a line. A line chart can display each line stacked on the preceding ones, as represented by an absolute value or a percent.
line item detail The lowest level of detail in an account. lineage The relationship between different metadata
language, currency and date formatting, data sort order, and the character set encoding used on the computer. Essbase uses only the encoding portion. See also encoding and ESSLANG.
locale header record A text record at the beginning of some
elements showing how one metadata element is derived from one or more other metadata elements, ultimately tracing the metadata element to its physical source. In Essbase Studio, a lineage viewer displays the relationships graphically. See also traceability.
non-Unicode-encoded text files, such as scripts, that identifies the encoding locale.
location alias A descriptor that identifies a data source. The
location alias specifies a server, application, database, user name, and password. Location aliases are set by DBAs at the database level using Administration Services Console, ESSCMD, or the API.
locked A user-invoked process that prevents users and
310 Glossary
user.
LOCKED status A consolidation status indicating that an
calculated in formulas and outlines. Can be any of the standard mathematical or Boolean operators; for example, +, -, *, /, and %.
MaxL The multidimensional database access language for
Essbase, consisting of a data definition language (MaxL DDL) and a data manipulation language (MaxL DML). See also MaxL DDL, MaxL DML, and MaxL Shell.
MaxL DDL Data definition language used by Essbase for batch
that are generated after a source file is loaded into FDM. Logic accounts are calculated accounts that are derived from the source data.
LRO See linked reporting object (LRO). managed server An application server process running in its
complete.
Map File Used to store the definition for sending data to or
Essbase MaxL DDL. This module can be added to the Perl package to provide access to Essbase databases from Perl programs.
MaxL Script Editor A script-development environment in
retrieving data from an external database. Map files have different extensions (.mps to send data; .mpr to retrieve data).
Map Navigator A feature that displays your current position
Administration Services Console. MaxL Script Editor is an alternative to using a text editor and the MaxL Shell for administering Essbase with MaxL scripts.
MaxL Shell An interface for passing MaxL statements to
Essbase Server. The MaxL Shell executable file is located in the Essbase bin directory (UNIX: essmsh, Windows: essmsh.exe).
MDX (multidimensional expression) The language that give
Represents the tax rate applied to the last earned income dollar (the rate from the highest tax bracket into which income falls) and includes federal, state and local taxes. Based on current level of taxable income and tax bracket, you can predict marginal tax rate.
Market Risk Premium The additional rate of return paid over
the risk-free rate to persuade investors to hold riskier investments than government securities. Calculated by subtracting the risk-free rate from the expected market return. These figures should closely model future market conditions.
master data model An independent data model that is
instructions to OLE DB for OLAP- compliant databases, as SQL is used for relational databases. When you build the OLAPQuery section's Outliner, Interactive Reporting Clients translate requests into MDX instructions. When you process the query, MDX is sent to the database server, which returns records that answer your query. See also SQL spreadsheet.
measures Numeric values in an OLAP database cube that are
available for analysis. Measures are margin, cost of goods sold, unit sales, budget amount, and so on. See also fact table.
member A discrete component within a dimension. A
referenced as a source by multiple queries. When used, Locked Data Model is displayed in the Query section's Content pane; the data model is linked to the master data model displayed in the Data Model section, which an administrator may hide.
member identifies and differentiates the organization of similar units. For example, a time dimension might include such members as Jan, Feb, and Qtr1.
Glossary 311
command that selects member ranges based on outline relationships, such as sibling, generation, and level.
member-specific report command A type of Report Writer
formatting command that is executed as it is encountered in a report script. The command affects only its associated member and executes the format command before processing the member.
merge A data load option that clears values only from the
accounts specified in the data load file and replaces them with values in the data load file.
metadata A set of data that defines and describes the
attribute that describes the data format of an item, so that the system knows which application should open the object. A file's mime type is determined by the file extension or HTTP header. Plug-ins tell browsers what mime types they support and what file extensions correspond to each mime type.
mining attribute In data mining, a class of values used as a
properties and attributes of the data stored in a database or used by an application. Examples of metadata are dimension names, member names, properties, time periods, and security.
metadata elements Metadata derived from data sources and
content, hyperlinks, and the query or queries to load the report. Each report can include one or more minireports.
minischema A graphical representation of a subset of tables
other metadata that is stored and cataloged for Essbase Studio use.
metadata sampling The process of retrieving a sample of
labeled location does not exist, contains no value, or was never entered or loaded. For example, missing data exists when an account contains data for a previous or future period but not for the current period.
model (1) In data mining, a collection of an algorithm's
the structure and rules for creating an Essbase outline from an OLAP model.
metric A numeric measurement computed from business
users from one environment or computer to another; for example, from a testing environment to a production environment.
findings about examined data. A model can be applied against a wider data set to generate useful information about that data. (2) A file or content string containing an application-specific representation of data. Models are the basic data managed by Shared Services, of two major types: dimensional and non-dimensional application objects. (3) In Business Modeling, a network of boxes connected to represent and calculate the operational and financial flow through the area being examined.
monetary A money-related value.
312 Glossary
and referencing data through three or more dimensions. An individual value is the intersection point for a set of dimensions. Contrast with relational database.
multiload An FDM feature that allows the simultaneous
multiple sources including documents, URL, and other content types. Enables a user to aggregate content from Oracle and non-Oracle sources.
named set In MaxL DML, a set with its logic defined in the
dimension member that has a discrete numeric value with an attribute that represents a value range. For example, to classify customers by age, an Age Group attribute dimension can contain members for the following age ranges: 0-20, 21-40, 41-60, and 61-80. Each Customer dimension member can be associated with an Age Group range. Data can be retrieved based on the age ranges rather than on individual age values.
ODBC Open Database Connectivity. A database access
optional WITH section of a MaxL DML query. The named set can be referenced multiple times in the query.
native authentication The process of authenticating a user
method used from any application regardless of how the database management system (DBMS) processes the information.
OK status A consolidation status indicating that an entity has
already been consolidated, and that data has not changed below it in the organization structure.
OLAP Metadata Catalog In Integration Services, a relational
displays data from multiple dimensions. For example, a column heading that contains Year and Scenario members is a nested column. The nested column heading shows Q1 (from the Year dimension) in the top line of the heading, qualified by Actual and Budget (from the Scenario dimension) in the bottom line of the heading.
NO DATA status A consolidation status indicating that this
database containing metadata describing the nature, source, location, and type of data that is pulled from the relational data source.
OLAP model In Integration Services, a logical model (star
schema) that is created from tables and columns in a relational database. The OLAP model is then used to generate the structure of a multidimensional database.
online analytical processing (OLAP) A multidimensional,
includes application objects such as security files, member lists, calculation scripts, and Web forms.
non-unique member name See duplicate member name. note Additional information associated with a box,
multiuser, client-server computing environment for users who analyze consolidated enterprise data in real time. OLAP systems feature drill-down, data pivoting, complex calculations, trend analysis, and modeling.
Open Database Connectivity (ODBC) Standardized application
programming interface (API) technology that allows applications to access multiple third-party databases.
organization An entity hierarchy that defines each entity and
equal to zero.
database, including all dimensions, members, tags, types, consolidations, and mathematical relationships. Data is stored in the database according to the structure defined in the outline.
Glossary 313
shared or linked between data models. Partitioning can affect the performance and scalability of Essbase applications.
pattern matching The ability to match a value with any or all
typical grouping of expense and income accounts that comprise a company's income statement.
page A display of information in a grid or table often
represented by the Z-axis. A page can contain data from one field, derived data from a calculation, or text.
page file Essbase data file. page heading A report heading type that lists members
characters of an item entered as a criterion. Missing characters may be represented by wild card values such as a question mark (?) or an asterisk (*). For example, Find all instances of apple returns apple, but Find all instances of apple* returns apple, applesauce, applecranberry, and so on.
percent consolidation The portion of a child's values that is
represented on the current page of the report. All data values on the page have the members in the page heading as a common attribute.
page member A member that determines the page axis. palette A JASC compliant file with a .PAL extension. Each
palette contains 16 colors that complement each other and can be used to set the dashboard color elements.
parallel calculation A calculation option. Essbase divides a
measure and scorecard performance based on a range you specify; also called a status symbol. You can use the default performance indicators or create an unlimited number of your own.
periodic value method (PVA) A process of currency conversion
that applies the periodic exchange rate values over time to derive converted results.
permission A level of access granted to users and groups for
files. This may be faster than exporting to a single file, and it may resolve problems caused by a single data file becoming too large for the operating system to handle.
parent adjustments The journal entries that are posted to a
Essbase operation or setting. For example, an Essbase administrator may limit the persistence of user name and password validity.
personal pages A personal window to repository
entities that report directly to them. Because parents are both entities and associated with at least one node, they have entity, node, and parent information associated with them.
partition area A sub cube within a database. A partition is
information. You select what information to display and its layout and colors.
personal recurring time events Reusable time events that are
composed of one or more areas of cells from a portion of the database. For replicated and transparent partitions, the number of cells within an area must be the same for the data source and target to ensure that the two partitions have the same shape. If the data source area contains 18 cells, the data target area must also contain 18 cells to accommodate the number of values.
member selections.
314 Glossary
scorecard or strategic objectives within an application. A perspective can represent a key stakeholder (such as a customer, employee, or shareholder/financial) or a key competency area (such as time, cost, or quality).
pie chart A chart that shows one data set segmented in a pie
retrieval.
precision Number of decimal places displayed in numbers. predefined drill paths Paths used to drill to the next level of
formation.
pinboard One of the three data object display types.
Pinboards are graphics, composed of backgrounds and interactive icons called pins. Pinboards require traffic lighting definitions.
pins Interactive icons placed on graphic reports called
reports to be grouped, organized, ordered, distributed, and reviewed. Includes pointers referencing reports in the repository.
preserve formulas User-created formulas kept within a
pinboards. Pins are dynamic. They can change images and traffic lighting color based on the underlying data values and analysis tools criteria.
pivot The ability to alter the perspective of retrieved data.
When Essbase first retrieves a dimension, it expands data into rows. You can then pivot or rearrange the data to obtain a different viewpoint.
planner Planners, who comprise the majority of users, can
input and submit data, use reports that others create, execute business rules, use task lists, enable e-mail notification for themselves, and use Smart View.
planning unit A data slice at the intersection of a scenario,
positions within the FDM data conversion process. You can use the process monitor report to monitor the status of the closing process. The report is time-stamped. Therefore, it can be used to determine to which locations at which time data was loaded.
product In Shared Services, an application type, such as
version, and entity; the basic unit for preparing, reviewing, annotating, and approving plan data.
plot area The area bounded by X, Y, and Z axes; for pie
together in an implementation. For example, a Planning project may consist of a Planning application, an Essbase cube, and a Financial Reporting server instance.
property A characteristic of an artifact, such as size, type, or
of balance differences between intercompany account pairs during the elimination process.
post stage assignment Assignments in the allocation model
processing instructions.
provisioning The process of granting users and groups
members that are not already assigned to row, column, or page axes. For example, selectable POVs in FDM could include location, period, category, and target category. In another example, using POV as a filter in Smart View, you could assign the Currency dimension to the POV and select the Euro member. Selecting this POV in data forms displays data in Euro values.
Glossary 315
differentiates duplicate member names in a duplicate member outline. For example, [Market].[East].[State]. [New York] or [Market].[East].[City].[New York]
query Information requests from data providers. For
all accounts for periods specified in the data load file, and loads values from the data load file. If an account is not specified in the load file, its values for the specified periods are cleared.
replicated partition A portion of a database, defined through
Essbase server configuration setting that controls the duration and size of queries made to data sources.
range A set of values including upper and lower limits, and
Partition Manager, used to propagate an update to data mastered at one site to a copy of data stored at another site. Users can access the data as though it were part of their local database.
Report Extractor An Essbase component that retrieves report
data from the Essbase database when report scripts are run.
report object In report designs, a basic element with
properties defining behavior or appearance, such as text boxes, grids, images, and charts.
report script A text file containing Essbase Report Writer
complete entry. For example, a customer record may contain fields for name, address, telephone number, and sales data.
recurring template A journal template for making identical
information after a database has been damaged or destroyed, typically performed after shutting down and restarting the database.
restructure An operation to regenerate or rebuild the
related accounts under the same main account number. The main account is distinguished from related accounts by the first suffix of the account number.
relational database A type of database that stores data in
representing the process unit level, such as Not Started, First Pass, Submitted, Approved, and Published.
Risk Free Rate The rate of return expected from safer
316 Glossary
than primary measures. Secondary measures do not have Performance reports but can be used on scorecards and to create dimension measure templates.
security agent A Web access management provider (for
Service Configurator, including Repository Service, Service Broker, Name Service, Event Service, and Job Service.
runtime prompt A variable that users enter or select before a
drive key business calculations (for example, the cost per square foot of office floor space).
scaling Scaling determines the display of values in whole
another member of the same name, preventing duplicate calculation of members that occur multiple times in an Essbase outline.
Shared Services Registry Part of the Shared Services database,
operation or setting; for example, the area of data affected by a security setting. Most commonly, scope refers to three levels of granularity, where higher levels encompass lower levels. From highest to lowest, these levels are as follows: the entire system (Essbase Server), applications on Essbase servers, or databases within Essbase server applications. See also persistence.
score The level at which targets are achieved, usually
the Shared Services Registry stores and re-uses information for most installed EPM System products, including installation directories, database settings, deployment settings, computer names, ports, servers, URLs, and dependent service data.
Shared Workspace Page Workspace Pages shared across an
organization which are stored in a special System folder and can be accessed by authorized users from the Shared Workspace Pages Navigate menu.
sibling A child member at the same generation as another
employee, strategy element, or accountability element toward goals. Scorecards ascertain this progress based on data collected for each measure and child scorecard added to the scorecard.
scraping An inspection of a data source to derive the most
child member and having the same immediate parent. For example, the members Florida and New York are children of East and each other's siblings.
single sign-on Ability to access multiple EPM System
repository. The Search gadget looks for a match in the document keywords and description, which are set when you import a document.
Glossary 317
provides gadgets, instant collaboration and access to the Reporting and Analysis repository. It is composed of the Smart Space framework and gadgets.
Smart Space Collaborator A service that enables users or
systems to send messages and share Reporting and Analysis repository content. The message can take many forms, including instant message style discussions, meetings, and toast messages.
smart tags Keywords in Microsoft Office applications that
a specific application. A staging area is a snapshot or restructured version of one or more RDBMSs.
standard dimension A dimension that is not an attribute
are associated with predefined actions available from the Smart Tag menu. In EPM System products, smart tags can also be used to import Reporting and Analysis content, and access Financial Management and Essbase functions.
SmartBook gadget Contains documents from the Reporting
dimension.
standard journal template A journal function used to post
and Analysis repository or URLs. All documents are loaded when the SmartBook is opened so you can access all content immediately.
SmartCut A link to a repository item, in URL form. snapshot Read-only data from a specific time. source currency The currency from which values originate
adjustments that have common adjustment information for each period. For example, you can create a standard template that contains the common account IDs, entity IDs, or amounts, then use the template as the basis for many regular journals.
Status bar The status bar at the bottom of the screen displays
helpful information about commands, accounts, and the current status of your data file.
stored hierarchy In aggregate storage databases outlines only.
A hierarchy in which the members are aggregated according to the outline structure. Stored hierarchy members have certain restrictions, for example, they cannot contain formulas.
strategic objective (SO) A long-term goal defined by
unlikely to contain data for all member combinations when compared to other dimensions. For example, not all customers have data for all products. Contrast with dense dimension.
SPF files Printer-independent files created by an SQR
measurable results. Each strategic objective is associated with one perspective in the application, has one parent, the entity, and is a parent to critical success factors or other strategic objectives.
Strategy map Represents how the organization implements
Production Reporting server, containing a representation of the actual formatted report output, including fonts, spacing, headers, footers, and so on.
Spotlighter A tool that enables color coding based on selected
high-level mission and vision statements into lower-level, constituent strategic goals and objectives.
structure view Displays a topic as a simple list of component
conditions.
SQL spreadsheet A data object that displays the result set of
data items.
Structured Query Language A language used to process
a SQL query.
SQR Production Reporting A specialized programming
language for data access, data manipulation, and creating SQR Production Reporting documents.
318 Glossary
charts shown below in the same column, plotting metrics at the summary level at the top of each chart column.
super service A special service used by the
the execution of a taskflow including: definitions, user or application interactions, and application executables.
taskflow participant The resource who performs the task
associated with the taskflow stage instance for both manual and automated stages.
Taxes - Initial Balances Strategic Finance assumes that the
Initial Loss Balance, Initial Gain Balance and the Initial Balance of Taxes Paid entries have taken place in the period before the first Strategic Finance time period.
TCP/IP See Transmission Control Protocol/Internet Protocol
(TCP/IP).
template A predefined format designed to retrieve particular
enables multiprocessing and multithreading. Performance is not significantly degraded when a large number of users connect to an single instance simultaneously.
sync Synchronizes Shared Services and application models. synchronized The condition that exists when the latest
data consistently.
text list In Essbase, an object that stores text values mapped
version of a model resides in both the application and in Shared Services. See also model.
system extract Transfers data from an application's metadata
expressed as text. In Essbase, a member tagged as Text in the dimension where measures are represented. The cell values are displayed as predefined text. For example, the text measure "Satisfaction Index" may have the values Low, Medium, and High. See also typed measure, text list, derived text measure.
time dimension Defines the time period that the data
Finance.
target Expected results of a measure for a specified period
tasks are passed from one taskflow participant to another according to procedural rules.
taskflow definition Represents business processes in the
dates and times of completed process flow steps for specific locations.
time scale Displays metrics by a specific period in time, such
as monthly or quarterly.
time series reporting A process for reporting data based on a
taskflow management system. Consists of a network of stages and their relationships; criteria indicating the start and end of the taskflow; and information about individual stages, such as participants, associated applications, associated activities, and so on.
taskflow instance Represents a single instance of a taskflow
Glossary 319
top and side labels Column and row headings on the top and
in a dimension outline hierarchy, or the first member of the dimension in sort order if there is no hierarchical relationship among dimension members. The top-level member name is generally the same as the dimension name if a hierarchical relationship exists.
trace allocations A feature of Profitability and Cost
currency to another via a third common currency. In Europe, this is the euro for member countries. For example, to convert from French franc to Italian lira, the common currency is defined as European euro. Therefore, in order to convert balances from French franc to Italian lira, balances are converted from French franc to European euro and from European euro to Italian lira.
triggers An Essbase feature whereby data is monitored
Management that enables you to visually follow the flow of financial data, either forwards or backwards, from a single intersection throughout the model.
trace level Defines the level of detail captured in the log file. traceability The ability to track a metadata element to its
according to user-specified criteria which when met cause Essbase to alert the user or system administrator.
trusted password A password that enables users
authenticated for one product to access other products without reentering their passwords.
trusted user Authenticated user. tuple MDX syntax element that references a cell as an
physical source. For example, in Essbase Studio, a cube schema can be traced from its hierarchies and measure hierarchies, to its dimension elements, date/time elements, and measures, and ultimately, to its physical source elements.
traffic lighting Color-coding of report cells, or pins based on
intersection of a member from each dimension. If a dimension is omitted, its top member is implied. Examples: (Jan); (Jan, Sales); ( [Jan], [Sales], [Cola], [Texas], [Actual] )
two-pass An Essbase property that is used to recalculate
properly in the destination environment after application migration. (2) In data mining, modifies data (bidirectionally) flowing between the cells in the cube and the algorithm.
translation See currency conversion. Transmission Control Protocol/Internet Protocol (TCP/IP) A
members that are dependent on the calculated values of other members. Two-pass members are calculated during a second pass through the outline.
typed measure In Essbase, a member tagged as Text or
Date in the dimension where measures are represented. The cell values are displayed as predefined text or dates.
unary operator A mathematical indicator (+, -, *, /, %)
standard set of communication protocols linking computers with different operating systems and internal architectures. TCP/IP utilities are used to exchange files, send mail, and store data to various computers that are connected to local and wide area networks.
transparent login Logs in authenticated users without
associated with an outline member. The unary operator defines how the member is calculated during a database rollup.
Unicode-mode application An Essbase application wherein
character text is encoded in UTF-8, enabling users with computers set up for different languages to share application data.
Uniform Resource Locator The address of a resource on the
Internet or an intranet.
unique member name A non-shared member name that exists
access and change data in a remote database as though it is part of a local database
320 Glossary
highlights specific types of data values. Data values may be dimension members; parent, child, or shared members; dynamic calculations; members containing a formula; read only data cells; read and write data cells; or linked objects.
Web server Software or hardware hosting intranet or
user's member selection, displaying only the specified entity. For example, user variable named Department displays specific departments and employees.
user-defined attribute (UDA) User-defined attribute,
associated with members of an outline to describe a characteristic of the members. Users can use UDAs to return lists of members that have the specified UDA associated with them.
user-defined member list A named, static set of members
indicates the relative importance of that item in the calculation of the overall scorecard score. The weighting of all items on a scorecard accumulates to 100%. For example, to recognize the importance of developing new features for a product, the measure for New Features Coded on a developer's scorecard would be assigned a higher weighting than a measure for Number of Minor Defect Fixes.
wild card Character that represents any single character or
script, or partition definition against the outline to make sure that the object being checked is valid. For example, in FDM, validation rules ensure that certain conditions are met after data is loaded from FDM to the target application.
value dimension Used to define input value, translated value,
used for creating re-usable logic to define sets or members. Sets or custom members can be defined once in the WITH section, and then referenced multiple times during a query.
work flow The steps required to process data from start to
finish in FDM. The workflow consists of Import (loading data from the GL file), Validate (ensures all members are mapped to a valid account), Export (loads the mapped members to the target application), and Check (verifies accuracy of data by processing data with user-defined validation rules).
workbook An entire spreadsheet file with many worksheets. Workspace Page A page created with content from multiple
one or more dimensions. It can be used to track a value in relation to these dimensions; for example, the varying attribute Sales Representative, associated with the Product dimension, can be used to track the value Customer Sales of several different sales representatives in relation to the Time dimension. Varying attributes can also be used for member selection, such as finding the Products that a Sales Representative was responsible for in May.
version Possible outcome used within the context of a
sources including documents, URL, and other content types. Enables a user to aggregate content from Oracle and non-Oracle sources.
write-back The ability for a retrieval client, such as a
scenario of data. For example, Budget - Best Case and Budget - Worst Case where Budget is scenario and Best Case and Worst Case are versions.
view Representation of either a year-to-date or periodic
display of data.
Glossary 321
only the outline metadata and retrieves all data from a relational database at query time. XOLAP supports aggregate storage databases and applications that contain duplicate member names.
Y axis scale Range of values on Y axis of charts displayed in
Investigate Section. For example, use a unique Y axis scale for each chart, the same Y axis scale for all Detail charts, or the same Y axis scale for all charts in the column. Often, using a common Y axis improves your ability to compare charts at a glance.
Zero Administration Software tool that identifies version
magnify a report to fit whole page, page width, or percentage of magnification based on 100%.
ZoomChart Used to view detailed information by enlarging
a chart. Enables you to see detailed numeric information on the metric that is displayed in the chart.
322 Glossary
Index
A
Account dimension, 20 Accumulate data load option, 55 Accumulate Within File data load option, 55 active entities, 36, 39 Active status, 134 adjustments entering, 210 viewing in Explore Data, 76 viewing on the Web, 93 alerting, 271 allocations running from Explore Data, 79 running on the Web, 97 Approved journal status, 218 approving process units, 263 autoreversing journals, 214
B
balanced journals, 201
C
Calculate Ownership option, 135 calculating data, 110 calculation status displaying in data grids, 70 displaying on the Web, 84 cell adjustments viewing in Explore Data, 76 viewing on the Web, 93 cell colors in Explore Data, 73 in Web data grids, 90 cell descriptions in Explore Data, 77 on the Web, 93 cell history, 97
cell information, 76, 92 cell text in Explore Data, 77 on the Web, 94 Chart Logic (CH) status, 74 clearing data, 66 colors in Explore Data cells, 72 in Web data grids, 89 column widths in data grids, 70 Consolidate All option, 113 Consolidate All with Data option, 112 Consolidate option, 112 consolidation canceling, 114 effects on process management, 269 entering percentages, 110 options, 112 procedure, 113 process overview, 105 viewing progress, 114 viewing statuses on the Web, 91 Consolidation (CN) status, 74 consolidation method calculations, 135 selecting, 133 consolidation statuses, 74 contribution values, 111 copying data, 63 copying line item detail, 65 currency rates, 109 Custom dimension, 21 custom documents, 44
D
data calculating, 110
Index 323
clearing, 66 clearing from grids, 89 copying, 63 displaying on the Web, 84 editing, 72 editing on the Web, 88 entering, 72 entering on the Web, 88 extracting, 61 filling blocks, 89 loading, 56 translating, 111 data file column order, 52 creating, 51 grouping by dimension, 53 line item detail, 52 script example, 53 view, 52 Data Forms adding members, 127 calculating data, 126 changing point of view, 126 editing cell text in, 123 entering cell text in, 122 entering data in, 119 exporting to Excel, 129 importing to Excel, 129 linked forms, 125 opening, 118 suppressing data, 127 toolbar, 118 using, 117 viewing instructions, 119 viewing intercompany transactions, 129 data forms printing, 128 data grids attaching documents, 94 saving settings on the Web, 85 setting rows and columns on the Web, 83 viewing intercompany transactions, 103 data grids: viewing FDM detail, 103 data history, 76 data load methods, 53 data view for process control, 249 delimiter characters, 21
description requirements, 21 descriptions adding cell text, 77 Desktop overview, 33 showing and hiding components, 33 dimensions overview, 19 searching for on the Desktop, 36 searching for on the Web, 40 Direct Percent Ownership (DOWN) account, 136 documents accessing related content, 44 adding to favorites, 49 copying links, 43 creating folders for, 41 custom documents, 44 setting up links to, 42 showing private documents, 42 Documents menu options, 40
E
elimination detail, 108 Entity dimension, 20 Entity Transaction Detail Report, 99 EPU (equity pickup), 139 equity pickup calculating, 145 calculation process, 146 cascading ownership, 141 cross-ownership, 143 description, 139 direct ownership, 140 direct ownership with translation, 140 examples, 140 managing, 143 printing reports, 146 error log, 49 Explore Data editing data, 72 entering data, 72 locking data, 79 opening a settings file, 71 reports, 80 running allocations, 79 setting default column widths, 70 starting, 69
324 Index
unlocking data, 79 Explore Data settings accessing, 71 saving, 71 selecting, 70 extracting data, 61
F
favorites adding, 49 managing, 48 removing, 49 FDM: accessing from data grids, 103 File Contains Ownership Data load option, 55 Fill option for data grids, 89 Fill option in Manage Ownership, 133 Financial Management architecture, 18 Desktop, 33 dimensions, 19 help, 32 starting from Windows Desktop, 27 starting on the Web, 28
manually matching, 180 match code, 184 matching status, 183 posting, 185 receiving alerts, 276 sample workflow, 161 security roles for, 160 sending alerts, 272 unmatching, 185 unposting, 187 viewing, 170 invalid characters in labels and descriptions, 21
J
journal files (JLF) label requirements for, 21 journal grid collapsing columns, 225 copying and pasting cells, 226 expanding columns, 225 journal groups creating, 218 removing, 219 journal reports running, 236 selecting columns for, 236 sorting columns, 237 journal templates creating recurring, 203 creating standard, 201 deleting, 208 editing, 207 process bar, 201 journals approving, 228 closing periods, 209 creating, 212 creating autoreversing, 214 creating journal groups, 218 deleting, 241 editing, 222 managing journal groups, 218 opening periods, 209 posting, 231 process bar, 211 rejecting approved journals, 230 rejecting submitted journals, 229
Index 325
G
grids in journals, 225 setting default column widths, 70
H
help in Financial Management, 32
I
Intercompany dimension, 20 Intercompany Reports print override options, 156 intercompany transactions auto-match template, 179 auto-matching, 179 copying, 66 creating, 167 deleting, 188 editing, 174 extracting, 166 load files, 162 loading, 165
removing journal groups, 219 reviewing, 233 security roles, 200 sorting in Process Journals, 220 sorting in Set Up Journals, 206 sorting report columns, 237 status, 218 submitting, 226 unposting, 232 unsubmitting, 227 using recurring templates, 216 validating, 234 viewing lists of, 219
Merge data option, 54 metadata displaying in data grids, 70 displaying on the Web, 84 Method account, 134
N
navigation frame on Desktop, 33 NoData status, 74
O
OK status, 74 operator keys for entering data, 73 Org by Period option, 36 override options for Intercompany reports, 156 ownership management Calculate Ownership option, 136 calculating values for, 135 changing point of view, 132 entering values for, 133 Fill option, 133 setting display options, 132 system accounts, 133
L
label requirements, 21 limitations for characters, 21 line item detail adding, 78 adding on the Web, 95 viewing in Windows, 78 viewing on the Web, 96 linked Data Forms, 125 loading data procedure, 56 viewing load progress, 59 Locked status, 74 locking data in Explore Data, 79 data on the Web, 97 process units, 267 logging on Financial Management Desktop, 27 from the Web, 28
P
percent consolidation calculation, 136 entering percentages, 110 Percent Consolidation (PCON) account, 134 Percent Control (PCTRL) account, 134 percent control calculation, 135 Percent Ownership (POWN) account, 134 percent ownership calculation, 136 Period dimension, 19 periods closing, 209 managing for journals, 209 opening, 209 point of view changing in Data Forms, 126 in Web Ownership Management, 132 Org by Period option, 36 searching for dimensions, 36 selecting members on the Desktop, 34 selecting members on the Web, 37 setting on the Web, 37
M
Manage Ownership Calculate Ownership option, 136 changing point of view, 132 entering information, 133 overview, 131 selecting multiple entities, 133 setting display options, 132 member selection on the Desktop, 35 on the Web, 37
326 Index
using check boxes in, 34 viewing active entities only, 36, 39 Posted journal status, 218 posting journals, 231 preferences, setting user, 29 printing reports, 156 process control attaching documents, 260 calculating data from, 260 calculation status summary, 255 consolidating data from, 261 data view, 249 options, 250 Pass/Fail status, 256 receiving alerts, 278 review level summary, 255 sending alerts, 276 toolbar, 255 translating data from, 260 validation detail, 257 viewing calculation status, 258 viewing journal status, 258 viewing rate data, 259 Process Control module, 247 process history, viewing, 267 Process Journals displaying columns, 220 starting, 211 process levels description, 245 displaying on the Web, 84 viewing on the Web, 92 process management approving, 263 enabling, 243 levels, 245 locking and unlocking data, 267 overview, 243 promoting, 261 publishing, 266 rejecting, 264 security roles for, 244 signing off on, 265 starting, 246 submitting, 262 validation, 268 viewing history, 267
process unit sign-off, 265 promoting process units, 261 proportion detail, 108 publishing process units, 266
R
rate data from process control, 259 recurring journal templates, 216 Rejected journal status, 218 rejecting approved journals, 230 process units, 264 submitted journals, 229 Replace by Security load option, 55 Replace data load option, 54 report style sheets, 153 reports adding descriptions for, 154 applying style sheets, 153 deleting, 156 Explore Data reports, 80 formatting, 151 Journal reports, 236 opening, 149 printing, 156 saving, 154 using BI Publisher templates, 152 viewing, 150 viewing intercompany transactions, 155 requirements for user-defined elements, 21
S
scale value, 84 Scenario dimension, 19 security roles for journals, 200 for process management, 244 for running allocations, 79 Setup Journals displaying columns, 205 starting from the Desktop, 200 Shared Services taskflows deleting permissions, 294 editing permissions, 293 viewing participant details, 297 showing and hiding Desktop components, 33
Index 327
signing off on process units, 265 SiteMinder security, 28 standard journal templates, 201 status Active, 36 calculation, 74 Chart Logic (CH), 74 Consolidation (CN), 74 Locked, 74 NoData, 74 OK status, 74 viewing in Explore Data, 74 viewing on the Web, 91 style sheets for reports, 153 retrieving, 153 Submitted journal status, 218 submitting journals, 226 process units, 262 summary-level time periods in Explore Data, 72 on the Web, 88 suppressing data in Data Forms, 127 system messages, 49
templates creating recurring journal templates, 203 creating standard journal, 201 deleting journal templates, 208 editing journal templates, 207 using recurring journal templates, 216 viewing lists of, 205 toolbar on Desktop, 33 transactions viewing consolidation, 99 viewing intercompany, 103 translating data, 111 translation entering currency rates, 109 process, 107 running logic, 111 Translation (TR) status, 74
U
unbalanced journals, 201 unlocking data in Explore Data, 79 data on the Web, 98 process units, 267 unsubmitting journals, 227 user preferences, 29 user-defined element requirements, 21
T
task automation overview, 279 prerequisites, 280 task lists on Web creating, 46 deleting, 48 editing, 47 taskflows adding links, 289 copying, 291 creating, 281 creating stages, 281 deleting, 291 editing, 290 managing, 280 parameters for Financial Management, 284 running manually, 291 stopping, 296 viewing, 290 viewing status, 294
328 Index
V
validation for journals, 234 for process management, 268 Value dimension, 20 View dimension, 21
W
Working journal status, 218
Y
Year dimension, 19
Z
zero values in Data Forms, 127 in data grids, 84