Training and Event Management

Technical Name: 0PE_C01

Use

The InfoCube Training and Event Management (0PE_C01) contains all transaction data relevant to business event bookings and cancellations loaded from the connected source system(s). The data in the InfoCube is provided by the InfoSources Attendance (OHR_PE_1) and Cancellation (OHR_PE_2).

The InfoCube contains the general key figures Number of Cancellations (0CANCEL_NO), Number of Attendances (0BOOKING_NO), Cancellation Fees (0CANCELFEE), Attendance Fees (0BOOKINGFEE), Business Event Duration in Hours (0EVHOURS), Business Event Duration in Days (0EVDAYS), and Business Event Costs (0EVENTCOSTS). The standard system also provides calculated key figures (such as Average Cancellation Fees) and restricted key figures. These are key figures that depend on certain characteristics (such as Billed Attendance Fees, Number of Internal Attendees).

The following time dimensions are available for evaluations: calendar day, calendar year, calendar year/quarter and calendar year/month.

A number of structures are provided with the InfoCube in the standard system. These structures contain the key figures in combination with certain calculation rules. The structures give you swift and easy access to frequently used evaluation structures (such as Comparison of Previous/Current Year). The results are displayed as either absolute or percentage values.

In the update rules, numerous fields are imported from the master data tables and written into the InfoCube as characteristics. For this reason, it is necessary that the master data is loaded and activated before the InfoSources.

InfoSources

OHR_PE_1: Attendance

Attendance Cancellation

Characteristics

You can display the available navigation attributes of a characteristic if you position the cursor on the characteristic in question and right click Properties.

InfoObject

Description

0EVENTGROUP

Business Event Group

0EVENTTYPE

Business Event Type

0EVENT

Business Event

0EVBEGDA

Business Event Start Date

0EVENDDA

Business Event End Date

0ATTENDEETY

Attendee Type

0ATTENDEE

Attendee

0EVCOSTINFO

Fee Indicator

0CO_AREA

Controlling Area

0RECV_CCTR

Receiver Cost Center

0CANC_DATE

Cancellation Date

0C_REASON

Cancellation Reason

0EMPLOYEE

Employee

0PERSON

Person

0PERS_AREA

Personnel Area

0PERS_SAREA

Personnel Subarea

0GENDER

Gender

0NATION

Nationality

0PERSLANGU

Language

0AGE

Age in Years

0CO_MST_AR

Controlling Area of Master Cost Center

0MAST_CCTR

Master Cost Center

0ORGUNIT

Organizational Unit

0JOB

Job

0HRPOSITION

Position

0EVDOCSTAT

Document status

0EXTORG

Company

0EXTPERS

External Person

The characteristic Age in Years (0AGE) is a calculated characteristic: it calculates an employee's age at the end of a period.

The characteristic Attendee Type (0ATTENDEETY) is used to differentiate and evaluate internal and external attendees. This depends on what attendee types you have defined as internal and external. You must define attendee types before you can evaluate employee data, for example.

Characteristic Employee vs. Person: A person can have multiple assignments as an employee. To be able to distinguish between work relationships (characteristic Employee 0EMPLOYEE) and real persons (characteristic Person 0PERSON), a person is deemed an attribute of an employee.

If hierarchies exist for the InfoObjects Business Event Group (0EVENTGROUP), Organizational Unit (0ORGUNIT) and Master Cost Center (0MAST_CCTR), you can activate these with ® Characteristics. This allows you to depict hierarchical, multi-level aggregations.

In Training and Event Management, the hierarchical display feature is only available for business event groups that have event dates for which bookings have actually been made.

SAP does not deliver hierarchies for Age in Years. However, you can define your own hierarchies for the characteristic Age in Years (0AGE). The intervals in the structure are user-definable. You can, for example, define 5-year intervals (25-30 years; 30-35 years and so on). This enables you to define hierarchies that suit company-specific requirements and best reflect the age structure in your company.

You can switch the presentation hierarchy on and off as required using the Active switch under Presentation hierarchy of the characteristic concerned.

Time Characteristics

The time units used in the InfoCube to calculate a time period are decimal minutes and decimal hours, that is, 100 minutes = 1 hour. So, for example, 1 hour and 20 minutes is equal to 1.30 decimal hours.

InfoObject

Description

0CALYEAR

Calendar Year

0CALQUARTER

Calendar Year/Quarter

0CALMONTH

Calendar Year/Month

0CALDAY

Calendar Day

Key Figures

InfoObject

Description

0BOOKING_NO

Number of Attendances

0BOOKINGFEE

Attendance Fee

0CANCEL_NO

Number of Cancellations

0CANCELFEE

Cancellation Fee

0EVDAYS

Business Event Duration in Days

0EVHOURS

Business Event Duration in Hours

0EVENTCOSTS

Business Event Costs

Restricted Key Figures

Restricted key figures are derived from InfoCube key figures by filtering one or more InfoCube characteristics.

InfoObject

Description

Formula/Restriction

0R_PE_001

Billed Attendance Fees

Key figure Attendance fees, restricted by characteristic Fee indicator

0R_PE_002

Allocated Attendance Fees

Key figure Attendance fees, restricted by characteristic Fee indicator

0R_PE_003

Billed Cancellation Fees

Key figure Cancellation fees, restricted by characteristic Fee indicator

0R_PE_004

Allocated Cancellation Fees

Key figure Cancellation fees, restricted by characteristic Fee indicator

0R_PE_005

Number of Internal Attendees

Key figure Number of attendances, restricted by characteristic Attendee type

0R_PE_006

Number of Internal Cancellations

Key figure Number of cancellations, restricted by characteristic Attendee type

Calculated Key Figures

InfoObject

Description

Formula/Restriction

0C_PE_001

Total Bookings

Key figure Number of attendances + key figure Number of cancellations

0C_PE_002

Total Fees

Key figure Attendance fees + key figure Cancellation fees

0C_PE_003

Average Attendance Fee

Key figure Attendance fees / key figure Number of attendances

0C_PE_004

Average Cancellation Fee

Key figure cancellation fees / key figure number of cancellations

0C_PE_005

Average Total Fees

Total fees / total bookings

0C_PE_006

Revenues

Total fees - business event costs

0C_PE_007

Training Duration in Days

Key figure Training duration in days * key figure number of attendees

0C_PE_008

Training Duration in Hours

Key figure Training duration in hours * key figure number of attendees

Units

The currency unit used to specify and calculate fees and costs in the InfoCube is the target currency US$.

Totals are rounded off to two places after the decimal point.

InfoObject

Description

0CURRENCY

Currency key

0EVCURRCOST

Currency of business event costs

Structures

InfoObject

Description

0QT_PE_001

Comparison of Previous Year/Current Year

0QT_PE_002

4-Quarter Comparison

0QT_PE_003

Average 4 Quarters

0QT_PE_004

Total Bookings

0QT_PE_005

Attendance and Cancellation Rate

0QT_PE_006

Total Fees