D81987 - Oracle Hyperion Planning 11.1.2 Create & Manage Applications

(1)

Oracle Hyperion Planning 11.1.2: Create & Manage Applications

Student Guide - Volume I

D63792GC31 Edition 3.1 May 2013 D81987

Oracle Internal & Or

(2)

This document contains proprietary information and is protected by copyright and other intellectual property laws. You may copy and print this document solely for your own use in an Oracle training course. The document may not be modified or altered in any way. Except where your use constitutes "fair use" under copyright law, you may not use, share, download, upload, copy, print, display, perform, reproduce, publish, license, post, transmit, or distribute this document in whole or in part without the express authorization of Oracle.

The information contained in this document is subject to change without notice. If you find any problems in the document, please report them in writing to: Oracle University, 500 Oracle Parkway, Redwood Shores, California 94065 USA. This document is not warranted to be error-free.

Restricted Rights Notice

If this documentation is delivered to the United States Government or anyone using the documentation on behalf of the United States Government, the following notice is applicable:

U.S. GOVERNMENT RIGHTS

The U.S. Government’s rights to use, modify, reproduce, release, perform, display, or disclose these training materials are restricted by the terms of the applicable Oracle license agreement and/or the applicable U.S. Government contract.

Trademark Notice

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Authors Lea Jensen Sandy Krameisen Theresa Songco Technical Contributors and Reviewers Eleanor Salerno Art Hetherington Bernhard Kinkel Faye Chan Ron Reiley Sergiy Pecherskyy Vicki Hardiman Emilya Altman Sasha Ishenko Krishnan Narasimha Charitra Agrawal Shankar Viswanathan Graphic Designer Seema Bopaiah Editors Rashmi Rajagopal Smita Kommini Publishers Pavithran Adka Srividya Rameshkumar

Oracle Internal & Or

(3)

iii

Oracle Internal & Or

(4)

iv Step 7: Creating and Enhancing Forms 1-37

Step 8: Entering, Annotating, and Analyzing Data 1-38 Step 9: Managing Business Rules 1-39

Step 10: Setting Up and Managing the Approval Process 1-40 Step 11: Creating and Managing Task Lists 1-41

Training Environment 1-42 Quiz 1-43

Summary 1-47

Practice 1-1 Through 1-4 1-48 2 Navigating EPM Workspace

Objectives 2-2

EPM Workspace: Overview 2-3 Launching EPM Workspace 2-5 EPM Workspace User Interface 2-6 Setting General Preferences 2-7 EPM Workspace Navigate Menu 2-9 Opening Applications 2-11

Navigating in Planning 2-12 Quiz 2-16

Summary 2-19

Practice 2-1 Through 2-3 2-20

3 Introduction to Applications and Dimensions Objectives 3-2

Planning Application: Overview 3-3 Application Creation Process 3-4

Data and Metadata Storage: Overview 3-5 Application Framework 3-8 Calendar Structure 3-9 Currency Specifications 3-11 Plan Types 3-12 Planning Dimensions 3-14 Required Dimensions 3-15 User-Defined Dimensions 3-17

Dimension Hierarchies: Genealogy 3-18

Dimension Hierarchies: Generations and Levels 3-19 Drilldown Process 3-20

Dimensions and Data 3-21 Dimensions and Metadata 3-22 Data Block Creation Process 3-23

Oracle Internal & Or

(5)

v Determining the Number of Data Blocks 3-24 Creating Data Blocks and Retrieving Data 3-26 Aggregation, Storage, and Calculation Options 3-28 Aggregation Options 3-29

Data Storage Options 3-30 Calculation Options 3-32 Quiz 3-34

Summary 3-37 Practice 3-1 3-38

4 Creating Applications in Planning Administration Objectives 4-2

Planning Administration: Overview 4-3 Application Creation Process 4-4

Creating Applications with Planning Application Administration 4-5 Selecting Application Information 4-7

Setting Up the Calendar 4-8 Setting Up Currencies 4-10

Selecting and Naming Plan Types 4-11 Reviewing Application Information 4-12 Modifying Application Registration 4-13

Managing Applications and Data Sources 4-15 Managing Data Sources 4-17

Managing Essbase Databases 4-19 Refreshing Essbase Databases 4-21 Quiz 4-23

Summary 4-26

Practice 4-1 Through 4-2 4-27 5 Managing Dimensions

Objectives 5-2

Building Dimension Hierarchies 5-3 Setting Up Dimension Hierarchies 5-4 Modifying Member Properties 5-7 Property Value Inheritance 5-8 Alternate Hierarchies 5-9

Managing Member Hierarchies 5-10 Deleting Members 5-12

Finding Members 5-13 Sorting Members 5-14 Quiz 5-16

Oracle Internal & Or

(6)

vi Summary 5-19

6 Setting Up the Alias, Currency, Year, and Period Dimensions Objectives 6-2

Creating Aliases 6-3 Adding Currencies 6-5

Customizing Time Periods 6-7 Period and Year Dimensions 6-9 Setting Up DTS Members 6-10 Quiz 6-12

Summary 6-15

Practice 6-1 Through 6-5 6-16 7 Setting Up Scenarios and Versions

Objectives 7-2

Scenarios and Versions 7-3 Creating Scenarios 7-4 Creating Versions 7-7 Quiz 7-9 Summary 7-11 Practice 7-1 Through 7-2 7-12 8 Loading Metadata Objectives 8-2

Metadata Load Options 8-3

Loading Metadata with the Outline Load Utility 8-4 Creating Metadata Load Files 8-5

Common Member Properties 8-6

Testing and Loading Metadata Files 8-8 ERP Integrator Load Process 8-11 Lifecycle Management 8-12

Migrating Applications and Artifacts 8-14 Migration Guidelines 8-15

Migrating Applications and Artifacts to a File System 8-17 Migrating Artifacts from a File System to an Application 8-18 Displaying Migration Status Reports 8-20

Quiz 8-21 Summary 8-24

Oracle Internal & Or

(7)

vii

9 Setting Up the Entity and Account Dimensions Objectives 9-2

Entities: Overview 9-3

Entity Members and Plan Types 9-4 Currency Values for Entities 9-6 Adding Entities 9-7

Deleting Entities 9-8 Accounts: Overview 9-9 Account Types 9-10

Time Balance Properties 9-11 Saved Assumptions 9-13

Data Types and Exchange Rate Types 9-14 Adding Accounts 9-15

Aggregating Accounts 9-16 Quiz 9-17

Summary 9-21 Practice 9-1 9-22

10 Creating User-Defined Elements Objectives 10-2

Creating Member Formulas 10-3 User-Defined Dimensions 10-5 Attribute Dimensions 10-6 Creating Attributes 10-7

Assigning Attribute Values 10-9 Adding User-Defined Attributes 10-10 Smart Lists: Overview 10-12

Creating Smart Lists 10-13

Associating Smart Lists with Members 10-15 Forms and Smart Lists 10-16

Practice 10-1 Through 10-11 10-22 11 Setting Up Exchange Rates

Objectives 11-2

Currencies and Exchange Rates 11-3 Creating Exchange Rate Tables 11-5 Entering Exchange Rates 11-6

Calculating Implied Rates Through Triangulation 11-8

Oracle Internal & Or

(8)

viii

Exchange Rates and the HSP_Rates Dimension 11-10 Generating Currency Conversion Calculation Scripts 11-11 Quiz 11-13

Summary 11-16

Practice 11-1 Through 11-4 11-17 12 Loading and Calculating Data

Objectives 12-2

Data Load Options 12-3

Loading Data Values with Administration Services 12-5 Requirements for Data Load Files 12-6

Multicurrency Application Data 12-7

Managing Data with the Outline Load Utility 12-8 Importing Data From Flat Files or RDMS 12-9 Exporting Application Data 12-12

ERP Integrator Data Load Process 12-13

ERP Integrator: Drilling Through and Writing Back Budget Data 12-14 Oracle Data Integrator Data Loads with ETL Tools 12-15

Data Calculations 12-16

Calculation Scripts in Essbase 12-18 Business Rules 12-19

Practice 12-1 Through 12-2 12-24 13 Setting Up Planning Security

Objectives 13-2

Planning Security: Overview 13-3 Planning Security Levels 13-4 User Authentication 13-6

Planning Roles in Shared Services 13-7 Data and Artifact Security 13-8

User and Group Provisioning in Shared Services 13-9 Provisioning Users and Groups 13-12

Generating Provisioning Reports 13-14 Assigning Access Permissions 13-15 Access Options 13-17

Inheritance Options 13-19

Precedence and Inheritance of Access Permissions 13-20 Reporting on Access Permissions 13-22

Exporting and Importing Access Permissions 13-24

Oracle Internal & Or

(9)

ix

Exporting Access Permissions with ExportSecurity 13-27 Importing Access Permissions with ImportSecurity 13-29 Creating Security Filters 13-31

Quiz 13-33 Summary 13-37 Practice 13-1 Through 13-5 13-38 14 Creating Forms Objectives 14-2 Forms: Overview 14-3 Form Components 14-4 Creating Simple Forms 14-6 Setting Up the Form Layout 14-8 Setting Up Properties 14-10

Form Display and Printing Options 14-13

Managing Substitution and User Variables 14-15 Selecting Members 14-17

Setting Up Other Options 14-20 Assigning Business Rules 14-22 Creating Composite Forms 14-24 Setting Up Composite Forms 14-26 Setting POV and Page Properties 14-28 Setting Up Master Composite Forms 14-30 Reviewing Form Design 14-32

Exporting and Importing Forms 14-33 Quiz 14-35

Summary 14-39

Practice 14-1 Through 14-8 14-40 15 Enhancing Forms

Objectives 15-2

Creating Rolling Forecasts 15-3

Modifying Rolling Forecast Variables 15-5 Creating Menus 15-7

Creating Formula Rows and Columns 15-10 Building Validation Rules 15-12

Processing Cells for Data Validation 15-15 Specifying Advanced Settings 15-17 Setting Application Defaults 15-19 Setting Up User Preferences 15-20 Setting Individual Display Options 15-22

Oracle Internal & Or

(10)

x Setting Printing Options 15-24

Performing Grid Diagnostics 15-25 Quiz 15-26

Summary 15-29

Practice 15-1 Through 15-6 15-30 16 Entering Data in Planning

Objectives 16-2

Navigating Forms 16-3

Viewing Form Instructions 16-5 Data Entry Menus 16-6

Cell Detail Cues 16-7 Navigation Keys 16-9

Showing and Hiding Children 16-10 Viewing Member Detail 16-11 Navigating Forms with Menus 16-12 Submitting Data in Forms 16-13 Copying and Pasting Data 16-15 Saving and Refreshing Data 16-17 Viewing Member Formulas 16-18 Viewing Consolidation Operators 16-19 Selecting Dates 16-21

Entering Data with Smart Lists 16-22 Filtering Data 16-23

Sorting Data 16-25 Spreading Data 16-26 Time Balance Options 16-28

Spreading Data by Using Grid Spread 16-30 Spreading Data by Using Mass Allocate 16-32 Adjusting Plan Data 16-34

Performing Flexible Data Entry 16-35 Quiz 16-36

Summary 16-40

Practice 16-1 Through 16-6 16-41 17 Annotating and Analyzing Data

Objectives 17-2

Adding Annotations to Plan Data 17-3 Adding Comments 17-4

Adding Supporting Detail 17-5 Attaching Documents to Cells 17-7

Oracle Internal & Or

(11)

xi Adding Account Annotations 17-9 Clearing Cell Details 17-10 Working with Ad Hoc Grids 17-12 Setting Ad Hoc Grid Options 17-16 Quiz 17-18

Summary 17-21

Practice 17-1 Through 17-5 17-22 18 Managing Business Rules

Objectives 18-2

Business Rules: Overview 18-3 Calculation Manager: Overview 18-4 Business Rule Creation Process 18-5 Determining Calculation Requirements 18-6 Launching Calculation Manager 18-7

Rule Components 18-8 Formula Components 18-9 Variables 18-10

Script, Condition, and Loop Components 18-13 Templates: Overview 18-15

Creating Business Rules from Templates 18-17 Setting Up the Copy Data Template 18-19

Setting Up the Amount–Unit–Rate Template 18-21 Setting Up the Allocate–Level to Level Template 18-22 Setting Up the Allocate Simple Template 18-24

Setting Up the Aggregation Template 18-27 SET Commands Template 18-29

Export-Import Data Template 18-30

Creating Custom-Defined Templates 18-31 Creating Business Rules and Rulesets 18-33 Validating and Deploying Rules 18-35

Assigning Business Rule Security 18-37

Launching Business Rules from Planning Forms 18-39

Launching Business Rules from the Planning Tools Menu 18-40 Quiz 18-41

Summary 18-45

Practice 18-1 Through 18-8 18-46 19 Setting Up the Approval Process

Objectives 19-2

Approvals: Overview 19-3

Oracle Internal & Or

(12)

xii Creating Planning Unit Hierarchies 19-5

Setting Up Basic Characteristics for Planning Unit Hierarchies 19-6 Selecting Planning Unit Hierarchy Members 19-8

Assigning Planning Unit Owners and Reviewers 19-11 Assigning Scenario and Version Combinations 19-13 Synchronizing Planning Unit Hierarchies 19-15

Exporting and Importing Planning Unit Hierarchies 19-17 Updating the Promotional Path with Validation Rules 19-19 Quiz 19-22

Summary 19-26

Practice 19-1 Through 19-3 19-27 20 Managing the Approval Process

Objectives 20-2

Approvals Dashboard 20-3

Planning Unit Approval States 20-5 Reviewer Actions 20-7

Impact of Entity Hierarchy on the Review Process 20-10 Managing the Review Cycle 20-11

Starting the Review Cycle 20-12

Checking the Status of Planning Units 20-15 Viewing the Details of Planning Units 20-17

Viewing and Adding Planning Unit Annotations 20-18 Changing the Status of Planning Units 20-20

Setting Up Out of Office Assistant 20-22 Viewing and Resolving Validation Errors 20-24 Copying Data Between Versions 20-27

Copying Data 20-29 Quiz 20-31

Summary 20-35

Practice 20-1 Through 20-6 20-36 21 Creating Task Lists

Objectives 21-2

Task Lists: Overview 21-3 Navigating Task Lists 21-4 Task List Creation Process 21-6 Creating Task List Folders 21-7 Creating Task Lists 21-9

Adding Tasks to Task Lists 21-10 Setting Up Tasks 21-11

Oracle Internal & Or

(13)

xiii Setting Task Properties 21-13

Editing Task Lists 21-15

Assigning Access to Task Lists 21-16 Testing Task Lists 21-18

Printing Task List Reports 21-19 Quiz 21-21

Summary 21-24

A Creating Applications in Performance Management Architect Objectives A-2

Application Creation Process A-3 Application Criteria A-4

Creating Applications with Application Creation Wizard A-5 Selecting Dimensions A-7

Configuring Application Settings A-9 Working in Shared Library A-10 Managing Dimensions A-12

Adding Dimensions to Shared Library A-13 Shared and Local Dimensions A-15

Creating Members in Dimension Library A-16 Modifying Member Properties A-18

Property Value Inheritance A-20 Alternate Hierarchies A-21

Inserting Members Based on Relationships A-22 Managing Members A-23

Finding Members A-25

Organizing Shared Library A-26 Creating Dimension Filters A-28

Sorting Dimensions in Shared Library A-29 Creating Associations Between Dimensions A-30 Working with Grid Editor A-32

Selecting Members and Properties in Grid Editor Wizard A-33 Saving Dimensions A-35

Adding Dimensions from Shared Library A-36

Synchronizing Local Dimensions with Shared Library A-38 Changing Local Dimensions to Shared Dimensions A-40 Excluding and Showing Members A-42

Overriding Property Settings A-43 Deployment Process A-45

Preparing for Application Deployment A-46

Oracle Internal & Or

(14)

xiv Adjusting Performance Settings A-47

Setting Up Data Type Evaluation Order A-49 Activating Dimension Associations A-51 Validating Applications A-52

Deploying Applications to a Planning Server A-54 Essbase Databases A-56

Planning Outlines A-57

Essbase Directory Structure A-58 Redeploying Applications A-59 Metadata Load Options A-61

Loading Metadata in Performance Management Architect A-62 Formatting Metadata Load Files A-63

Setting Up Dimensions A-65

Setting Up Dimension Associations A-67 Setting Up Parent-Child Relationships A-69 Managing Aliases A-71

Creating Import Profiles A-72 Mapping Dimensions A-74

Mapping Dimension Properties A-77 Running Import Profiles A-79

Viewing Job Statuses A-81 Viewing Import Errors A-82

Staging Data with Interface Tables A-83 Creating Interface Tables A-84

Loading Data by Using Interface Tables A-85 Summary A-87

B Sharing Data with Data Synchronization Objectives B-2

Data Synchronizer B-3

Synchronization Source Types B-5

Synchronizing Multicurrency Planning Applications B-7 Creating Mapping Tables B-9

Creating Data Synchronizations B-11 Specifying Source Types B-12 Specifying a Destination B-13 Mapping Dimensions B-14 Filtering Dimensions B-15 Applying Filter Criteria B-17 Assigning Default Members B-18 Inserting Mapping Tables B-19

Oracle Internal & Or

(15)

xv Saving Synchronizations B-20

Editing Synchronizations and Mappings B-21 Duplicating Synchronizations and Mappings B-22 Deleting Synchronizations and Mappings B-23 Validating Data Synchronizations B-24

Executing Data Synchronizations B-26 Viewing Data Flows B-28

Summary B-29

C Entering Data with Smart View Objectives C-2

Smart View: Overview C-3 Smart View Architecture C-4 Connection Types C-5

Setting Up a Shared Connection C-6 Creating Private Connections C-8 Connecting to Data Sources C-10 Setting Smart View Options C-11 Navigating Forms in Smart View C-13 Opening Forms in Smart View C-14 Data Entry in Smart View C-15 Form Formulas in Smart View C-17 Data Calculations in Smart View C-19

Performing Ad Hoc Analysis in Smart View C-20 Navigating Ad Hoc Grids C-21

Zooming In and Out on Dimension Members C-23 Pivoting Dimensions C-24

Keeping and Removing Dimension Members C-25 Saving Ad Hoc Grids C-26

Cascading Data Slices C-27 Adding Supporting Details C-28

Managing Approvals in Smart View C-30 Copying Versions in Smart View C-32 Managing Task Lists in Smart View C-34 Summary C-36

Oracle Internal & Or

(16)

Oracle Internal & Or

(17)

I t d

ti

t Pl

i

Introduction to Planning

Oracle Internal & Or

(18)

Course Objectives

After completing the course, you should be able to:

• Create and deploy Planning applications

• Manage metadata and data

• Set up security for users groups and members

• Set up security for users, groups, and members

• Create and customize forms, menus, and task lists

• Migrate application artifacts

• Verify application setup

• Set up and test business rules

p

• Set up and manage the approval process

Oracle Hyperion Planning 11.1.2: Create & Manage Applications 1 - 2

Oracle Internal & Or

(19)

Course Agenda: Day 1

Lesson 1: Introduction to Planning

Lesson 2: Navigating EPM Workspace

Lesson 3: Introduction to Applications and Dimensions

Lesson 4: Creating Applications in Planning Administration

Lesson 5: Managing Dimensions

Oracle Internal & Or

(20)

Course Agenda: Day 2

Lesson 6: Setting Up the Alias, Currency, Year, and Period

Dimensions

Lesson 7: Setting Up Scenarios and Versions

Lesson 8: Loading Metadata

Lesson 9: Setting Up the Entity and Account Dimensions

Lesson 10: Creating User-Defined Elements

Oracle Internal & Or

(21)

Course Agenda: Day 3

Lesson 11: Setting Up Exchange Rates

Lesson 12: Loading and Calculating Data

Lesson 13: Setting Up Planning Security

Lesson 14: Creating Forms

Oracle Internal & Or

(22)

Course Agenda: Day 4

Lesson 15: Enhancing Forms

Lesson 16: Entering Data in Planning

Lesson 17: Annotating and Analyzing Data

Lesson 18: Managing Business Rules

Oracle Internal & Or

(23)

Course Agenda: Day 5

Lesson 19: Setting Up the Approval Process

Lesson 20: Managing the Approval Process

Lesson 21: Creating Task Lists

Case Study

Appendix A: Creating Applications in Performance

Management Architect

Appendix B: Sharing Data with Data Synchronization

Appendix C: Entering Data with Smart View

Oracle Internal & Or

(24)

Objectives

After completing this lesson, you should be able to:

• Describe Planning and its components

• Identify the product components within the Planning

architecture

• Explain the Planning business process

• Discuss a typical Planning business scenario

Oracle Internal & Or

(25)

Oracle Hyperion Planning

• Streamlines data entry through web and Excel interfaces

• Provides a calculation engine to promote business

modeling with complex business rules and allocations

• Enables annotations at multiple levels to capture budget

Enables annotations at multiple levels to capture budget

details

• Accommodates potentially sophisticated budget review

processes

• Facilitates dynamic reporting by using Financial Reporting

Oracle Hyperion Planning (Planning) is a budgeting and planning solution that provides streamlined methods for entering data through web and Excel interfaces. Planning supports driver-based plans that are based on global assumptions, such as interest rates and headcount,

and promotes modeling with complex business rules and allocations. It enables users to annotate and justify data at multiple levels to capture budget details. It enables decision makers and

managers to collaborate with budget holders during potentially complex budget review processes, and provides the tools to create and publish dynamic financial reports by using Oracle Hyperion Financial Reporting (Financial Reporting).

Oracle Internal & Or

(26)

Planning Components

Planning Non-numeric data Application server Planning relational database Planning user Essbase databases Numeric data

The application server provides the environment for running Planning applications. Oracle

WebLogic Server is the application server provided with Planning. It facilitates user access to non-numeric data in the Planning relational database and to non-numeric data in Oracle Essbase

databases.

Planning requires a system database and a database for each deployed application. The Planning application database is used primarily to store the application’s definition. Planning data and metadata storage is covered in Lesson 3, “Introduction to Applications and Dimensions.”

Oracle Internal & Or

(27)

Additional Planning Modules

• Financial Reporting: Create highly formatted reports and

detailed budget books for offline approval and statutory

reporting purposes.

• Smart View: Complete Planning tasks within a familiar

p

g

Excel interface and integrate Planning data with Outlook.

The following modules extend the Planning solution to address specific organizational needs: • Financial Reporting: Create highly formatted reports and detailed budget books for offline

approval and statutory reporting purposes.

pp y p g p p

• Smart View: Complete Planning tasks within a familiar Excel interface and integrate

Planning data with Outlook.

Oracle Internal & Or

(28)

Additional Planning-Based Products

• Workforce Planning: Manage workforce, salary, and

compensation planning.

• Capital Asset Planning: Plan for new asset purchases

and existing asset actions.

g

• Public Sector Planning and Budgeting: Develop

budgets for public sector and higher-education

organizations.

• Project Financial Planning: Plan and allocate workforce

and asset resources to organization projects while

and asset resources to organization projects, while

monitoring financial performance.

The following products extend the Planning solution to address specific organizational needs: • Oracle Hyperion Workforce Planning, Fusion Edition: Manage workforce, salary, and

compensation planning.

p p g

• Oracle Hyperion Capital Asset Planning, Fusion Edition: Plan for new asset purchases

and existing asset actions.

• Oracle Hyperion Public Sector Budgeting and Planning, Fusion Edition: Develop

comprehensive budgets for public sector and higher-education operations.

• Oracle Project Financial Planning: Plan and allocate workforce and asset resources to

organization projects, while monitoring financial performance.

Oracle Internal & Or

(29)

Product Integration

• EPM System: Profitability and Cost Management, Oracle

Scorecard and Strategy Management, Strategic Finance,

Financial Management, and Financial Data Quality

Management

• ERP systems: Oracle E-Business Suite, Oracle

PeopleSoft Enterprise, and Oracle Fusion Applications

• Oracle Business Intelligence Suite, Enterprise Edition

• Data management applications: Oracle Data Integrator

and ERP Integrator

Planning can be integrated with the following products:

• Oracle’s Enterprise Performance Management System (EPM System) product suite, including Oracle Hyperion Profitability and Cost Management, Fusion Edition, Oracle

g yp y g , ,

Scorecard and Strategy Management, Oracle Hyperion Strategic Finance, Fusion Edition, Oracle Hyperion Financial Management, Fusion Edition, and Oracle Hyperion Financial Data Quality Management, Fusion Edition (FDM)

• Enterprise resource planning (ERP) systems, including Oracle E-Business Suite, Oracle PeopleSoft Enterprise, and Oracle Fusion Applications

• Oracle Business Intelligence Suite, Enterprise Edition

Data management applications including Oracle Data Integrator and Oracle Hyperion • Data management applications, including Oracle Data Integrator and Oracle Hyperion

Financial Data Quality Management ERP Integration Adapter for Oracle Applications, Fusion Edition (ERP Integrator; FDM module)

Oracle Internal & Or

(30)

Planning Architecture

Middle Tier Microsoft Office Integration Smart View EPM Workspace: Planning, EPMA, Reporting and Analysis Administration Services Console, Essbase Studio Client Tier Web Analysis Studio and Reporting Studio Clients Web Server

Application Server Services

Data Tier Middle Tier

External

Services Oracle Data Integrator/ ERP Integrator ERP Systems

Relational Databases Essbase Databases

Planning is a multitier application that combines the advantages of Essbase (a multidimensional database) and a relational database to optimize performance and maintenance.

The slide illustrates the client, middle, and data tiers as well as external services that integrate

, , g

with Planning.

Oracle Internal & Or

(31)

Client Tier

• EPM Workspace for accessing the Planning web interface,

Planning application administration, and Performance

Management Architect applications, and creating and

publishing reports

• Smart View for entering Planning data in Excel

• Administration Services Console and Essbase Studio for

modifying multidimensional outlines and calculation scripts

• Reporting Studio for developing and running financial

reports

Microsoft Office Integration Smart View EPM Workspace: Planning, Performance Management Architect, Reporting and Analysis Administration Services Console, Essbase Studio Client Tier Web Analysis Studio and Reporting Studio Clients

The client tier contains Oracle Enterprise Performance Management Workspace (EPM

Workspace), Oracle Hyperion Smart View for Office (Smart View), Oracle Essbase Administration Services Console (Administration Services Console), Oracle Essbase Studio (Essbase Studio),

Hyperion Web Analysis Studio, and Oracle Hyperion Financial Reporting Studio (Reporting Studio).

You access and manage Planning applications, Oracle Hyperion Enterprise Performance Management Architect (Performance Management Architect) applications, and reports in EPM Workspace.

On the client tier, Planning administrators and users enter data, perform approvals tasks, manage users and security launch business rules copy versions develop forms work with Financial users and security, launch business rules, copy versions, develop forms, work with Financial Reporting, and perform other administrative tasks, such as updating Essbase outlines.

Oracle Internal & Or

(32)

Middle Tier

• Application server for running applications

• Supported web servers for handling HTTP requests from

Planning

• Services for Performance Management Architect Essbase

Services for Performance Management Architect, Essbase

Studio, and Financial Reporting

Middle Tier

Web Server

Application Server Services

The middle tier consists of Oracle WebLogic Server (the application server) for running Planning applications, supported web servers for handling Hypertext Transfer Protocol (HTTP) requests from Planning, and the required services for Performance Management Architect, Essbase Studio,

and Financial Reporting.

The web server can be on a separate machine or on the same machine as the Planning

application server. The web server enables you to access Planning applications from a web client through a browser. The web server uses HTTP as the communications protocol.

Oracle Internal & Or

(33)

Data Tier

• Relational databases store data for Shared Services,

Performance Management Architect, Calculation Manager,

Reporting and Analysis, Administration Services, and

Planning.

• Essbase databases store security, Planning data and

metadata, and calculation scripts.

Data Tier

Relational Databases Essbase Databases

The data tier consists of the relational (non-numeric) and Essbase (numeric) databases. The following components require a relational database:

• Oracle Hyperion Shared Services

• Oracle Hyperion Performance Management Architect • Oracle Hyperion Calculation Manager

• Oracle Hyperion Reporting and Analysis • Oracle Essbase Administration Services • Oracle Hyperion Planning

Oracle Internal & Or

(34)

External Services

• Integration with Oracle and other systems

• Oracle Data Integrator and ERP Integrator for data and

metadata integration

• ERP systems integration for drill-back capabilities

ERP systems integration for drill back capabilities

ERP Systems

External Services

Oracle Data Integrator/ ERP Integrator

To load metadata and data from Oracle and other systems into Planning applications, you can work with several external services, including Oracle Data Integrator, ERP Integrator, and Outline Load Utility.

Oracle Internal & Or

(35)

Oracle Exalytics: Overview

Oracle Exalytics consists of hardware and software engineered

to work together.

The Oracle Exalytics In-Memory Machine is the industry’s first engineered in-memory analytics machine that delivers no-limit, extreme performance for Business Intelligence and Enterprise Performance Management applications.

The Oracle Exalytics In-Memory Machine hardware is a single server that is optimally configured for in-memory analytics for business intelligence workloads and includes powerful compute capacity, abundant memory, and fast networking options.

The Oracle Exalytics In-Memory Machine features an optimized Oracle BI Foundation Suite (Oracle BI Foundation) and Oracle TimesTen In-Memory Database for Exalytics. Business Intelligence Foundation takes advantage of large memory, processors, concurrency, storage, networking operating system kernel and system configuration of the Oracle Exalytics hardware networking, operating system, kernel, and system configuration of the Oracle Exalytics hardware. This optimization results in better query responsiveness, higher user scalability and markedly lower total cost of ownership (TCO) compared to stand-alone software. The TimesTen In-Memory Database for Exalytics is an optimized in-memory analytic database, with features exclusively available on Oracle Exalytics platform.

Oracle Internal & Or

(36)

Planning on Oracle Exalytics: Benefits

• Reduced planning, budgeting, and forecasting cycle times

• More complex planning models with finer grained detail

• More users in the planning process and improved

accuracy of plans and forecasts

• Optimized resource allocations and improved performance

• Focused finance resources on value added analysis

• Deployed quickly with prebuilt functionality

Planning running on Oracle Exalytics takes advantage of the following capabilities:

• Enterprise-wide planning, budgeting, and forecasting involving hundreds to thousands of users across an organization with speed-of-thought performance for complex calculations,

g p g p p ,

standard and ad hoc reporting and analysis

• Detailed planning, budgeting, and forecasting across thousands of cost centers, millions of customers or products, and multiple scenarios

• Fast time to benefit and reduced TCO by supporting enterprise-scale planning and budgeting and forecasting with a reduced number of server platforms

Oracle Internal & Or

(37)

Planning on Oracle Exalytics: Optimized Engine

• Faster parallel load

• Faster parallel export

• Faster calculations

• Faster cube restructuring

• Faster MDX queries

• More concurrent users

Planning on Oracle Exalytics benefits from a number of optimizations for in-memory operations including improvements to overall storage layer performance, enhancements to parallel

operations, enhanced MDX syntax and a high performance MDX query engine. Essbase on

Exalytics provides up to 16X faster query execution as well as up to 6X reduction in write-back and calculation operations, including batch processes.

Essbase on Oracle Exalytics accomplishes the tasks in the slide as follows: • Indexes and data blocks are stored in memory.

• There is better cache coherency. • Index navigation is improved. • Locking is improved.

• There is better workload partitioning and distribution across threads.

Oracle Internal & Or

(38)

Planning Business Process

1

2

3

Enter data Adjust data Calculate data

Annotate data Review and

approve data Run and publish

financial reports

4

5

6

The Planning business process includes the following steps: 1. Enter data.

2 Adjust data

2. Adjust data. 3. Calculate data. 4. Annotate data.

5. Review and approve data.

6. Run and publish financial reports.

Oracle Internal & Or

(39)

Step 1: Entering Data

Enter data by:

• Adding it manually through forms or Smart View grids

• Loading it through Essbase, Outline Load Utility, FDM, or

ERP Integrator

Enter data

1

You enter data directly into Planning through forms or Smart View grids or you can load data through Essbase, Outline Load Utility, FDM, or ERP Integrator.

Oracle Internal & Or

(40)

Step 2: Adjusting Data

Adjust data:

• Manually in Planning forms

• By simultaneously spreading data values and percentages

across multiple dimensions

2

Adjust data

You adjust Planning data in forms manually or through the provided adjustment tools, Mass Allocate and Grid Spread, which enable users to simultaneously spread data values across multiple dimensions.

Oracle Internal & Or

(41)

Step 3: Calculating Data

Calculate data by:

• Applying provided business rules

• Creating new business rules

Calculate data

3

You calculate Planning data through the provided business rules or through custom business rules in Calculation Manager.

Oracle Internal & Or

(42)

Step 4: Annotating Data

Annotate data by adding commentary at the following levels:

• Account

• Cell

• Planning unit

• Supporting details

Annotate data

4

Planning annotations enable Planning users to justify and document details for data values. Users enter annotations at the following levels in Planning: account, cell, planning unit, and supporting details.

Oracle Internal & Or

(43)

Step 5: Reviewing and Approving Data

Review and approve data by:

• Setting up the approval process (Approvals)

• Approving or rejecting budgets for your organizational

structure

• Building validation rules in forms to identify exceptions

before the approval process begins

Review and approve data

5

You review and approve data in Planning by setting up the approval process based on your organizational structure. You can include validation rules in forms to identify exceptions before the approval process begins.

Oracle Internal & Or

(44)

Step 6: Running and Publishing

Financial Reports

Run and publish reports by:

• Creating and running dynamic or static reports in Financial

Reporting

• Producing reports in HTML and PDF

Producing reports in HTML and PDF

Run and publish financial reports

6

After entering, calculating, adjusting, and reviewing Planning data, you use Financial Reporting to depict the results in static or dynamic reports in HTML or PDF.

Oracle Internal & Or

(45)

Planning Business Scenario

Create application shell based on a design framework

Manage and load dimensions Create user-defined elements Set up exchange rates

1 2 3 4

Load and calculate data Set up Planning security

Create and enhance forms

5 6

7

Enter, annotate, and analyze data

Manage business rules Set up and manage approval process

Create and manage task lists

8 9 10 11

ABC Corporation manages its planning and budgeting processes with highly manual efforts and minimal systems integration. These time-consuming processes do not meet the current

expectations and requirements of the management team. The company recently purchased

Oracle Enterprise Performance Management System and is in the process of implementing the Oracle Hyperion Planning Suite and supporting tools. Oracle Hyperion Planning will enable the company to validate forecasts, reduce budgeting and implementation time, and combine financial and operational planning in one system.

As the application administrator, you are tasked with rolling out the Finbud Planning application to the organization’s 350 users. Together with an implementation consultant and an internal

implementation team, you identify the necessary requirements for the application and begin the application creation process.

• Mickey Smith, application administrator, is tasked with building the application based on the requirements specified by the implementation team. As Mickey builds the application, he is required to test and make sure each functionality is working.

• Randy Jackson and Thomas Redford, budget administrators, are responsible for reviewing and approving the budget.

• Christian Carlucci Mary Woo and Kate Reilly planners are responsible for entering budget • Christian Carlucci, Mary Woo, and Kate Reilly, planners, are responsible for entering budget

data and creating financial reports.

Oracle Internal & Or

(46)

Budget Requirements for the Finbud Application

ABC Corporation’s budget requirements include the creation of the following plans: • Actual, Fiscal Year 2012 to 2013

• Budget Fiscal Year 2013 to 2014 • Budget, Fiscal Year 2013 to 2014 • Forecast, Fiscal Year 2013 to 2014

The calendar and fiscal years start in the month of January. Data will be loaded from external systems. The load files have been formatted by your implementation consultant.

Implementation Process

The classroom practices include tasks you need to perform to complete the development and implementation of the organization’s Finbud application.

• Create the application shell based on the budget requirements.

• Load and manage application metadata, including dimensions, alias tables, member

formulas, user-defined dimensions, attribute dimensions, user-defined attributes, and smart lists.

• Refresh the Essbase databaseRefresh the Essbase database. • Set up exchange rates.

• Load and calculate application data. • Import user and group security.

• Create and import forms, associated business rules, menus, formulas and rows, and validation rules.

• Assign dimension and object securityAssign dimension and object security.

• Set application, system, and user preferences. • Test data entry and ad hoc analysis features. • Set up and test the approval process.

• Create and test task lists.

In addition to Finbud, the implementation team opted to create a smaller application, BudPlan, using Planning application administration The BudPlan application will use the same criteria as using Planning application administration. The BudPlan application will use the same criteria as Finbud, except for the following:

• The application will use single currency.

• The business entities will cover only North America.

Then, you will load forms and user-defined elements into BudPlan.

Oracle Internal & Or

(47)

Step 1: Creating the Application Shell

Based On a Design Framework

Create the application based on the following criteria:

• Application name

• Number and names of plan types

• Calendar structure

• Whether the application is a multicurrency application

• Default currency

Create application shell based on a design framework

1

After discussing Lessons 1 through 3, you begin the implementation process in Lesson 4, “Creating Applications in Planning Administration”.

Consulting partners (such as implementation consultants) and the Planning administrator design

g p ( p ) g g

applications and create an application framework. In Lesson 4, you begin the administration process by creating the application shell, setting the application framework based on your organization’s requirements.

Oracle Internal & Or

(48)

Step 2: Managing and Loading Metadata

Set up and load the following metadata:

• Alias tables

• Currency dimension

• Year dimension

• Period dimension

• Scenario dimension

• Version dimension

• Entity dimension

y

• Account dimension

Manage and load dimensions

2

After the application shell is created and deployed, you set up and load metadata to your application in Lessons 5 through 9.

Oracle Internal & Or

(49)

Step 3: Creating User-Defined Elements

Create the following user-defined elements:

• Member formulas

• User-defined dimensions

• Attributes

• User-defined attributes

• Smart lists

Create user-defined elements

3

After defining your base metadata, you create user-defined elements to your application in Lesson 10, “Creating User-Defined Elements”.

Oracle Internal & Or

(50)

Step 4: Setting Up Exchange Rates

Set up the following:

• Exchange rates

• Currency conversion calculation scripts

Set up exchange rates

4

In Lesson 11, “Setting Up Exchange Rates”, you set up exchange rates and generate currency conversion calculation scripts.

Oracle Internal & Or

(51)

Step 5: Loading and Calculating Data

Load and calculate data by using one of the following tools:

• Essbase Administration Services Console

• Outline Load Utility

• Financial Data Quality Management and ERP Integrator

• Oracle Data Integrator

Load and calculate data

5

In Lesson 12, “Loading and Calculating Data”, you learn about the tools used to load and calculate Planning data.

Oracle Internal & Or

(52)

Step 6: Setting Up Planning Security

Set up security based on the following levels:

• Planning Roles in Shared Services

• Data Security

• Access Permissions

• Security Filters

Set up Planning security

6

You set up role-based, data, and object-based security in Lesson 13, “Planning Security”.

Oracle Internal & Or

(53)

Step 7: Creating and Enhancing Forms

Planning forms:

• Simple forms

• Composite forms

Create and enhance forms

7

In Lessons 14 and 15, you create and enhance simple forms and composite forms. You also learn how to export and import forms into your application.

Oracle Internal & Or

(54)

Step 8: Entering, Annotating, and Analyzing Data

Perform the following data entry tasks:

• Navigate and submit data in forms.

• Enter data with smart lists.

• Filter sort and spread data

• Filter, sort, and spread data.

• Adjust plan data.

• Add comments, supporting detail, documents, and account

annotations to form cells.

• Clear cell details.

• Perform ad hoc analysis in forms.

Enter, annotate, and analyze data

8

In Lessons 16 and 17, you learn how to navigate in Planning forms, enabling you to enter, adjust, analyze, and submit data. You also learn how to add annotations such as comments, supporting detail, document attachments, and account annotations.

Oracle Internal & Or

(55)

Step 9: Managing Business Rules

Create and manage business rules in Calculation Manager:

• Adding rule components

• Implementing system templates

• Grouping rules into rulesets

• Validating and deploying rules and rulesets

• Launching rules and rulesets

Manage business rules

9

You create and manage business rules in Lesson 18, “Managing Business Rules”.

Oracle Internal & Or

(56)

Step 10: Setting Up and Managing

the Approval Process

Manage the approval process:

• Set up Planning Unit Hierarchies

• Build and implement validation rules

• Start and manage the review cycle

Set up and manage approval process

10

You set up the planning unit hierarchy used in the approval process and mange the review cycle in lessons 19 and 20.

Oracle Internal & Or

(57)

Step 11: Creating and Managing Task Lists

Guide users through the planning process:

• Create and manage task lists

• Assign access to task lists

• Print task list reports

Create and manage task lists

11

You create and manage task lists in Lesson 21, “Creating Task Lists”.

Oracle Internal & Or

(58)

Training Environment

Web application and web servers Third-party software

Data sources Planning product

components

The training environment is a single-server configuration that combines all tiers on one machine. Oracle recommends this configuration for a development environment or for customers who roll out Planning to a very limited number of users.

For a list of products and modules that are included in the training environment, see “Planning Architecture” in this lesson.

Oracle Internal & Or

(59)

Quiz

Select three Planning components.

a.

Dimension Services

b.

Application Server

c

Essbase databases

c.

Essbase databases

d.

Relational databases

Answer: b, c, d

Oracle Internal & Or

(60)

Quiz

You can load Planning data through Essbase, FDM, or ERP

Integrator.

a.

True

b

False

b.

False

Answer: a

Oracle Internal & Or

(61)

Quiz

You can only use the provided business rules to calculate data

in Planning.

a.

True

b

False

b.

False

Answer: b

Oracle Internal & Or

(62)

Quiz

Public Sector Planning and Budgeting is an included module

with Planning.

a.

True

b

False

b.

False

Answer: b

Oracle Internal & Or

(63)

Summary

In this lesson, you should have learned to:

• Describe Planning and its components

• Identify the product components within the Planning

architecture

• Explain the Planning business process

• Discuss a typical Planning business scenario

Oracle Internal & Or

(64)

Practice 1-1 Through 1-4

The practice covers the following topics:

• Starting EPM Services

• Identifying Your Server Name

• Preparing the Browser

• Reviewing the Business Scenario, Users, and Roles

Oracle Internal & Or

(65)

N

i

ti

EPM W k

Navigating EPM Workspace

Oracle Internal & Or

(66)

Objectives

After completing this lesson, you should be able to:

• Describe the benefits of EPM Workspace

• Launch EPM Workspace

• Explain the user interface components

• Set general preferences

• Open applications

• Navigate Planning

Oracle Internal & Or

(67)

EPM Workspace: Overview

Planning

Performance Management Architect EPM Workspace

Manage enterprise financial information Manage enterprise financial information

Oracle Hyperion applications Planning output

EPM Workspace provides a centralized interface for viewing and interacting with content that was created with EPM System financial applications, such as Planning, Public Sector

Planning and Budgeting, Profitability and Cost Management, Financial Management, and

Financial Reporting.

Benefits of EPM Workspace

• Single sign-on (users log on to EPM Workspace to access both Reporting and Analysis content and Planning)

• Single console for application management and creation (administrators create,

manage, and deploy applications from a single location. You open these applications in

f )

Planning for data retrieval and data output.)

• Centralized repository of key dimensional elements for Oracle Hyperion products • Centralized console for controlling data flow between applications

• Audit logging and process controls

Oracle Internal & Or

(68)

Tasks that you can perform in EPM Workspace

• Build, migrate, and manage applications. • Manage data sources metadata and data. • Create rules with Calculation Manager • Create rules with Calculation Manager.

• Conduct high-performance, multidimensional modeling, analysis, and reporting with Essbase.

• Generate and manage book contents, and organize the table of contents with Financial Reporting.

• Report on data stored in ASO and BSO databases with Financial Reporting.

• Use Interactive Reporting to generate ad hoc relational queries self service reports and • Use Interactive Reporting to generate ad hoc relational queries, self-service reports, and

dashboards against open database connectivity (ODBC) data sources. • Use Web Analysis to perform interactive ad hoc analysis, presentations, and

multidimensional data reporting.

• Generate enterprise metrics for management metrics and analysis, and present information in interactive dynamic dashboards.

• Access and interact with other published content, such as, Microsoft Word or ExcelAccess and interact with other published content, such as, Microsoft Word or Excel documents.

• Integrate metadata and data from an ERP source system into an EPM target application.

D81987 - Oracle Hyperion Planning 11.1.2 Create & Manage Applications

Oracle Internal & Or

Oracle Internal & Or

Contents

Oracle Internal & Or

Oracle Internal & Or

Oracle Internal & Or

Oracle Internal & Or

Oracle Internal & Or

Oracle Internal & Or

Oracle Internal & Or

Oracle Internal & Or

Oracle Internal & Or

Oracle Internal & Or

Oracle Internal & Or

Oracle Internal & Or

Oracle Internal & Or

Oracle Internal & Or

I t d

ti

t Pl

i

Introduction to Planning

Oracle Internal & Or

Course Objectives

After completing the course, you should be able to:

•

Create and deploy Planning applications

•

Manage metadata and data

•

Set up security for users groups and members

•

Set up security for users, groups, and members

•

Create and customize forms, menus, and task lists

•

Migrate application artifacts

•

Verify application setup

•

Set up and test business rules

p

•

Set up and manage the approval process

Oracle Internal & Or

Course Agenda: Day 1

Lesson 1: Introduction to Planning

Lesson 2: Navigating EPM Workspace

Lesson 3: Introduction to Applications and Dimensions

Lesson 4: Creating Applications in Planning Administration

Lesson 4: Creating Applications in Planning Administration

Lesson 5: Managing Dimensions

Oracle Internal & Or

Course Agenda: Day 2

Lesson 6: Setting Up the Alias, Currency, Year, and Period

Dimensions

Lesson 7: Setting Up Scenarios and Versions

Lesson 8: Loading Metadata

Lesson 8: Loading Metadata

Lesson 9: Setting Up the Entity and Account Dimensions

Lesson 10: Creating User-Defined Elements

Oracle Internal & Or

Course Agenda: Day 3

Lesson 11: Setting Up Exchange Rates

Lesson 12: Loading and Calculating Data

Lesson 13: Setting Up Planning Security

Lesson 14: Creating Forms

Lesson 14: Creating Forms

Oracle Internal & Or

Course Agenda: Day 4

Lesson 15: Enhancing Forms

Lesson 16: Entering Data in Planning

Lesson 17: Annotating and Analyzing Data

Lesson 18: Managing Business Rules

Lesson 18: Managing Business Rules

Oracle Internal & Or

Course Agenda: Day 5

Lesson 19: Setting Up the Approval Process

Lesson 20: Managing the Approval Process