Hello all,
We have a need to pull a report/query that includes the following data:
I've tried lists an output sets but not all fields are available. Would this better as a SQL query? If so, what are the primary tables that contain this data? I've looked at the "T_" tables, via SSMS, and view tables. But, I think the need for the "initiator" has me hung up.
Any suggestions?
Thanks,
Charles
Hi Charles,
You might also be interested in looking at the Reporting View: BI.VT_ORDER_DETAIL? It has most of what you're after in one place. BI.VT_CUSTOMER also provides easy access to customer information in one place. These reporting views are enhanced as needed with every version release.
https://community.tessituranetwork.com/tessitura_software_forums/f/tessitura_shared_reports-9/18887/tessitura-analytics---new-views
Best,Chris
Chris WallingfordDirector, Business IntelligenceTessitura NetworkOffice +1 888.643.5778 ext 553chris.wallingford@tessituranetwork.com
Thanks, Chris.
I did take a look at the BI View tables but wasn't sure about the recency of the data. I appreciate you including the link to the new views. Much appreciated!
The BI Views query the live Tessitura database tables, so they'll produce up-to-the-moment data.