Percentage of Women

Technical name: 0PA_C01_Q0113

Based on InfoCube: 0PA_C01

Use

This query displays the percentage of women, that is, the percentage of female employees in the headcount in the last 12 months and the last four quarters (end of each quarter). Different organizational data can be used for the report (see Free Characteristics).

Filters

InfoObject

Description of the InfoObject (and Restriction or Calculation Formula)

0EMPLSTATUS

Employment Status

0EMPLGROUP

Employee Group

When the query is called, the Employment Status characteristic filters all employees with employment status 3 (= active) and the Employee Group characteristic filters all employees who belong to employee group 1 (= active). That is, the query only displays results for active employees.

Free Characteristics

InfoObject

Description

0MAST_CCTR

Master Cost Center

0EMPLSGROUP

Employee Subgroup

0EMPLOYEE

Employee

Variables Used

Variable

Description

0S_ORG_P

Organizational Unit

Using this variable you can display and evaluate organizational units in a personalized way. If you use the personalization function, you can restrict or expand the list of organizational units, displaying some or all of the organizational units for which you are authorized.

See also: Personalization in Human Resources (HR) Web Cockpits

Rows

InfoObject

Description

0ORGUNIT

Organizational Unit

Columns

InfoObject

Description of the InfoObject (and Restriction or Calculation Formula)

0PA_C01_QT01

Compare Last 12 Months and 4 Quarters (End of Quarter)

0PA_C01_CK003

Percentage of Women

Views

Various views are defined for this query that depict the variants of the query. The views represent technical objects and act as a data provider for the Web templates used for BW Web Reporting.

View

Description

0PA_C01_Q0113_V01

Percentage of Women: Current (Without Drilldown)

0PA_C01_Q0113_V02

Percentage of Women: Current

0PA_C01_Q0113_V03

Percentage of Women: Current and Previous Month

0PA_C01_Q0113_V04

Percentage of Women: 4 Quarters

0PA_C01_Q0113_V05

Percentage of Women: 12 Months

The views each evaluate specific aspects of the reporting options available in the query:

·        0PA_C01_Q0113_V01 Displays the absolute percentage of women in the current (just finished) calendar month.

·        0PA_C01_Q0113_V02 Displays the percentage of women in the current (just finished) calendar month. The report is run according to organizational units.

·        0PA_C01_Q0113_V03 Displays the percentage of women in the current (just finished) calendar month and previous month. The report is run according to organizational units.

·        0PA_C01_Q0113_V04 Displays the percentage of women at the end of the last four quarters (that is, the values of the last months of the last three quarters and the value of the last finished month in the current quarter). The report is run according to organizational units.

·        0PA_C01_Q0113_V05 Displays the percentage of women in the last 12 months. The report is run according to organizational units.