Oracle Cloud EPM: Reports Designer (2 days)

Image

HOME | TRAINING COURSES

How Can I Take this Course?

Keyteach provides flexible training options to suit your needs. Choose from globally scheduled instructor-led courses, private team classes, or our self-paced 'On Demand' training. The 'On Demand' option features a live hands-on lab for in-depth workshops and unlimited instructor support.

Would you like to arrange a private class for your team?

Keyteach provides the flexibility to deliver this instructor-led course on dates that suit your team’s schedule. Private classes, conducted live online with a remote instructor, require a minimum of two participants. Alternatively, we can arrange in-person training at your location upon request.

  • Oracle Cloud EPM: Reports Designer Private Class   $1,920.00 per person (min 2 attendees)
der-01_1040126109
30PC_OFF
-30%$1,920.00$1,344.00 per person Oracle Cloud EPM: Reports Designer: On Demand

INSTANT ACCESS

  • An immediate 'On Demand' subscription for you
  • Instant access - start training today!
  • 90 day course subscription
  • Hands-on lab access for 14 days
  • Unlimited instructor support
  • Train anywhere, anytime at your convenience
ppv_voucher-01_657498908
30PC_OFF
-30%$1,920.00$1,344.00 per person Oracle Cloud EPM: Reports Designer: (Pre-Paid Vouchers)

PRE-PAID VOUCHERS

  • 'On Demand' vouchers for you or your team to redeem later
  • Voucher codes valid for 12 months
  • 90 day course subscription
  • Hands-on lab access for 14 days
  • Unlimited instructor support
  • Train anywhere, anytime at your convenience

Course Summary

Learn how to create and manage reports using dynamic design characteristics with Cloud EPM Reports (Management Reporting). Discover how to update grids, text and image objects automatically. Find out how to generate dynamic text functions and formulas to produce sophisticated analysis of data and reduce the time and effort required to maintain Cloud EPM Reports.

Audience

  • System Administrators
  • Implementation Consultants
  • Report Developers
  • Power Users

Duration

  • Instructor-led training: 2 days (14 CPE Credits)
  • Self-paced on demand training: 90 days (14 CPE Credits)

Course Description

This comprehensive course addresses all aspects of report design and no prior knowledge is assumed. You’ll gain an understanding of how to build and maintain the most efficient reports and books for your reporting requirements. You’ll focus on the use of dynamic functionality and features to ensure that your reports are up-to-date and require little maintenance. Cloud EPM Reports is hugely powerful and can be used across Oracle’s Cloud EPM Services. This course will ensure that you’re up to speed with the very latest features of this web-based reporting solution. This course will enable you to deliver complex, yet elegant reports that can be produced automatically. You’ll find out how they can be distributed via email as reports or books and can be produced as interactive HTML.

This two-day course is essential for anybody who needs to create and maintain statutory and /or management reports.

Learning Objectives

By the end of this course learners will be able to:

  • Define how to create EPM Cloud Reports
  • Recall how to navigate the Reports interface
  • Compare global and local Point of Views
  • Appraise how the use of stored objects can help developers to design and maintain reports
  • Relate how functions can be created and used in reports
  • Use Books and Bursting to automate report generation
  • Introducing EPM Reports
    • Architecture
    • Reporting options
    • Reporting overview
    • Viewing reports
    • HTML vs PDF
    • Incorporating dimensions
    • Metadata and design considerations
    • Managing the Library
  • Creating Basic Reports
    • The reporting layout
    • Dimension layout
    • Selecting members for reports
    • Global and local POVs
    • Formatting
    • Text functions
    • Working with objects
    • Copying formatting
  • Selecting Members Dynamically
    • Relative member function
    • Working with ranges
    • Current member and the POV
    • Same As member selection
    • Time members and period offset
    • Conditional formatting
    • Automatic calculations
    • Working with prompts
  • Calculations in Reports
    • Understanding reporting calculations
    • Segments and cells
    • Variance function
    • IfThen function
    • PercentOfTotal function
    • Sorting and ranking
  • Dynamic Report Building
    • Benefits of dynamic design
    • Objects and report templates
    • Related content
    • Charts
    • Supporting detail
    • Cell text
    • Expansions / Zooming
  • Reporting Features
    • Books
    • Bursting
    • Data source connections
    • Importing / Exporting Reports
    • Security

National Association of State Boards of Accountancy (NASBA)

Image
  • Course title: Oracle Cloud EPM: Reports Designer
  • Duration: 2 days
  • Audience: System Administrators | Developers | Report Designers | Implementation Consultants
  • Pre-requisites: None
  • Delivery method: Group Live, Group Internet-Based (pending) and QAS Self-Study
  • Advanced preparation: None
  • Recommended CPE credits:
    Group Live and Group Internet-Based: 14 credits - computer software and applications
    QAS Self-Study: 14 credits - computer software and applications
  • Programme level: Intermediate

Keyteach is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. Registration ID No 115820. State boards of accountancy have the final authority on the acceptance of individual courses for CPE credit. Any complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.learningmarket.org

KEYTEACH