Szkolenie

ODB003 Oracle Reporting

Cel szkolenia

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.

Program szkolenia

1.       Financial Reporting Overview

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

2.       Navigating Reports in EPM Workspace

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

3.       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

4.       Applying Advanced Member Selections

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

5.       Customizing Grids

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

6.       Formatting Cells and Grids

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

7.       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

8.       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

9.       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

10.   Creating Books

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

11.   Creating Batches

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

Czas trwania szkolenia

dni/godziny:      5/40

Koszt szkolenia

Cena szkolenia wynosi 3 800 zł netto za osobę + VAT