Training and Education by Organizational Assignment

Technical Name: 0PE_C01_Q010

Based on the InfoCube: 0PE_C01

Use

This query compares event bookings (both attendances and cancellations) per organizational unit for the current year with bookings per organizational unit for the previous year. The query also displays the difference expressed as a percentage and as an absolute value.

You can further differentiate the evaluation using the free characteristics by selecting line characteristics to suit your requirements.

Filter

InfoObject

Description

0ATTENDEETY

Attendee Type

The filter Attendee type is delivered empty in the standard system. Before you can use the filter in your evaluations, you must assign the internal attendee types (e.g. 'Person') you want to use as values to the characteristic Attendee type.

Free Characteristics

InfoObject

Description

0EVENTGROUP

Business Event Group

0EVENTTYPE

Business Event Type

0EVENT

Business Event

0ATTENDEETY

Attendee Type

0ATTENDEE

Attendee

0PERSON

Person

0EMPLOYEE

Employee

0CO_MST_AR

Controlling Area of Master Cost Center

0MAST_CCTR

Master Cost Center

0GENDER

Gender

0AGE

Age in Years

Rows

InfoObject

Description

0ORGUNIT

Organizational Unit

Columns

InfoObject

Description

0QT_PE_001

Comparison Previous Year/Current Year

0C_PE_001

Total Bookings

0CANCEL_NO

Number of Cancellations; Display hidden

0BOOKING_NO

Number of Attendances; Display hidden

You can hide the key figures used in a query if required. You do so by calling Characteristics with the right mouse button and selecting Hide. Similarly, you can display key figures that are hidden in the standard system by deactivating the Hide option.