(25B) Oracle Fusion Cloud HCM: Advanced OTBI Techniques

Creating KPIs

• Objectives
• What Are Key Performance Indicators?
• How KPI Components Work Together?
• How Can I Create KPIs?
• How Can I Use KPIs?
• Summary

Restructuring Data

• Objectives
• What are Bins?
• How Can I Create a Bin?
• What are Set Operators?
• What are the Types of Set Operators?
• Set Operator Examples
• Viewing a Union Set Operator Example
• Steps to Build Analyses with Set Operators
• Define Primary Analysis
• Edit Formulas
• Determine Set Operators
• Define the Second Analysis
• Summary
• Practices

Examining Advanced Analysis Views

• Objectives
• What’s a Trellis View?
• Types of Trellis Views
• What are Gauge and Funnel Views?
• Examining Other Analysis Views
• Legend, Narrative, Logical SQL, and View Selector Examples
• Summary
• Practices

Managing Content with Analysis Tools

• Objectives
• Setting Analysis Properties
• What are Column Selectors?
• Adding Column Selectors to Analyses
• Creating Master-Detail Channels
• Defining the Master View
• Defining the Detail View
• Looking at the Master-Detail View in Action
• Summary
• Practices

Creating Analysis Formula

• Objectives
• What are Analysis Formulas?
• Why do we Need Analysis Formulas?
• Overview of Formulas in OTBI
• How Can I Change the Formula?
• What are Formula Functions?
• Exploring Formula Filters
• Exploring Formula Columns
• Exploring Formula Variables
• Example Formula
• Summary
• Practices

Integrating with HCM Cloud

• Objectives
• Sandboxes Overview
• About Reports and Dashboards
• How Can I Add Analyses to Dashboards?
• What are Infolets?
• How Can I Create Infolets?
• Summary

Security

• Objectives
• Security and Reporting Overview
• Subject Area Access
• BI Catalog Folders Access
• Data Security
• Business Intelligence Roles
• View Reporting Roles on the Security Console
• View Permissions in the BI Catalog
• Summary

Information Resources

• Information Resources
• Oracle Help Center
• My Oracle Support
• Oracle Cloud Customer Connect
• Oracle University
• Oracle Partner Community