• Replies 9 replies
  • Subscribers 700 subscribers
  • Views 110 views
  • Users 0 members are here
Options
Related

Fees by production season or performance

Sabina Spilkin
$organization

Hi,I am creating a dashboard with a filter for production season or performance and a sum of fees paid. I am using Finance cube and can not find a way to filter by performance. Am I in the right cube?

Thanks, Sabina

Parents
  • $organization

    Hi Sabina,

    Financial data (Transactions and Payments) stored in Tessitura doesn't link fee money to performances. Order fees have already been touched on, but per seat fees as well because the stored transaction is a single amount for the whole order (per fee GL per order) and doesn't store it with a distinction for event (per fee GL per perf per order). So, there's no direct connection in the Tessitura financial data from the fee transaction back to the seats and performances generating the fee revenue.

    The place in Tessitura where the distinction is made for seats and their specific fees resides in the order data rather than the financial data, meaning that if the link between seats and fees were to be included in Analytics anywhere, it would need to be in the Seats and Tickets data source. I can imagine how that enhancement might work and an Idea would help me track interest and use cases.

Reply
  • $organization

    Hi Sabina,

    Financial data (Transactions and Payments) stored in Tessitura doesn't link fee money to performances. Order fees have already been touched on, but per seat fees as well because the stored transaction is a single amount for the whole order (per fee GL per order) and doesn't store it with a distinction for event (per fee GL per perf per order). So, there's no direct connection in the Tessitura financial data from the fee transaction back to the seats and performances generating the fee revenue.

    The place in Tessitura where the distinction is made for seats and their specific fees resides in the order data rather than the financial data, meaning that if the link between seats and fees were to be included in Analytics anywhere, it would need to be in the Seats and Tickets data source. I can imagine how that enhancement might work and an Idea would help me track interest and use cases.

Children