Hi Friends!
We use ticket original paid amount in analytics for subscription tracking and while the analytics reports are working great I could streamline a few processes if I could get to this number in SSMS. Would anyone be able to provide insight in how this number is found by Analytics and if it's easy enough to get in SSMS? From here: https://www.tessituranetwork.com/Help_System_v151h/Tessitura.htm#Tessitura%20Analytics/Data%20Dictionary/Seats%20and%20Tickets%20Cube.htm
Thanks!
The BI views BI.VT_ORDER_DETAIL might have what you want and if you have a look at the build of it it'll put you on the right track