To use the Learning Management reports and workbooks, you must install both Oracle HRMS and Oracle Learning Management (OLM, formerly Oracle Training Administration).
Additional Information: See also My Oracle Support Knowledge Document 2277369.1, Oracle E-Business Suite Support Implications for Discoverer 11gR1.
The following key concepts enable you to accurately interpret the results of the reports in Learning Management:
The Learning Management reports calculate the total number of hours employees have spent on training classes. For the reports to include a training class in calculations, the training class must:
Have ended in the time period defined by the time parameters
Have a status of Normal or Closed, if the class is scheduled
Not have a status of cancelled
The reports calculate the hours spent on each training class and multiply them by the number of relevant employees who attended the course.
Because students can be internal or external, the reports use the enrollment status of Attended, rather than assignment budget values, to count employees.
If a learner has successfully attended a class, the reports calculate the hours of the class using a predefined formula, then calculate the total number of successful hours for all relevant employees.
See: Amending the Default Training Hours, Oracle HRMS Configuring, Reporting, and System Administration Guide and Adding Additional Training Time Periods, Oracle HRMS Configuring, Reporting, and System Administration Guide
Most reports and workbooks calculate training success as the percentage of total training hours delivered for your employees against the number of those hours that were successful.
The Analytics workbooks, however, calculate training success as the percentage of successful students against the total number of attendees of a class.
The reports display employee job, grade, position, and organization as of the date the employee enrolled in the class. The reports do not show any updates to these values after enrollment, unless another enrollment occurs.
Training Success reports and workbooks include only employees who:
Worked in the selected organization on the date they enrolled in the class.
Have the class enrollment status of Attended.
Have, on the enrollment date, an assignment that matches the parameters you select.
When you enroll an employee in a class, you record their assignment. The reports and workbooks use this assignment, even if the employee subsequently changed their assignment.
Training Success reports and workbooks include a class only if:
An employee included in the report attended it.
The class ended prior to the workbook end date.
The class status is Normal or Closed.
The class has not been cancelled.
If a training event runs over two time periods the reports count it only once, since the Training Success reports and workbooks use the class end date to count classes.
Additional Information: See also My Oracle Support Knowledge Document 2277369.1, Oracle E-Business Suite Support Implications for Discoverer 11gR1.
This workbook investigates the amount transferred between two cost centers within an enterprise for internal training class enrollments.
This workbook has the following worksheet:
Delegate Chargeback
This worksheet investigates the amount transferred between two cost centers within an enterprise for internal training class enrollments.
What is the total amount transferred between two different organizations within an enterprise for an internal training class enrollment?
What is the total amount generated for a training organization by chargeback enrollments?
You need to specify values for the following parameters:
Class training center hierarchy
Top class training center
Date from
Date to
This workbook investigates the progress of online classes.
This workbook has the following worksheets:
By Total Time Taken Status
By Player Status
Completion Status
The worksheets in this workbook use the following calculations:
Average Number of Modules Completed
Calculates the average number of modules that have been completed per training class.
Average Time Completed
Calculates the average time (in seconds) it takes delegates to reach the player status of Completed.
Average Time Failed
Calculates the average time (in seconds) it takes delegates to reach the player status of Failed.
Average Time Incomplete
Calculates the average time (in seconds) it takes delegates to reach the player status of Incomplete.
Average Time Passed
Calculates the average time (in seconds) it takes delegates to reach the player status of Passed.
Completed – Passed
Calculates the total number of delegates that have ether completed or passed the training class. The calculation includes delegates with a player status of Completed or Passed.
Not Completed
Calculates the total number of delegates that have not completed the training class. The calculation includes delegates with a player status of Not Attempted, Failed, or Incomplete.
Player Failed
Calculates the total number of delegates with a player status of Failed.
Player Incomplete
Calculates the total number of delegates with a player status of Incomplete.
Player Status Completed
Calculates the total number of delegates with a player status of Completed.
Player Status Not Attempted
Calculates the total number of delegates with a player status of Not Attempted.
Player Status Passed
Calculates the total number of delegates with a player status of Passed.
Time Completed
Calculates the total time (seconds) that delegates with a status of Completed have been playing content on the player.
Time Completed To Char
Converts the Average Time Completed value to the format HH:MM:SS.
Time Failed
Calculates the total time (seconds) that delegates with a status of Failed have been playing content on the player.
Time Failed To Char
Converts the Average Time Failed value to the format HH:MM:SS.
Time Incomplete
Calculates the total time (seconds) that delegates with a status of Incomplete have been playing content on the player.
Time Incomplete To Char
Converts the Average Time Incomplete value to the format HH:MM:SS.
Time Passed
Calculates the total time (seconds) that delegates with a player status of Passed have been playing content on the player.
Time Passed To Char
Converts the Average Time Passed value to the format HH:MM:SS.
Total Enrollments
Calculates the total number of enrollments for each training class, based on a sum of Places Booked per Class.
This worksheet investigates the progress of your hosted online classes by the total time that delegates have been playing content of a course within the player.
Does one particular type of course take more time than the others to complete?
What are the average time taken and the average number of modules completed at each player status?
You need to specify values for the following parameters:
Course Name
Class Name
Class Start Date
Class End Date
This worksheet investigates the progress of your hosted training classes by the number of delegates at each Player Status. The Player Status categories are:
Completed
Passed
Incomplete
Not Attempted
Failed
Does one particular type of course have higher number of delegates not completing or failing?
You need to specify values for the following parameters:
Course Name
Class Name
Class Start Date
Class End Date
This worksheet presents all relevant completion details for training classes.
Are a higher percentage of delegates failing a particular class or course?
Are all/some classes within one particular course complete?
What is the completion status of my training classes?
You need to specify values for the following parameters:
Course Name
Class Name
Class Start Date
Class End Date
Player Status
Related Topics
Workforce Intelligence for Learning Management Overview
This workbook investigates the progress of individual delegates (learners) on your iLearning-hosted training classes.
Note: This workbook reports only on the training classes transferred from iLearning through the OTA-iLearning integration. It does not include classes created in OTA or OLM.
This workbook has the following worksheets:
By Total Time Taken Status
By Player Status
The worksheets in this workbook use the following calculation:
Player Status (Inserts Not Attempted)
Returns the status of Not Attempted for those delegates that have a Player Status of null.
This worksheet investigates the progress of individual delegates in your iLearning hosted training classes, by the total time they have been playing content using the iLearning player.
Are delegates spending a significant amount of time taking online training courses?
Are any of the delegates spending a significantly greater amount of time completing a training class than normal?
You need to specify values for the following parameters:
Course Name
Class Name
Class Start Date
Class End Date
This worksheet enables you to analyze the progress of delegates in your iLearning-hosted training classes by Player Status.
Are my delegates completing all of their training classes?
Are any of my delegates not progressing their training classes?
Which course has a particular delegate passed and/or failed?
You need to specify values for the following parameters:
Course Name
Class Name
Class Start Date
Class End Date
Related Topics
Workforce Intelligence for Learning Management Overview
This workbook investigates the classes and resources available in the training organization.
This workbook has the following worksheets:
Booked Resources per Class
Class Enrollments
Classes Without Trainer
Classes Without Venue
Overbooked Resources
Required Resources Missing
Resource Checklist
Resource Schedule by Activity
Suppliable Resources
Training Classes
This worksheet enables you to analyze the resources booked for specific training classes.
What are the resources booked for a specific class?
You need to specify values for the following parameters:
Class Start Date
Class End Date
Training center hierarchy
Top training center
This worksheet enables you to investigate the number of students who enroll in a class, and the number of students who successfully attend the class.
Who is enrolled on a specific class?
You need to specify values for the following parameters:
Class Start Date
Class End Date
Training center hierarchy
Top training center
This worksheet enables you to investigate the training classes that have no associated trainer.
Which training classes do not have a trainer booked?
You need to specify values for the following parameters:
Class from date
Class to date
This worksheet enables you to investigate the training classes that have no associated venue.
Which training classes do not have a training location assigned to them?
You need to specify values for the following parameters:
Class from date
Class to date
This worksheet enables you to analyze overbooked resources.
Which resources are booked more than once at the same time for different training classes?
You need to specify values for the following parameters:
Booked from
Booked to
Training center hierarchy
Top training center
This worksheet enables you to investigate the resources that are required but have not been booked for a training class.
Which essential resources are not booked for a particular training course?
What required resources are missing?
There are no parameters for this worksheet.
This worksheet displays the list of resources required to successfully run a training course.
What is the minimum resource required to run a specific training course?
You need to specify values for the following parameters:
Course name
This worksheet enables you to view the schedule for each training resource, to ensure that resources are not booked for more than one class at any one time.
At what level is a specific resource booked, for example, for the next 6 weeks?
What is the booking schedule for the available resources in the training organization?
You need to specify values for the following parameters:
Resource required from
Resource required to
Training center hierarchy
Top training center
This worksheet enables you to analyze the cost and availability of suppliable resources for your training class.
What are the resources available within a training organization in a given period of time?
You need to specify values for the following parameters:
Resource from date
Resource to date
This worksheet enables you to investigate the location, start date, and duration of specific training classes.
Which training classes are scheduled classes with a class status of normal?
How many students are enrolled on a specific class, and how many free seats remain for that class?
What are the actual, budgeted and standard costs for running specific training classes?
For a specific training course, which training classes are running in a given period of time?
You need to specify values for the following parameters:
Class start date
Class end date
Category
Training center hierarchy
Top training center
This worksheet uses the following calculation:
Class duration days
Calculates the number of days between the course start date and the course end date for the page item Class Duration.
Related Topics
Workforce Intelligence for Learning Management Overview
This workbook investigates the popularity of training classes within a given period of time, by class days and attendance.
This workbook has the following worksheets:
By Class Days
By Attendance
This worksheet enables you to investigate the popularity of training classes by ranking them by class days.
Which are the most popular classes by class days?
Which classes could be most profitable?
You need to specify values for the following parameters:
Class From Date
Class To Date
This worksheet contains the following column:
Free Seats
Values in this column are based on the Maximum Attendees minus Student Count. The calculation takes into account the number of canceled internal students as well as the number of canceled external students.
This worksheet enables you to analyze the popularity of training classes by ranking them by course attendance.
Which are the most popular classes by attendance?
Which classes are in high demand?
You need to specify values for the following parameters:
Class From Date
Class To Date
This worksheet contains the following column:
Free Seats
Values in this column are based on the Maximum Attendees minus Student Count. The calculation takes into account the number of canceled internal students as well as the number of canceled external students.
Related Topics
Workforce Intelligence for Learning Management Overview
This workbook investigates the training success ratio for external learners (students not employed by the organization running the training). If the SUCCESSFUL_ATTENDANCE_FLAG column of the OTA_DELEGATE_BOOKING table in the OTA schema is set to Yes, that enrollment is considered successful.
This workbook includes the following worksheets:
By Company
By Company and Year
These worksheets use classes to calculate success. For a class to be included it must:
Have an end date prior to the present date.
Have a status of Normal or Closed, if the class is scheduled.
Not be Canceled.
The hours of a class are calculated using a predefined Oracle FastFormula. Depending on how you record the duration of classes, you may need to customize this formula. See Setting Up and Customizing Training Hours, Deploy Strategic Reporting (HRMSi)
In addition to displaying information you have set up in OLM and HRMS, the Student Training Success (External Students) Analysis workbook calculates the following:
Hours Delivered
The total number of training hours of all the relevant classes multiplied by the number of places filled by students on these classes.
Successful Hours
If a student is recorded as successfully having attended the class, then the employee's hours for this class are recorded as successful hours.
In the workbook, the successful hours are the total number of successful hours for all relevant classes.
Success Rate Percentage
Successful hours delivered as a percentage of the total hours delivered. For example, if 10 hours were delivered, and 8 hours were successful, the success rate would be 80%.
This worksheet enables you to analyze the success of training hours delivered to external students for a company. You can investigate this for a business group and year.
What is the student success ratio for a particular company (or customer)?
Which company has the highest training success ratio?
This worksheet has no parameters.
This worksheet enables you to analyze the success of training hours delivered to external students for a company, for different years. You can investigate this for a business group and each company.
In which training year did a particular customer have the highest student success ratio?
This worksheet has no parameters.
Related Topics
Workforce Intelligence for Learning Management Overview
This workbook investigates the training success ratio for internal students (students employed by the organization running the training).
Success ratio is calculated as the number of successful training hours delivered to internal students divided by the total number of training hours delivered to internal students. The number of successful training hours per class is the number of successful internal students enrolled for a class, multiplied by the course duration in days for that class.
The total number of training hours delivered to internal students for a class is the total number of internal students enrolled for a class, multiplied by the course duration in days for that class.
If the SUCCESSFUL_ATTENDANCE_FLAG column of the OTA_DELEGATE_BOOKING table in the OTA schema is set to Yes, that enrollment is considered successful.
This workbook includes the following worksheets:
By Organization and Year
By Location and Year
By Job Category and Year
By Job and Year
Attendance Summary
These worksheets use classes to calculate success. For a class to be included it must:
Have an end date prior to the present date.
Have a status of Normal or Closed, if the class is scheduled.
Not be Cancelled.
The hours of a class are calculated using a predefined Oracle FastFormula. Depending on how you record the duration of classes, you may need to customize this formula. See Setting Up and Customizing Training Hours, Deploy Strategic Reporting (HRMSi)
In addition to displaying information you have set up in OLM and HRMS, the Student Training Success (Internal Students) Analysis workbook calculates the following:
Hours Offered
The total number of training hours for all relevant classes multiplied by the number of places available in all relevant classes.
Hours Delivered
The total number of training hours of all the relevant classes multiplied by the number of places filled by students in these classes.
Hours Received
The total number of training hours employees have attended for all relevant training classes.
Successful Hours
If a student is recorded as successfully having attended the class, then the employee's hours for this class are recorded as successful hours.
In the workbook, the successful hours are the total number of successful hours for all relevant classes.
Utilization %
The total hours delivered as a percentage of the hours offered. For example, if 5 hours were delivered, and 10 hours were offered, then the utilization percentage would be 50%.
Success Rate %
Successful hours delivered as a percentage of the total hours delivered. For example, if 10 hours were delivered, and 8 hours were successful, the success rate would be 80%.
This worksheet enables you to analyze the number of training hours delivered to internal students each year, and the success of these hours. You can investigate student success rates for a business group and organization within your enterprise.
What is the training success rate of an organization over a given period of time?
In which year did an organization have highest training success rate?
This worksheet has no parameters.
This worksheet enables you to analyze the number of training hours delivered to internal students for a location each year, and the success of these hours. You can investigate student success rates for a business group and organization within your enterprise.
What is the training success rate for a training location over a given period of time?
In which training year did a particular training location have the highest training success rate?
This worksheet has no parameters.
This worksheet enables you to analyze the number of training hours delivered to internal students each year for a job by category, and the success of these hours. You can investigate student success rates for a Business Group and organization within your enterprise.
What is the training success rate for a job category over a given period of time?
In which training year was the success rate highest for a particular job category?
This worksheet has no parameters.
This worksheet enables you to analyze the number of training hours delivered to internal students for a job by year, and the success of these hours. You can investigate student success rates for a business group and organization within your enterprise.
What is the training success rate for a job over a given period of time?
In which year did a job have the highest training success rate?
This worksheet has no parameters.
This worksheet enables you to analyze the number of internal students attending training classes. You can view internal student attendance by activity type, analyze success rates and information about failures.
How successful are my courses?
This worksheet has no parameters.
Related Topics
Workforce Intelligence for Learning Management Overview
This workbook investigates the costs involved in running training activities (courses), and indicates the revenue generated by these events (classes). It analyzes costs and revenue information by training course, sponsoring organization, training center, training category and competence.
This workbook has the following worksheets:
By Training Course
Training Course by Year
By Sponsoring Organization
Sponsoring Organization by Year
By Training Center
Training Center by Year
By Training Category
Training Category by Year
By Competence
By Competence and Year
This workbook uses the following headings and calculations:
Within OLM you can enter your costs in any currency you have set up, so that the worksheets all report in the same currency. HRMSi converts the results into the base currency of the business group.
For more information, see Entering A Conversion Rate Type, Oracle HRMS Configuring, Reporting, and System Administration Guide
Budget costs are calculated using the costs of scheduled events (classes). The budget costs for scheduled events (classes) are taken from the budget cost entered in the OLM Class page.
Actual costs are taken as the actual cost of the scheduled event (class), entered in the OLM Class page, and the cost of resources booked for the event (class).
For the cost of a resource to be included, it must be confirmed and associated with the event (class). Enter the cost for one resource per day. The cost is then multiplied by the quantity of resource required, and number of days.
The actual cost of an event (class) is the actual cost plus the cost of all resources for the event (class).
Actual revenue is the sum of internal and external revenue for each scheduled event (class). Internal revenue is calculated using the internal enrollments for a scheduled event (class).
Internal enrollments are entered in the Enrollment Details window using the organization type. For the enrollment to be included, it must have a status of Attended.
Note: The workbook does not use the Internal check box on the Enrollment page.
The number of places for all internal enrollments are then added together. This is then multiplied by the price basis amount for the event (class).
External revenue is calculated using all the external enrollments for a scheduled event (class). For the enrollment to be included, it must have a status of Attended.
External enrollments are linked to a finance line, which includes the cost of the enrollment. For a finance line to be included, it must be of the type Enrollment and must not be cancelled.
The total external revenue is the sum of the finance line amounts, summed over all the external bookings.
The total number of external students enrolled, added to the total number of internal students enrolled.
The actual cost divided by the students enrolled.
The actual revenue divided by the students enrolled.
The total number of training hours for all relevant events (classes) multiplied by the number of places available on these events (classes).
The total number of training hours for all relevant events (classes), multiplied by the number of places filled by students on these events (classes).
The actual costs divided by the hours delivered.
This worksheet enables you to analyze the cost and revenue generated by training events (classes). You can investigate training activities for a specific Business Group, sponsoring organization and year.
What are the costs involved in running training events (classes) by course?
How much revenue is generated by these training events (classes), every year?
This worksheet does not use parameters.
This worksheet enables you to analyze the cost and revenue of training activities for different years, by business group and sponsoring organization.
What are the costs involved in running a training course?
How much revenue is generated by this course each year?
This worksheet does not use parameters.
This worksheet enables you to analyze the cost and revenue of training events (classes) for different organizations, by business group and year.
For each sponsoring organization, what are the actual and budgeted training costs?
How much revenue is generated during a year?
This worksheet does not use parameters.
This worksheet enables you to analyze the costs and revenue associated with training for different years. You can investigate costs and revenue for a Business Group and sponsoring organization.
What are the training costs and revenues generated for a sponsoring organization by training year?
This worksheet does not use parameters.
This worksheet enables you to analyze the costs and revenue of a training event (classes) for a training center, by business group, sponsoring organization and year.
What are the actual and budgeted training costs for each training center?
How much revenue is generated by each training center by year?
You need to specify values for the following parameters:
Event Training Center Hierarchy
Top Event Training Center
This worksheet enables you to analyze the cost and revenue of training activities for different years. You can investigate by business group, sponsoring organization, and training center.
For each training center, what are the actual and budgeted training costs?
How much revenue is generated for a sponsoring organization by training year?
You need to specify values for the following parameters:
Event Training Center Hierarchy
Top Event Training Center
This worksheet enables you to analyze the cost and revenue of training events (classes) for a training category. You can investigate costs and revenue for a business group, sponsoring organization, and year.
What are the costs involved in running training events (classes) by category?
How much revenue is generated by each category?
This worksheet does not use parameters.
This worksheet enables you to analyze the cost and revenue of training events (classes) in different years. You can investigate costs and revenue for a business group, sponsoring organization, and training category.
What are the costs involved in running training events (classes) for a training category by year?
How much revenue is generated by training events (classes) for a training category by year?
This worksheet does not use parameters.
This worksheet enables you to analyze the cost and revenue of training activities by the competence achieved if a student successfully completes the course.
What are the costs involved in running training events (classes) by year for a training competence?
How much revenue is generated by training events (classes) by year for a training competence?
This worksheet does not use parameters.
This worksheet enables you to analyze the cost and revenue of training activities by competence and year.
What are the costs involved in running training events (classes) for a training competence by year?
Tell me how much revenue is generated by running training events (classes) for a training competence by year.
This worksheet does not use parameters.
Related Topics
Workforce Intelligence for Learning Management Overview
This workbook investigates the total amount of money generated by enrollments in each training class, and allows training classes to be ranked by the enrollment amount generated.
Enrollments for a course may occur using a variety of currencies. The Course Ranking by Amount Workbook can convert foreign currencies to a common currency for reporting purposes. Currencies are converted using exchange rates maintained in a general ledger application.
Enrollments are possible through both OLM and Order Management (OM). This workbook reports on enrollments from both systems to produce a total enrollment amount for each class.
This workbook includes the following worksheet:
Course Ranking by Amount
Which is the most profitable training class?
Which is the least profitable training class?
What is the total enrollment amount generated within a given period of time?
You must specify values for some of the following parameters:
Category
Class start date
Class end date
Reporting currency
Exchange rate
Training class status
Order header status
Order line status
Training center hierarchy
Top training center
The worksheet uses the following calculations:
Class days
Calculates the page item Class Days, based on the Class Duration in days multiplied by the total number of enrollments.
Class days – internal
Calculates the page item, Class Days--Internal, based on a sum of Total Internal Enrollments multiplied by the Class Duration.
Class days – external
Calculates the page item, Class Days--External, based on a sum of Total External Enrollments multiplied by the Class Duration.
Class duration
Calculates the page item, Class Duration, based on the number of days between the Class Start Date and Class End Date.
Reporting currency
Populates the Reporting Currency column with the currency code for the currency being used.
Total amount per class
Populates the page item Total Amount per Class with the sum of Amount per Class.
Total attended amount
Calculates the page item Total Non Attended Amount, based on a sum of Total Amount where the booking status is equal to Attended.
Total enrollments
Calculates the total number of enrollments for each iLearning training class, based on a sum of Places Booked per Class.
Total external enrollments
Populates the variable Total External Enrollments, based on a sum of Places Booked for external bookings only.
Total internal booking amount
Populates the page item Total Internal Booking Amount, based on a sum of Internal Booking Amount per Class.
Total internal enrollments
Populates the variable Total Internal Enrollments, based on a sum of Places Booked for internal bookings only.
Total non-attended amount
Calculates the page item Total Non Attended Amount, based on a sum of Total Amount where the enrollment status is not equal to Attended.
Total OM amount per class
Calculates the page item, Total OM Amount per Class, based on a sum of OM Amount per Class.
Total OTA amount per class
Calculates the page item, Total OTA Amount per Class, based on a sum of OTA Amount per Class.
Related Topics
Workforce Intelligence for Learning Management Overview
This workbook investigates the time utilization and success rate of training classes.
To calculate the time utilization of the training classes, the report divides the total number of students confirmed in the class by the maximum number of students allowed to enroll in the class.
To calculate the success rate of the training class the report divides the total number of successful students by the total number of students confirmed in the class.
This workbook includes the following worksheets:
By Sponsoring Organization
By Sponsor Organization and Year
By Training Course
By Training Course and Year
By Training Center
By Training Center and Year
By Training Category
By Training Category and Year
By Competence
By Competence and Year
The workbook uses the following calculations:
Success Rate
Success rate is calculated as a number of successful training hours delivered to external students divided by the total number of training hours delivered to external students, where:
The number of successful training hours per class is the number of successful external students enrolled, multiplied by the class duration.
The total number of training hours delivered to external students for a class is the total number of external students enrolled in the class, multiplied by the class duration in hours.
Successful Hours
This calculation is based on the number of Training Hours multiplied by the number of successful students.
Utilization
This calculation is based on the Training Hours Delivered divided by the Training Hours Offered.
Hours Delivered
This calculation is based on the number of training hours required by the class multiplied by the number of enrolled students.
Hours Offered
This calculation is based on the number of training hours required by the class multiplied by the maximum number of attendees.
These worksheets use classes to calculate success. For a class to be included it must:
Have an end date prior to the present date.
Have a status of Normal or Closed, if the class is scheduled.
Not be Cancelled.
The hours of a class are calculated using a predefined Oracle FastFormula. Depending on how you record the duration of classes, you may need to customize this formula. See Setting Up and Customizing Training Hours, Deploy Strategic Reporting (HRMSi)
In addition to displaying information you have set up in OLM and HRMS, the Training Success workbook calculates the following:
Hours Offered
The total number of training hours for all relevant classes multiplied by the number of places available in all relevant classes.
Hours Delivered
The total number of training hours of all the relevant classes multiplied by the number of places filled by students in these classes.
Hours Received
The total number of training hours employees have attended for all relevant training classes.
Successful Hours
If a student is recorded as successfully having attended the class, then the employee's hours for this class are recorded as successful hours.
In the workbook, the successful hours are the total number of successful hours for all relevant classes.
Utilization %
The total hours delivered as a percentage of the hours offered. For example, if 5 hours were delivered, and 10 hours were offered, then the utilization percentage would be 50%.
Success Rate %
Successful hours delivered as a percentage of the total hours delivered. For example, if 10 hours were delivered, and 8 hours were successful, the success rate would be 80%.
This worksheet enables you to investigate the training success rate of training classes for different sponsoring organizations.
What is the training utilization rate by sponsoring organization for a year?
What is the training success rate by sponsoring organization for a year?
This worksheet has no parameters.
This worksheet enables you to investigate the training success rate of training classes for a sponsoring organization for each year.
What is the training utilization rate for a sponsoring organization by year?
What is the training success rate by sponsoring organization by year?
This worksheet has no parameters.
This worksheet enables you to investigate the success rate of different training courses. You can investigate courses by year and sponsoring organization.
What is the training utilization rate by training course for a year?
What is the training success rate by training course for a year?
This worksheet has no parameters.
This worksheet enables you to investigate the success rate of courses each year. You can investigate courses by business group and course.
What is the training utilization rate for a training course by year?
What is the training success rate for a training course by year?
This worksheet has no parameters.
This worksheet enables you to investigate the training success rate of different training centers, by business group and year.
What is the training utilization rate by training center for a class year?
What is the training success rate by training center for a class year?
You need to specify values for the following parameters:
Training center hierarchy
Top training center
This worksheet enables you to investigate the training success rate of a training center over a number of years. You can analyze success by business group and training center.
What is the training utilization rate for a training center by training year
What is the training success rate for a training center by training year?
You need to specify values for the following parameters:
Training center hierarchy
Top training center
This worksheet enables you to investigate the training success rate of classes by training category. You can investigate different training categories for a business group and year.
What is the training utilization rate by training category for a training year?
What is the training success rate by training category for a training year?
You need to specify values for the following parameters:
Training center hierarchy
Top training center
This worksheet enables you to investigate the training success rate of a training class in different years. You can analyze training success for a business group and training category.
What is the training utilization rate for a training category by year?
What is the training success rate for a training category by year?
You need to specify values for the following parameters:
Training center hierarchy
Top training center
This worksheet enables you to investigate the success rate of a training course by competencies. You can investigate competencies for a sponsoring organization and year.
What is the training utilization rate by training competency for a class year?
What is the training success rate by training competency for a class year?
You need to specify values for the following parameters:
Training center hierarchy
Top training center
This worksheet enables you to investigate the training success rate of training activities for a competence over a number of years. You can investigate a competence for each sponsoring organization.
What is the training utilization rate for a training competence by class year?
What is the training success rate for a training competence by class year?
You need to specify values for the following parameters:
Training center hierarchy
Top training center
Related Topics
Workforce Intelligence for Learning Management Overview
The Training Success (Organization Hierarchy) Status Analytics workbook investigates how successfully employees in different organizations and geographical areas are attending training courses.
How successful is employee training across different organizations or geographical areas?
Which organization is the most successful at training?
Which geographical area is the least successful at training?
Before running the worksheets you must enter a value for the following parameters:
Start Date
End Date
Organization Hierarchy
Top Organization
Rollup Organizations – Yes/No
Area (Geography)
Country (Geography)
Region (Geography)
Location (Geography)
Job Category
Job Name
Grade Name
Position Name
This workbook has the following worksheets:
By Organization
By Geography Area
The worksheets display one row for each grouping. For example, the By Organization worksheet displays one row per organization.
All worksheets contain the following columns:
A grouping column
The heading depends on the selected worksheet; for example, in the By Organization worksheet, the heading is Organization.
Attendees
The number of attendees on training courses for each group.
Successful Attendees
The number of successful attendees of training courses for each group.
Success Rate Percent
Displays the number of successful attendees as a percentage of the total number of attendees.
Related Topics
Workforce Intelligence for Learning Management Overview
The Training Success (Organization Hierarchy) Trend Analytics workbook investigates how successfully employees are attending training courses over time.
Is the training in my enterprise become more or less successful over time?
Before running the worksheets you must enter a value for the following parameters:
Start Date
End Date
Organization Hierarchy
Top Organization
Rollup Organizations – Yes/No
Area (Geography)
Country (Geography)
Region (Geography)
Location (Geography)
Job Category
Job Name
Grade Name
Position Name
This workbook has the following worksheets:
By Year
By Semi Year
By Quarter
By Bi Month
By Month
The worksheets display one row for each time period. For example, the By Month worksheet displays one row per month.
All worksheets contain the following columns:
Start Date
The start date of the time period.
End Date
The end date of the time period.
A time period column
The heading depends on the selected worksheet; for example, in the by Year worksheet, this column heading is Year.
Attendees
The number of attendees of training courses for each time period.
Successful Attendees
The number of successful attendees of training courses for each time period.
Success Rate Percent
Displays the number of successful attendees as a percentage of the total number of attendees.
Related Topics
Workforce Intelligence for Learning Management Overview
The Employee Training Attendance Success (Organization Hierarchy) Template Analytics workbook provides two worksheets, one for investigating training success over yearly periods, the other providing a detailed analysis of training success in the workforce. These worksheets help you to create reports to analyze the success of your training courses. Training success is defined as the percentage of training courses that are successfully completed.
Before running the worksheets you must enter a value for the following parameters:
Start Date
End Date
Organization Hierarchy
Top Organization
Rollup Organizations – Yes/No
Area (Geography)
Country (Geography)
Region (Geography)
Location (Geography)
Job Category
Job Name
Grade Name
Position Name
This workbook includes the following worksheets:
By Year
By Detail
The By Year worksheet enables you to see training success for each year.
This worksheet contains the following columns:
Start Date
The start date of the time period.
End Date
The end date of the time period.
Year
The time period for which this worksheet is run.
Attendees
The number of attendees on training courses for each group.
Successful Attendees
The number of successful attendees on training courses for each group.
Success Rate Percent
Displays the number of successful attendees as a percentage of the total number of attendees.
The Detail worksheet calculates the training success rates for training classes with the same start and end dates, for attendees in each organization, location, job, grade, and position.
This worksheet contains the following columns:
Training Class Start Date
The date the class started.
Training Class End Date
The date the class ended.
Attendees
The number of attendees of classes with the same start and end dates, who are in the same organization, location, job, grade, and position, calculated using the selected workforce measurement value.
Successful Attendees
The number of attendees successfully completing the training class, for each organization, location, job, grade, and position, calculated using the selected workforce measurement value.
Success Rate Percent
Displays the number of successful attendees as a percentage of the total number of attendees.
Organization
The organization of the attendees.
Location
The location of the attendees.
Job
The job held by the attendees.
Grade
The grade held by the attendees.
Position
The position of the attendees.
Related Topics