Management Cloud Service 11.1.1.10
Contents
Human Resources – Learning Enrollment and Completion Subject Area... 3
Description ... 3
Key Business Questions... 3
July 2015
Oracle Transactional Business Intelligence Enterprise
Page | 3
Description
The Learning Enrollment and Completion subject area monitors learning program utilization and employee learning enrollment and completion rate. It helps the Learning department and business leaders to assess delivered learning hours, courses with high enrollment, courses in demand, and the effectiveness of learning on employee development, performance and retention.
This subject area has no integration to Oracle Learning cloud. A universal adaptor is available to upload and integrate learning system data with HR and talent data in the HR Analytics data model.
Key Business Questions
This subject area can be used to answer business questions such as:
• How many learning hours have been delivered by job function, by department, by geography, and by tenure?
• How many learning courses are available and by learning type? Examples: ILT, VILT, WBT, Blended Learning, and so on.
• What is the percentage of employees who have enrolled in learning courses? By organization? By region? By job?
• How many total courses/sessions have been delivered?
• How many instructor-led training courses and hours have been delivered? • How many e-learning course and hours have been delivered?
• What is the average number of completed learning hours per employee? By organization? By region? By job?
• What is the learning completion rate by learning type? • What’s the learning completion rate of new hires?
• How is employee performance correlated with learning investment?
• Does investment in employee learning have an impact on employee retention?
Job Roles
The following job roles are used to secure access to this subject area:
• Human Resources VP • BI Content Administrator
Duty Roles
The following BI duty roles are used to secure access to this subject area:
• Learning Enrollment and Completion Analysis Duty
BI Product Offering
Oracle® Transactional Business Intelligence Enterprise for Human Capital Management Cloud Service
BI Product Release
Dimensions
Dimension Folder
Name Sub-folder Name Description Special Considerations Fusion Navigation Time A folder that contains time
attributes and hierarchy. Gregorian
Calendar A folder containing time dimensional attributes, for example, Year, Quarter, Month, Day, and a Time hierarchy.
Enterprise
Calendar A folder containing enterprise calendar period. Enterprise Calendar is a configurable reporting calendar that can be mapped to either a fiscal calendar or a calendar generated in the warehouse. Enterprise Calendar enables cross-functional reporting between HR, Finance or other analytical subject areas.
Hierarchies A folder that organizes the major hierarchies available for inclusion in analyses. Supervisor
Hierarchy The hierarchy of supervisors within the organization. Use this hierarchy for
management chain reporting and analysis. Top Level Supervisor Name is the top level of the supervisor hierarchy whereas Level 16 is the bottom level. Supervisor hierarchy levels display only employees who have direct reports. Supervisor hierarchy does not display the name of non-manager direct reports. The node Direct Report includes the total number of direct reports regardless if the direct report has direct reports. Position
Hierarchy The hierarchy of positions within the organization. Top Level Position Name is the top level of the hierarchy whereas Level 16 is the bottom level.
July 2015
Oracle Transactional Business Intelligence Enterprise
Page | 5
Hierarchy departments within the organization. Use this hierarchy for organization structure reporting and analysis. Department Top Hierarchy Name is the top of the hierarchy whereas Department Hierarchy 1 Name is the bottom level.
hierarchy attribute columns (labeled Department Hierarchy Level #), you must filter the analysis by Hierarchy Name and Hierarchy Version to ensure accurate results. Management -> Workforce Structures -> Tasks -> Department -> Manage Department Trees
Bands Contains folders that segment key dimensions into bands for simplified analysis.
Age Band A folder containing information about a worker's age band.
Age bands are configurable by domain value configuration.
Not applicable (derived information)
Compa-ratio
Band Compa-ratio range bands analyze employee compa-ratio distribution.
Compa-ratio bands are configurable by domain value configuration.
Not applicable (derived information)
Performance
Band A folder containing the normalized performance band attributes including performance bands and band ranges. Performance bands are configurable by domain value configuration. Navigator -> Workforce Management -> Person Management -> Tasks -> Career -> Manager Talent Profile
Length of
Service Band A folder containing Length of Service Band dimension attributes including bands and band range.
Length of Service bands are configurable by domain value configuration.
Not applicable (derived information)
Period of Placement Band
A folder containing Period of Placement Band for contingent workers including bands and band range. Period of Placement bands are configurable by domain value configuration.
Not applicable (derived information)
Worker
Dimensions A folder containing attributes about workers' personal information, assignment, diversity, citizenship, location, position, job, and pay grade. Basic
Information A folder containing workers' basic information including identification number, names, and assignment types.
Navigator -> Workforce Management -> Person Management -> Tasks -> Personal and Employment -> Manage Person; Manage Employment; Manage Work Relationship
Worker Dates A folder containing worker
Employment
Information A folder containing workers' employment information including hire, service dates, contract start/end dates, and performance rating.
Navigator -> Workforce Management -> Person Management -> Tasks -> Personal and Employment -> Manage Employment; Manage Work Relationship Cost Center A folder containing cost
center code and name. Diversity A folder containing worker's
diversity information including ethnicity, gender, religion, and disability status.
Navigator -> Workforce Management -> Person Management -> Tasks -> Personal and Employment -> Manage Person
Education A folder containing information on workers' highest education level.
Navigator -> Workforce Management -> Person Management -> Tasks -> Personal and Employment -> Manage Person
Employment A folder containing information on workers’ employment attributes.
Navigator -> Workforce Management -> Person Management -> Tasks -> Personal and Employment -> Manage Person; Manage Employment; Manage Work Relationship
Job A folder containing job dimension attributes including job, job family, job function, and EEO job category for U.S. regulatory reporting.
Navigator -> Workforce Management -> Person Management -> Tasks -> Personal and Employment -> Manage Employment Pay Grade A folder containing pay
grade attributes including pay grade range in both local and reporting currency.
Navigator -> Workforce Management -> Person Management -> Tasks -> Personal and Employment -> Manage Employment Position A folder containing
information about HR position attributes including position hiring status, full-time status, hourly or salary, and security clearance.
Navigator -> Workforce Management -> Person Management -> Tasks -> Personal and Employment -> Manage Employment Department A folder containing
attributes for the department to which the employee is assigned.
Navigator -> Workforce Management -> Person Management -> Tasks -> Personal and Employment -> Manage Employment Supervisor A folder containing
July 2015
Oracle Transactional Business Intelligence Enterprise
Page | 7
location address attributes. Management -> Person Management -> Tasks -> Personal and Employment -> Manage Employment; Manage Work Relationship HR Business
Unit A folder containing HR Business Unit dimension attributes.
Navigator -> Workforce Management -> Person Management -> Tasks -> Personal and Employment -> Manage Employment Legal Entity A folder containing Legal
Entity name and identifier. Navigator -> Workforce Management -> Person Management -> Tasks -> Personal and Employment -> Manage Employment Reporting
Establishment A folder containing Reporting Establishment attributes.
Navigator -> Workforce Management -> Person Management -> Tasks -> Personal and Employment -> Manage Employment International
Assignment A folder containing the Compensation Owner for international assignments.
Navigator -> Workforce Management -> Person Management -> Tasks -> Personal and Employment -> Manage Employment Learning Dimensions Learning Course and Activity
A folder containing learning course, course type, learning activity, delivery method, and language.
Not Applicable
Learning
Program A folder containing learning program and type. Not Applicable Enrollment
Status A folder containing learning enrollment status. Not Applicable Learning
Grade A folder containing grade and score. Not Applicable Learning Event
Facts
Fact Folder
Name Description Special Considerations Facts –
Enrollment Facts
A folder containing learning enrollment and completion metrics.
Metric Description Calculation
Successful Enrollment Count Number of course activities that are successfully enrolled by learner. It excludes the following statuses: Dropped, Denied and Waitlisted.
Total Enrollment Count where Enrollment Status not IN ('DROPPED', 'DENIED', 'WAITLISTED')
Successful Enrollment Rate Number of successful enrollments divided by total
enrollments. Successful Enrollment Count / Enrollment Count Enrollment Wait Time (Days) Length of time from initial enrollment initiated to start of
learning activity. If learner has to make multiple attempts to enroll in the course, the calculation from the first enrollment initiated date. This is valid only on the enrollments with "Enrolled" Status or the current enrollment for the same learner/course.
Number of Days between Initial Enrollment Initiated Date and Activity Start Date
Average Enrollment Wait
Time (Day) The average enrollments wait time in days. Enrollment Wait Time (Days) / Enrollment Wait Time Count
Successful Completion Count Number of course activities that are completed successfully by learner. It includes the following status: Completed and Waived.
Completed Status Count + Waived Status Count Successful Completion Rate Number of completions with Completed or Waived status
divided by number of completions with Completed, Waived,
or Not Completed. Successful Completion Count / (Successful Completion Count + Not Completed Status Count)
Score Score received by learner. Average Score Average score.
Internal Learner Count Number of internal learners (employees). Total Count of Learners where Internal Learner Flag = ‘Y’
Unique Employee Count Distinct employee count for the enrollments. Count of Employee ID Course Passed Count Number of courses that are passed by learner. Total Count of Courses
where Pass Flag =’Y’ Course Required Count Number of enrollments with courses that are required
courses. Total Count of Courses where Required Flag =’Y’ Delivered Training Hours Number of training hours delivered. It includes the hours for
the following completion statuses: Completed and Not Completed.
Sum of Training Hours where (Completed Status Count + Not Completed Status Count) > 0
Fact Folder
Name Description Special Considerations Facts –
Learning Calendar Facts
July 2015
Oracle Transactional Business Intelligence Enterprise
Page | 9
Training Hours Number of training hours. Training Hours Training Days Number of training days. Training
Hours/8 Fact Folder
Name Description Special Considerations Facts –
Workforce Deployment Facts
A folder containing worker headcount and performance metrics. Metrics in this folder can be correlated with learning enrollment metrics to assess learning effectiveness.
Metric Description Calculation Employee
Headcount Headcount of active employees; employees are modeled in the employment dimension. The Aggregation rule is last value when used with the Time dimension. With all other dimensions, aggregation rule is sum.
Total Headcount where Active Status =’A’ and Worker Type = ‘Employee’
Average Employee Headcount
(Employee Headcount + Employee Headcount
YAGO) / 2 (Employee Headcount + Employee Headcount Year Ago )/2 Contingent
Worker Headcount
Headcount of active contingent workers; contingent workers are modeled in the
employment dimension. The Aggregation rule is last value when used with the Time dimension. With all other dimensions, aggregation rule is sum.
Total Headcount where Active Status =’A’ and Worker Type = ‘Contingent’
Fact Folder
Name Description Special Considerations Facts –
Workforce Performance Facts
Metric Description Calculation Employee
Performance Rating The normalized (percentage) performance rating; the aggregation level is Employee dimension.
Employee Normalized Performance Rating Employee
Performance Rating YAGO
The normalized (percentage) performance YAGO rating; the aggregation level is Employee dimension.
AGO(Employee Performance Rating, Date."Year", 1) Performance Rating The normalized (percentage) performance
rating for the employee; the default aggregation level is Performance Band dimension.
Mean Performance
_____________________________________________________________________________________________________________________ Copyright © 2015, Oracle and/or its affiliates. All rights reserved.
This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited. The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.
If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, the following notice is applicable:
U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, delivered to U.S. Government end users are "commercial computer software" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, shall be subject to license terms and license restrictions applicable to the programs. No other rights are granted to the U.S. Government.
This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate failsafe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.
Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners. Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.
This software or hardware and documentation may provide access to or information on content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services. This documentation is in pre-production status and is intended for demonstration and preliminary use only. It may not be specific to the hardware on which you are using the software. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to this documentation and will not be responsible for any loss, costs, or damages incurred due to the use of this documentation.
The information contained in this document is for informational sharing purposes only and should be considered in your capacity as a customer advisory board member or pursuant to your beta trial agreement only. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described in this document remains at the sole discretion of Oracle.