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

Query Query: 0LSO_C01_Q0201

This query determines for a training course the number of cancellations for each cancellation reason.

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

Structure

Free Characteristics
Object Type Name Technical Name
Characteristic Characteristic Organizational Unit 0ORGUNIT
Characteristic Characteristic Course Type 0TRAINTYPE
Characteristic Characteristic Calendar Year 0CALYEAR
Characteristic Characteristic Course 0TRAINING
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
Rows
Object Type Name Technical Name Value Restriction / Calculation
Characteristic Characteristic Cancellation Reason 0C_REASON

Columns
Object Type Name Technical Name Value Restriction / Calculation
Key Figure Key Figure Number of Cancellations 0CANCEL_NO