E-Learning: Fees by Organizational Assignment (SAP Analytics)

Query Query: 0LSO_C01_Q0200

This query shows for a selected period the costs, by organizational unit, of participation in training courses and of cancellation of training courses. It also shows the following information:

  • Total Costs

  • Number of Participants

  • Number of Cancellations

  • Cancellation Costs as a Percentage of Overall Costs

The query is part of the SAP_BW_0ROLE_0021 role (Human Resources Analyst).

Structure

Free Characteristics
Object Type Name Technical Name
Characteristic Characteristic Course Type 0TRAINTYPE
Characteristic Characteristic Calendar Year 0CALYEAR
Characteristic Characteristic Object Type of Course Type 0TRATYPOTYP
Characteristic Characteristic Course 0TRAINING
Characteristic Characteristic Object Type of Course 0TRAINOTYPE
Characteristic Characteristic Delivery Method 0TRAINFORM
Characteristic Characteristic Learner 0LEARNER
Characteristic Characteristic Object Type of Learner 0LEARNERTYP
Variables
Object Type Name Technical Name
Variable Variable Current Calendar Year 0CYear
Variable Variable Organizational Unit (Selection Option, Personalization) 0S_ORG_P
Rows
Object Type Name Technical Name Value Restriction / Calculation
Characteristic Characteristic Organizational Unit 0ORGUNIT

Personalization required

Columns
Object Type Name Technical Name Value Restriction / Calculation
Key Figure Key Figure Number of Attendees or Participants 0BOOKING_NO

Total

Key Figure Key Figure Number of Cancellations 0CANCEL_NO

Total

Key Figure Key Figure Attendance or Participation Fee 0BOOKINGFEE

Total

Key Figure Key Figure Cancellation Fee 0CANCELFEE

Total

Key Figure Key Figure Total Fees 0LSO_C01_CK002

Total

Key Figure Key Figure Percentage Cancellation Fees 0LSO_C01_CK200

Percentage of Total Fees