Attendance and Cancellation Rate

Technical Name 0PE_C01_Q003

Based on the InfoCube: 0PE_C01

Use

This query displays the attendance and cancellation rate from the previous year compared with that of the current year. The key figure Attendance per Cancellation displays the number of attendances per one cancellation, thus indicating the ratio of cancellations to attendances. The key figure Cancellation Rate, on the other hand, indicates the percentage of cancellations to total bookings.

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

Free Characteristics

InfoObject

Description

0EVENTTYPE

Business Event Type

0EVENT

Business Event

0ATTENDEETY

Attendee Type

0ATTENDEE

Attendee

Rows

InfoObject

Description

0EVENTGROUP

Business Event Group

Columns

InfoObject

Description

&0CYEAR&

Current Calendar Year

0QT_PE_005

Attendance and Cancellation Rate