Oracle Hyperion Financial Reporting 11.1.2 for Essbase and Planning

Course DateLocationDaysPriceRegister
Sep 7, 2017Toronto2 $2,420Register
Nov 8, 2017Toronto2 $2,420Register
Jan 9, 2018Toronto2 $2,420Register
Apr 3, 2018Toronto2 $2,420Register


Course DateLocationDaysPriceRegister
Sep 5, 2017Live Virtual - 10:00 am Eastern2 $2,320Register
Nov 14, 2017Live Virtual - 11:00 am Eastern2 $2,320Register


Course DateLocationDaysPriceRegister
Self-Paced Learning2 $2,140Register


Oracle Hyperion Financial Reporting 11.1.2 for Essbase Planning (11.1.2.2)

Description: This Oracle Hyperion Financial Reporting training teaches you how to create and manage reports with Financial Reporting. Learn to create objects, books, batches, format reports, add auto calculations and functions and more.Learn To: Describe Financial Reporting architecture and componentsView reports and set related preferences in EPM WorkspaceCreate reports and report objects (grids, text boxes, charts, images, and templates)Apply member selection with members, lists, and functions for rows, columns, and pagesFormat reports and define auto calculations and functions in a reportCreate books and batches to generate reports*This course is suitable for customers using all versions of Oracle Hyperion Financial Reporting 11.1.2Live Virtual Class FormatA Live Virtual Class (LVC) is exclusively for registered students; unregistered individuals may not view an LVC at any time. Registered students must view the class from the country listed in the registration form. Unauthorized recording, copying, or transmission of LVC content may not be made.

Duration: 2 Days

Course Objective:

  • Apply member selection with members, lists, and functions for rows, columns, and pages
  • Format reports
  • Define auto calculations and functions in reports
  • Create books and batches to generate reports
  • Describe Financial Reporting architecture and components
  • View reports and set related preferences in EPM Workspace
  • Create reports and reports objects (grids, text boxes, images, and templates)

Audience:

  • Reports Developer

Prerequisites:

  • Basic knowledge of Essbase or Planning data sources
  • Basic Microsoft Windows skills

Topics:

Financial Reporting Overview

  • Oracle's Enterprise Performance Management System
  • Financial Reporting Functionality and Architecture
  • Financial Reporting Data Sources

Navigating Reports in EPM Workspace

  • Navigating EPM Workspace
  • Previewing Reports and Snapshots
  • Setting Preferences
  • Integrating Reports into Microsoft Office Applications

Creating Basic Reports

  • Reporting Studio Overview
  • Report Creation Overview
  • Creating Reports
  • Adding Grids
  • Selecting Members for Grids
  • Setting the Point of View
  • Adding Rows or Columns
  • Saving, Previewing, and Printing Reports

Applying Advanced Member Selections

  • Selecting Members by Using Lists
  • Creating User-Defined Lists
  • Selecting Members by Using Functions
  • Selecting Members for the Page Axis

Customizing Grids

  • Displaying Details in Reports
  • Attaching External Documents
  • Displaying Planning Supporting Details
  • Setting Up Expansions
  • Creating Related Content in Reports

Formatting Cells and Grids

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

Creating Report Objects

  • Report Objects Overview
  • Creating Text Boxes
  • Adding Images
  • Saving and Linking Report Objects
  • Inserting Saved Report Objects
  • Adding Headers and Footers
  • Designing Row and Column Templates

Adding Text Functions

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

Adding Auto Calculations and Mathematical Functions

  • Setting Up Auto Calculations in Data Rows and Columns
  • Applying Mathematical Functions and Properties
  • Mathematical Operators in Expressions
  • Creating Formulas
  • Common Mathematical Functions

Creating Books

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

Creating Batches

  • Batches Overview
  • Creating and Scheduling Batches
  • Scheduling Batch-Bursting Options
  • Previewing Static HTML Output
  • Monitoring Batch Schedules

Related Courses:

  • Oracle Hyperion Financial Reporting 11.1.2 for Essbase Planning (11.1.2.2)
  • Instructor Led Training
  • Oracle Hyperion Financial Reporting 11.1.2 for Essbase Planning (11.1.2.2)
  • Training on Demand
Course DateLocationDaysPriceRegister
Sep 7, 2017Toronto2 $2,420Register
Nov 8, 2017Toronto2 $2,420Register
Jan 9, 2018Toronto2 $2,420Register
Apr 3, 2018Toronto2 $2,420Register


Course DateLocationDaysPriceRegister
Sep 5, 2017Live Virtual - 10:00 am Eastern2 $2,320Register
Nov 14, 2017Live Virtual - 11:00 am Eastern2 $2,320Register


Course DateLocationDaysPriceRegister
Self-Paced Learning2 $2,140Register