Microsoft training courses, Cisco training courses, Prince2 training courses, ISEB training courses with locations nationwide
Call now to speak to an experienced Training Advisor
 
     
 
         
 
 
Thousands of Microsoft, ISEB, ITIL, Cisco and Prince2 Training Courses and more
 
 
Browse Oracle Training Courses

Hyperion Planning 9.3.1 for Interactive Users

Course Code: D52790GC10      Days: 3
Show all Oracle Courses
Call for Latest Dates
Call us on 0870 7777 388 for availability on this course.
Have questions or need a better city/date? Ask now.

Course Overview

This course is designed to teach you how to use Planning. The course includes an overview of Planning features, capabilities, and its relationship with Analytic Services. You create data forms and task lists, enter and adjust data, set up calculations, and move a plan through the budget review-and-approval process. You learn how to create management-quality reports with Financial Reporting or Web Analysis*. Exercises provide hands-on practice.

Course objectives:

  • Discuss Planning capabilities and its relationship with Essbase
  • Discuss Planning dimension requirements
  • Navigate Workspace to access Planning and Financial Reporting or Web Analysis
  • Create and test data forms
  • Enter and adjust data in Planning and Smart View
  • Work with Offline Planning
  • Set up and test business rules
  • Move plans through a budget review cycle
  • Set up and implement task lists
  • Create reports and documents to analyze planning results

Audience

  • Business Analysts

Skills Gained

Delegates will learn to:

  • Navigate Workspace to access Planning, Financial Reporting or Web Analysis
  • Create and test data forms
  • Enter and adjust data in Planning and Smart View
  • Set up and test business rules
  • Move plans through a budget review cycle
  • Discuss Planning capabilities

Prerequisites

  • Basic knowledge of Excel or Lotus 1-2-3
  • Basic knowledge of planning and budgeting
  • Familiarity with concepts of client-server applications
  • Basic knowledge of Microsoft Windows
  • Basic knowledge of Excel or Lotus 1-2-3
  • Basic knowledge of planning and budgeting
  • Familiarity with concepts of client-server applications
  • Basic knowledge of Microsoft Windows

Course Outline

Planning Overview

  • Enterprise Performance Management
  • Product Components
  • User Roles
  • Planning
  • Planning and Essbase

Navigating Workspace

  • Launching Workspace
  • Workspace User Interface
  • Opening Applications
  • Navigating in Planning

Planning Dimensions and Data Storage Overview

  • Planning Required and User-Defined Dimensions
  • Dense and Sparse Dimensions
  • Factors that Impact Calculations

Creating Data Forms and Folders

  • Data Forms and Folders Overview
  • Data Form Elements
  • Creating Folder Structures for Data Forms
  • Data Form Requirements
  • Composite Data Forms
  • Printing Data Form Definition Reports
  • Assigning Access Rights to Data Forms

Customizing Data Forms

  • Adding Menus to Data Forms
  • Managing User Variables
  • Setting Up User Preferences

Entering Data

  • Submitting Data in Data Forms
  • Spreading Data
  • Adjusting and Annotating Data
  • Calculating Data in Data Forms
  • Entering Data with Smart Lists
  • Navigating Data Forms with Menus

Entering Data Using Smart View

  • Smart View Overview
  • Planning and Smart View
  • Offline Planning Overview
  • Taking Data Forms Offline

Creating Business Rules

  • Business Rules Overview
  • Navigating Business Rules
  • Business Rules Creation Process
  • Launching Business Rules
  • Printing Business Rules

Building Runtime Prompts for Business Rules

  • Runtime Prompts Overview
  • Adding Runtime Prompts

Adding Formulas to Business Rules

  • Business Rules Formula Overview
  • Building Formulas for Business Rules
  • Specifying Data Conditions
  • Managing Business Rules

Managing the Approval Process

  • Process Management Overview
  • Planning Units
  • Managing the Review Cycle for Planning Units
  • Copying Data Between Versions

Creating Task Lists

  • Task Lists Overview
  • Navigating Task Lists
  • Task Lists Creation Process
  • Working with Task List Folders
  • Building Task Lists
  • Assigning Access to Task Lists
  • Validating Task Lists
  • Reporting on Task Lists

Financial Reporting Overview

  • Financial Reporting Features
  • Data Sources for Financial Reporting
  • Financial Reporting Studio
  • Working with Financial Reporting Studio

Navigating Reports in Workspace

  • Workspace Overview
  • Setting Preferences
  • Browsing the Repository
  • Searching for Items
  • Previewing Reports
  • Changing Page Members
  • Printing Reports and Snapshots
  • Integrating Reports into Microsoft Office Applications

Creating Basic Reports

  • Report Creation Overview
  • Creating Reports
  • Creating Grids
  • Selecting Members
  • Setting Up the Point of View
  • Adding Rows and Columns
  • Saving Reports

Formatting Cells and Grids

  • Formatting Cells
  • Formatting Grids
  • Suppressing Data
  • Applying Conditional Formatting
  • Setting Up Pages

Creating Report Objects

  • Report Objects Overview
  • Creating Text Boxes
  • Adding Images
  • Saving Report Objects
  • Inserting Saved Report Objects
  • Linked Object Properties
  • Designing Headers and Footers

Adding Text Functions

  • Text Functions Overview
  • Inserting Text Functions in Text Boxes
  • Inserting Text Functions in Headings and Text Cells
  • Creating Dynamic Values with the Current Keyword
  • Displaying the Row and Column IDs
  • Displaying Text Functions Errors
  • Common Text Functions

Adding Auto Calculations and Mathematical Functions

  • Auto Calculations Overview
  • Mathematical Functions
  • Mathematical Operators in Expressions
  • Formulas Overview
  • Common Mathematical Functions

Setting Up Books

  • Books Overview
  • Previewing and Printing Books
  • Changing the Book Point of View
  • Creating Books
  • Changing the Appearance of Books

Reviewing Planning Data with Web Analysis

  • Web Analysis Architecture
  • Key Benefits of Web Analysis
  • Key Concepts
  • Navigating Between Open Items
  • Navigating Web Analysis Studio
  • Accessing Help
  • Workspace and Web Analysis Studio Tasks

Creating Web Analysis Documents

  • Creating Documents in Web Analysis Studio
  • Setting Format Options
  • Creating Chart Views
  • Creating Documents in Workspace

Follow On Courses

  • Hyperion Web Analysis 9.3.1: Design Reports
  • Hyperion Financial Reporting 9.3.1 for Essbase and Planning


How to make a booking for the D52790GC10 course

 
  CourseMonster books thousands of public training courses, classes and boot camps both in London and throughout the UK including: Berkshire, Birmingham, Bristol, Bournemouth, Bucks, Cambridge, Derby, Devon, Edinburgh, Glasgow, Hampshire, Ipswich, Leeds, Leicester, Luton, Manchester, Middlesex, Milton Keynes, Norfolk, Nottingham, Reading, Surrey, Sussex, Tyne and Wear, Midlands and Yorkshire. Topics range from software to administration and development.  
     
CourseMonster® Patent Pending © SeaKom, All Rights Reserved - Channel partners with Business Training Partnership