Course Attendance and Cancellations (Web Reporting)

Technical name: 0PE_C01_Q0101

Based on the InfoCube: 0PE_C01

Use

This query allows you to evaluate course attendance and employee cancellations together with any costs incurred in different time views.

Free Characteristics

Info Object

Description

0EMPLOYEE

Employee

0PERS_AREA

Personnel Area

0PERS_SAREA

Personnel Subarea

0MAST_CCTR

Master Cost Center

0EVENTGROUP

Business Event Group

Rows

Info Object

Description of the InfoObject (and Restriction or Calculation Formula)

0ORGUNIT

Organizational Unit

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 what you see, displaying some or all of the organizational units for which you are authorized.

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

Columns

Info Object

Description of the InfoObject (and Restriction or Calculation Formula)

0BOOKING_NO

Number of Attendees

0BOOKINGFEE

Attendance Fee

0CANCEL_NO

Number of Cancellations

 

0CANCELFEE

Cancellation Fee

0CYEAR

Current Calendar Year

0CYEAR-1

Previous Year = Current Calendar Year -1

0CQUART-3

Current Quarter -3

0CQUART-2

Current Quarter -2

0CQUART-1

Current Quarter -1

0CQUART

Current Quarter

Global Views

Several global views are defined for this query that depict the different variants of the query. The global views depict technical objects and act as a data provider for the Web templates that are used for BW Web reporting.

Global Views

Description

0PE_C01_Q0101_V0101

Number of Attendees / Costs (Current Year)

0PE_C01_Q0101_V0111

Number of Attendees (Current Year)

0PE_C01_Q0101_V0121

Attendance Costs (Current Year)

0PE_C01_Q0101_V0201

Number of Cancellations / Costs (Current Year)

0PE_C01_Q0101_V0211

Number of Cancellations (Current Year)

0PE_C01_Q0101_V0221

Cancellation Costs (Current Year)

0PE_C01_Q0101_V0102

Number of Attendees / Costs (Previous Year / Current Year)

0PE_C01_Q0101_V0112

Number of Attendees (Previous Years / Current Year)

0PE_C01_Q0101_V0122

Attendance Costs (Previous Years / Current Year)

0PE_C01_Q0101_V0202

Number of Cancellations / Costs (Previous Year / Current Year)

0PE_C01_Q0101_V0212

Number of Cancellations (Previous Years / Current Year)

0PE_C01_Q0101_V0222

Cancellation Costs (Previous Years / Current Year)

0PE_C01_Q0101_V0103

Number of Attendees / Costs (Last 4 Quarters)

0PE_C01_Q0101_V0113

Number of Attendees (Last 4 Quarters)

0PE_C01_Q0101_V0123

Attendance Costs (Last 4 Quarters)

0PE_C01_Q0101_V0203

Number of Cancellations / Costs (Last 4 Quarters)

0PE_C01_Q0101_V0213

Number of Cancellations (Last 4 Quarters)

0PE_C01_Q0101_V0223

Attendance Costs (Last 4 Quarters)

The global views evaluate specific aspects of evaluation methods available in the query.

The global view Number of Attendees / Costs (Current Year) focuses on the number of attendees and the costs incurred for the evaluated organizational units in the current year.

The global view Number of Attendees / Costs (Previous Year / Current Year) evaluates the same key figures but in a different time view. In this global view, the values for the current month are compared with the values for the same month in the previous year.

For the global view Number of Attendees / Costs (Last 4 Quarters), attendees and the costs incurred are compared with the last four quarters.

Further variants include global views that evaluate the number of cancellations together with the costs incurred and global views that only evaluate one key figure (that is Number of Attendees or Costs or Number of Cancellations or Cancellation Costs) for organizational units (in each case for the three time views available for the query).