Learning Statistics - More Details

Query Query: 0LSO_MP03_Q0001_D17

This query enables users to deep dive into the details. This query is triggered when the user clicks the More Details button in View 1 of the dashboard. The input for this query is the selected organizational unit from the breadcrumb Calendar Year/Month from the Calendar Year/Month drop down. This query has many free characteristics which enable users to take better decisions.

Structure

Filters
Object Type	Name	Technical Name	Value Restriction / Calculation
Characteristic	Organizational Unit	`0ORGUNIT`	Variable Organizational Unit (`0H_TMC_ORGUNIT`)
Characteristic	Calendar Year/Month	`0CALMONTH`	Variable Calendar Year/Month (`0SPL_CYM`)

Free Characteristics
Object Type	Name	Technical Name
Characteristic	Calendar Year/Month	`0CALMONTH`
Characteristic	Career Type Level	`0CAREERLVL`
Characteristic	Career Type	`0CAREERTYPE`
Characteristic	Cost Center	`0COSTCENTER`
Characteristic	Cancellation Reason	`0C_REASON`
Characteristic	Employee	`0EMPLOYEE`
Characteristic	Fee Indicator	`0EVCOSTINFO`
Characteristic	Document Status	`0EVDOCSTAT`
Characteristic	Functional Area	`0FUNCAREA`
Characteristic	Position	`0HRPOSITION`
Characteristic	Job	`0JOB`
Characteristic	Job Family	`0JOB_FAMILY`
Characteristic	Learner	`0LEARNER`
Characteristic	Master Cost Center	`0MAST_CCTR`
Characteristic	Nationality	`0NATION`
Characteristic	Organizational Unit	`0ORGUNIT`
Characteristic	Course Passed	`0PASSED`
Characteristic	Performance Scale	`0PERF_SCALE`
Characteristic	Performance Value	`0PERF_VL_C`
Characteristic	Language	`0PERSLANGU`
Characteristic	Personnel Area	`0PERS_AREA`
Characteristic	Personnel Subarea	`0PERS_SAREA`
Characteristic	Potential Scale	`0POT_SCALE`
Characteristic	Potential Value	`0POT_VL_C`
Characteristic	Receiver Cost Center	`0RECV_CCTR`
Characteristic	Indicator for Canceled Courses	`0TRAINCANC`
Characteristic	Indicator for Followed-Up Courses	`0TRAINFLUP`
Characteristic	Delivery Method	`0TRAINFORM`
Characteristic	Course Group	`0TRAINGROUP`
Characteristic	Course	`0TRAINING`
Characteristic	Course Location	`0TRAINLOCA`
Characteristic	Course Type	`0TRAINTYPE`

Variables
Object Type	Name	Technical Name
Variable	Organizational Unit	`0H_TMC_ORGUNIT`
Variable	Calendar Year/Month	`0SPL_CYM`

Rows
Object Type	Name	Technical Name	Value Restriction / Calculation
Characteristic	Talent Group	`0TALENTGRP`	—

Columns
Object Type	Name	Technical Name	Value Restriction / Calculation
Key Figure	Number of Employees Who Took At Least One Course	`0LSO_MP03_RK001`	See the documentation for the key figure
Key Figure	Number of Employees	`0LSO_MP03_CK001`	See the documentation for the key figure
Key Figure	Number of Employees Who Did Not Take Any Course	`0LSO_MP03_CK002`	See the documentation for the key figure
Key Figure	Total Person Days of Training	`0LSO_MP03_CK018`	See the documentation for the key figure
Key Figure	Average Person Days of Training	`0LSO_MP03_CK041`	See the documentation for the key figure
Key Figure	Total Fee (Total Participation Fee+Total Cancellation Fee)	`0LSO_MP03_CK042`	See the documentation for the key figure
Key Figure	Average Cost of Training	`0LSO_MP03_CK044`	See the documentation for the key figure
Key Figure	Total Cost of Training	`0LSO_MP03_CK046`	See the documentation for the key figure