Page History

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

This domain contains attendance statistics and corresponds to the view D_ANALYTICS_ATTEND_V1_0 in which:

1 record = Usage (and not sale) of a given ticketing product by persons located within a given area and entitled to the same tariff within a timeframe of 15 minutes 1 movement with information related to:

  • The considered related product

  • The related ticket (if any)
  • The date-time at which the ticket (if any) has been checked the first time considered timeframe

  • The considered tariff

  • The geographical area (accuracy level: postal code) of the ticket holder

  • Sales channel

A record is identified in a unique way by means of the following attributes: T_AUDIENCEMOVEMENT_SUB_CAT_ID, T_ITEM_ID, T_SALES_CHANNEL_ID, T_PROMOTION_ID,, T_TIMESLOT_ID, VISITGROUP_ID. The attributes T_PROMOTION_ID,, T_TIMESLOT_ID, VISITGROUP_ID can be null.

In case of a performance or a match, T_ITEM_ID can be replaced by the couple (T_PERFORMANCE_ID, T_SEAT_CAT_ID).

This domain is available since Matterhorn V3 and has been refactored during Whymper V1.

Domain's columns description

The following link contains more information on the data of the domain: D_ANALYTICS_ATTEND

Important remarks

  • This domain has been significantly refactored during Whymper V1 in order to improve the performances of the update process. Previously, it was containing pre-aggregated data. More precisely, before Whymper V1, a record was describing the usage (and not sale) of a given ticketing product by persons located within a given area and entitled to the same tariff within a timeframe of 15 minutes The data contained in this domain aren't aggregated anymore.
  • This design change at domain level has an impact on the BI developpers but has no consequences on the reporting tool. Indeed, the reporting tool performs the aggregations that was previously performed by the domain itself.