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	Course Type	`0TRAINTYPE`
Characteristic	Calendar Year	`0CALYEAR`
Characteristic	Object Type of Course Type	`0TRATYPOTYP`
Characteristic	Course	`0TRAINING`
Characteristic	Object Type of Course	`0TRAINOTYPE`
Characteristic	Delivery Method	`0TRAINFORM`
Characteristic	Learner	`0LEARNER`
Characteristic	Object Type of Learner	`0LEARNERTYP`

Variables
Object Type	Name	Technical Name
Variable	Current Calendar Year	`0CYear`
Variable	Organizational Unit (Selection Option, Personalization)	`0S_ORG_P`

Rows
Object Type	Name	Technical Name	Value Restriction / Calculation
Characteristic	Organizational Unit	`0ORGUNIT`	Personalization required

Columns
Object Type	Name	Technical Name	Value Restriction / Calculation
Key Figure	Number of Participants	`0BOOKING_NO`	Total
Key Figure	Number of Cancellations	`0CANCEL_NO`	Total
Key Figure	Participation Fee	`0BOOKINGFEE`	Total
Key Figure	Cancellation Fee	`0CANCELFEE`	Total
Key Figure	Total Fees	`0LSO_C01_CK002`	Total
Key Figure	Percentage Cancellation Fees	`0LSO_C01_CK200`	Percentage of Total Fees