This Oracle HCM Cloud Reporting Training teaches you how to use Oracle Transactional Business Intelligence to create and share HCM analytics and reports. Business Intelligence Reporting tools are a type of application software designed to retrieve, analyze, transform and report data for business intelligence. The tools generally read data that have been previously stored, often, though not necessarily, in a data warehouse or data mart. Oracle Transactional Business Intelligence (OTBI) in Oracle Fusion is a set of pre-seeded yet customizable analysis structures that Fusion Applications users can access to create ad hoc reports, dashboards and alerts to aid daily decision-making. It helps in Building rich, visual and interactive reports and publish them to multiple users.
Course Contents
Day 1
Describing OTBI
Describing OBIA
Describing BI Publisher
Navigating to Tools for Reports and Analytics
BI Semantic Layer and the BI Catalog
Describing the Presentation Layer
Describing the BI Catalog
OTBI
Describing OTBI
Describing Subject Areas, Folders, and Attributes
Describing BI Composer
Descirbing OBI EE Answers
Creating an OTBI Analysis Using BI Composer
Creating an OTBI Analysis Using OBI EE Answers
Adding Flexfields to OTBI
Creating a Cross-Subject Area Analysis
Day 2
BI PUBLISHER
Descirbing BI Publisher
Describing the BI Publisher Architecture
Describing Data Models and Data Sources
Creating a BI Publisher Data Model
Creating a BI Publisher Report
Day 3
DASHBOARDS
Describing Types of Dashboards
Adding Content to a Dashboard
Editing a Dashboard
Describing the Process to Create a Dashboard
BRIEFING BOOKS
Describing Briefing Books
Creating a Briefing Book
Day 4
DELIVERING CONTENT
Describing Agents
Describing the Agent Editor
Creating an Agent
INTEGRATION WITH MS OFFICE
Describe the Tools for Integration with MS Office
MIGRATING REPORTS
Describing the Methods for Migrating Reports
Day 5
HCM Extract Overview
Extracts Terminology: Database Items, Database Item Groups, Routes, User Entities etc
Task Related to Extracts
- Architecture
- Extract Definitions
- Basic Extracts Definition
- Extract Parameters, Extract Blocks, Extract Block Links, Extract Records, Extract Data Elements, Extract Validation
- Running Extracts
- Delivery Options
Creating a Sample Extract