Training and Education by Organizational Assignment

Technical name: 0LSO_C01_Q0010

Use

This query compares course bookings (both participation and cancellations) per organizational unit for the current year with bookings per organizational unit for the previous year. The query also displays the difference expressed as a percentage and as an absolute value.

Filters

The internal object type of the learner (e.g. Person) must be assigned as a value to the characteristic Object Type of the Learner.

InfoObject

Description of the InfoObject (and Restriction or Calculation Formula)

0LEARNERTYP

Object type of learner

Free Characteristics

InfoObject

Description

0TRAINGROUP

Course group

0TRAINTYPE

Course type

0TRAINTYPOTYP

Object type of course type

0TRAINING

Course

0TRAINOTYPE

Object type of course

0TRAINFORM

Delivery method

0LEARNER

Learner

0PERSON

Person

0EMPLOYEE

Employee

0CO_MST_AR

Controlling area of master cost center

0MAST_CCTR

Master cost center

0GENDER

Gender

0AGE

Age in years

0TRAINGROUP

Course group

Rows

InfoObject

Description of the InfoObject (and Restriction or Calculation Formula)

0ORGUNIT

Organizational unit

Columns

InfoObject

Description of the InfoObject (and Restriction or Calculation Formula)

0LSO_C01_QT001

Comparison previous year/current year

0LSO_C01_CK001

Total bookings

0BOOKING_NO

Number of attendees or participants

0CANCEL_NO

Number of cancellations