Oracle HCM Cloud: Reporting and Analytics

Duration : 2 Days (16 Hours)

Oracle HCM Cloud: Reporting and Analytics Course Overview:

The Oracle HCM Cloud Reporting and Analytics course offers a comprehensive grasp of Oracle HCM Cloud Reporting and Analytics. Participants will gain proficiency in crafting, deploying, and overseeing reports and dashboards within Oracle HCM Cloud. Practical engagement enables the learning of data object security, execution, and management, encompassing fields, query sets, lists, and templates. Topics span automated report creation, scheduling, and distribution, data extraction, and data model construction. Graduates of the course will possess an adept comprehension of the HCM reporting system, empowered to tailor secure, customized reports to address distinct business requirements.

Intended Audience:

  • Human Resources Professionals
  • Business Intelligence Analysts
  • Consultants
  • IT Teams

Learning Objectives of Oracle HCM Cloud: Reporting and Analytics:

1. Learn to utilize Oracle HCM Cloud’s robust reporting and analytics tool.
2. Explore the multiple report types and custom dashboards available.
3. Understand the benefits of creating, scheduling, and running reports.
4. Utilize descriptive flex structures and create dynamic and ad-hoc reports.
5. Customize search criteria and use security profiles to determine who can access each report
6. Define criteria, report format, layout and fields.
7. Gain insight into setting up data security to ensure that data is only shared with authorized users
8. Enhance reporting by defining different report types, setting up customized PDFs, and building graphs
9. Obtain a comprehensive overview of reporting and analytics activities for HR.
10. Utilize the Oracle HCM Cloud’s workspace to create and save reports.

 Module 1: Course Overview

  • Agenda
  • Introductions
  • Goals and Objectives
  • Description of Methodology
  • Description of Materials
  • Description of Hands-On Activities

 Module 2: Getting Started with HCM Cloud Reporting with OTBI

  • Providing an Overview of Oracle Transactional Business Intelligence (OTBI)
  • Reviewing the Five Types of Roles in Oracle Application Security
  • Examining OTBI Separation of Functional Privileges by Job Role
  • Accessing OTBI
  • Cofiguring Preferences
  • Navigating the Application
  • Running Standard Analyses

 Module 3: Scoping Analyses

  • Examining Analysis Design
  • Assigning Titles and Purposes to Analyses
  • Reviewing Distribution

 Module 4: Examining Subject Areas

  • Understanding Tree Hierarchy Reporting
  • Examining Prepackaged Subject Areas
  • Reviewing the Structure of Prepackaged Subject Areas
  • Looking at Dimension Folders
  • Looking at Fact Folders

 Module 5: Constructing Custom Analyses

  • Examining the Process Driving Custom Analyses
  • Determining Custom Analysis Content
  • Creating Basic Custom Analyses
  • Saving Basic Custom Analyses

 Module 6: Using Filters

  • Examining Filters
  • Building Filters
  • Reviewing Filter Components
  • Examining Shared Filters
  • Using Saved Analyses As Filters

 Module 7: Adding Selection Steps

  • Comparing Selection Steps with Filters
  • Examining Selection Steps
  • Working with Selection Steps
  • Filtering via Selection Steps Based on Conditions
  • Using Selection Steps Based on Conditions: Exceptions
  • Using Selection Steps Based on Conditions: Top/Bottom (Ranking)
  • Using Selection Steps Based on Conditions: Match

 Module 8: Organizing Data within Analyses

  • Examining Table Prompts
  • Examining Sections
  • Working with Sections and Table Prompts
  • Examining Groups
  • Working with Groups
  • Examining Calculated Items
  • Working with Calculated Items

 Module 9: Organizing Analyses within OTBI

  • Exploring the BI Catalog
  • Reviewing the OTBI Report Web Catalog
  • Working with the New Drop-Down Menu
  • Searching the BI Catalog
  • Examining More Actions on Analyses
  • Printing and Exporting Analyses

 Module 10: Using Scheduling Agents

  • Examining Scheduling Agents
  • Running Agents
  • Listing Agents
  • Creating Agents with Conditions
  • Examining Actions
  • Managing Agent Alerts

 Module 11: Working with OTBI Visual Aides: Incorporating Visual Aides into Analyses

  • Examining Compound Layout Panes
  • Specifying Table/View Properties
  • Examining View Types
  • Examining View Editors
  • Applying Conditional Formatting

 Module 12: Working with OTBI Visual Aides: Understanding Advanced Analysis Views

  • Examining Trellis Views
  • Examining Advanced Visual Aids
  • Understanding Advanced Analysis Views
  • Examining Legend, Narrative, Ticker, Logical SQL and View Selector Views

 Module 13: Managing Analysis Content: Using Analysis Tools

  • Setting Analysis Properties
  • Working with Column Selectors
  • Adding Column Selectors to Analyses

 Module 14: Managing Analysis Content: Restructuring Data

  • Creating Master-Detail Channels
  • Defining the Master View
  • Defining the Detail View
  • Looking at the Master-Detail View in Action

 Module 15: Creating Key Performance Indicators

  • Understanding Key Performance Indicators
  • Using KPIs in OTBI
  • Examining KPI Terms
  • Building Calculations for KPIs
  • Building KPIs

 Module 16: Scoping Dashboards

  • Examining Dashboards
  • Reviewing Dashboard Content
  • Scoping Dashboards

 Module 17: Building Dashboards

  • Creating New Dashboards
  • Adding Content to Dashboards
  • Editing and Configuring Dashboard Format and Content
  • Examining Dashboard Prompts
  • Using the Tools Toolbar
  • Configuring Dashboard Preferences from My Account

 Module 18: Creating Briefing Books

  • Examining Briefing Books
  • Turning OBI Content into Briefing Books
  • Editing Briefing Books
  • Downloading and Viewing Briefing Books
  • Adding Briefing Books to Dashboards
  • Using Briefing Books with Agents

 Module 19: Course Summary

  • Reviewing Course Objectives
  • Exploring Other OTBI Functions

Oracle HCM Cloud: Reporting and Analytics Course Prerequisites:

No specific prerequisites are required for Oracle HCM Cloud: Reporting and Analytics Training; however, knowledge of the Human Resources and Payroll processes and general familiarity with Oracle HCM Cloud applications would be beneficial. Participants should also have some basic understanding of Business Intelligence practices, such as report building techniques, prior to attending the class.

Discover the perfect fit for your learning journey

Choose Learning Modality

Live Online

  • Convenience
  • Cost-effective
  • Self-paced learning
  • Scalability


  • Interaction and collaboration
  • Networking opportunities
  • Real-time feedback
  • Personal attention


  • Familiar environment
  • Confidentiality
  • Team building
  • Immediate application

Training Exclusives

This course comes with following benefits:

  • Practice Labs.
  • Get Trained by Certified Trainers.
  • Access to the recordings of your class sessions for 90 days.
  • Digital courseware
  • Experience 24*7 learner support.

Got more questions? We’re all ears and ready to assist!

Request More Details

Please enable JavaScript in your browser to complete this form.

Subscribe to our Newsletter

Please enable JavaScript in your browser to complete this form.