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!
Mindee Waltz (Past Member)
Are you able to get into Tessitura Analytics? On the right side of the screen do you see the predefined Seats and Tickets Dashboards?
So far, so good, yes :)
To Make Changes to a Dashboard you need to be working on your own copy.
Chris Wallingford
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?
John,
Thank you so much. Good grief I feel stupid. Of course it's a configurable setting. I forgot to go back and re-read the documentation before asking the forums (to be fair, you all on the forums are much more fun to interact with than the documentation [no offense intended, documentation team - you all are great, too)
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.