Consolidated vs. Real-time Data Views
Consolidated Data Views
Consolidated views are data views that are periodically normalized (or “crunched”) and made available for reporting. This crunch process is scheduled by default once/day, but the frequency has been increased for some customers to as often as once every half hour. This allows for larger numbers of entities and more complex queries than are available in the real-time views (see below) which are, by nature, simpler. Custom fields are available in consolidated views. Enterprise customers who have significant data should use these views in most cases for performance reasons.
Real-time Data Views
Real-time views are data views that are live queried from the TapOrders system. These data views are more dynamic in nature and thus may perform more slowly. They also tend to be more limited in thier ability to join across data sets such as Line Items with Orders or Flights with Tasks. These types of joined data views are only available in consolidated versions. That said, rea-time views are up to the minute and are helpful for monitoring real-time activities like task assignments. Custom fields are available in these views.
Data Views and Their Descriptions
Flights with tasks (consolidated) A flight-centric report with tasks associated to those flights included. This view will have flight data along with the flight's line item and order attributes available. Selection criteria for dates and filtering are based on flight attributes.
Flights (consolidated) A basic “crunched” flight report.
Line item with tasks (consolidated) A line Item-centric report with tasks associated to those line items. All filtering and selection is done according to line item attributes and status. Can include order and client attributes.
Line items (real-time) A real-time line item query. Can be used if up-to-the-minute data are required. Is limited with filtering, grouping and by performance on large databases. Includes some limited order and client level data.
Line items (consolidated) A basic “crunched” line item report. Includes more grouping options than it’s real-time cousin.
Orders real-time order query (real-time) Can be used if up-to-the-minute data are required. Is limited with filtering, grouping and by performance on large databases. Can include some client data.
Orders with tasks (consolidated) An order-centric consolidated report along with task data associated with those orders. Can include client and line item data but the filtering and querying is primarily based on the order information.
Orders (consolidated) A basic “crunched” line item report. Includes more grouping options than it’s real-time cousin.
Tasks real-time (real-time) A real-time view of task data. Can be used to generate data based on time booked as well as up to the minute assignments.
Orders with line items (real-time) This report shows an as-booked display of line items with order information in real-time. This is the only real-time view that blends data across entities.
Billing report (consolidated) If a customer is using the goals module and pushing goals from TapOrders to goals automatically, then this report will use the link between the TapOrders line item and/or flight and the TapAnalytics performance data that is mapped to the goal to generate a billing report that displays this data together.
Common Use Cases & Widgets
