Our groups have only been Live in Tessitura for about 4 years so we really loved that we could get ticket history reporting in T-Stats. We're just now starting to use Analytics and cannot seem to figure out how to do it there, though. Any tips/hints welcome. And if this just isn't possible, I'd love to hear any workarounds you know of?
Thanks!
Hi Mindy, Take a look at the "T_DEFAULTS Entries for Tessitura Analytics" section of Tessitura v15 documentation. You can import ticket history via a T_DEFAULTs parameter:
John, should data in t_ticket_history be mutually exclusive of orders in Tessitura? What happens if you have current orders in both t_ticket_history and t_order?
Is it possible that this setting just brings in the "order_no = 0" rows of T_TICKET_HISTORY?
The process is mostly handled in the Tessitura database view, [BI].[VT_DW_TICKET_HISTORY] which returns T_TICKET_HISTORY where the order_no is not in Tessitura, when the T_DEFAULTS field for 'Include Imported Tkt History' is set to Yes. The BI view respects the Ticketing Fiscal Years Back setting in T_DEFAULTS as well.