Non-TM Venues Report
- Kaitlyn Niemann (Unlicensed)
- Albert Saludaga
- Philip Prieto Laurente
Requirements and Purpose
The purpose of the report is to return all upcoming live productions at venues that have not had a TM event.
Report Definition
Stakeholders
Kaitlyn Niemann
Cody Honeyman
Mark Shaver
Author
Kaitlyn Niemann
Subject matter expert(s)
Cody Honeyman
April Gahuman
Presentation Medium
SSRS
Fields (data)
Pricer
Event
Venue
Event Date
GetIn
Market Inventory
Current Inventory
Current Sold
Current Cost
Current Sales
Current Profit
Last Invoice Margin
Last Invoice Time
Highest Vendor
Sales on Vendor
Venue Tickets On Hand Quantity
Venue Tickets Sold
Venue Tickets On Hand Cost
Venue On Hand Potential Revenue
Venue On Hand Gross Profit
Venue On Hand Gross Margin
Data source(s)
The data gathered from this report is from Eibo-215 Database and STG Database. Using the stored procedure sr_GetNonTmVenues.
eiboxoffice.dbo
dbo.Production
dbo.TicketGroup
dbo.SellOrderTicketGroup
dbo.SellOrder
dbo.Ticket
dbo.Event(Host and Opponent Events)
dbo.Venue
STG
stg.users.pricerevents
stg.def.categories
stg.users.users
Calculations
Column Name | Data Type | Calculation | Description |
|---|---|---|---|
Event Date | Date | =tg.eventdate+ISNULL(tg.eventtime,0) | Combines Date and Time fields |
GrossQuantity | Numeric | =SUM(tg.Quantity) | Quantifies Total tickets purchased at a given venue. |
GrossExpired | Numeric | =SELECT | Quantifies number of tickets invoiced out as expired at a given venue. |
CurQuantity | Numeric | =SELECT | Quantifies number of tickets in inventory for a given production. Nullable. |
SolQuantity | Numeric | =SELECT | Quantifies number of sold tickets previously in inventory for a given production. Nullable. |
GrossCost | Numeric | =SUM(tg.AverageTicketCost*tg.Quantity) | Quantifies total cost of all purchased tickets at a given venue. |
GrossSale | Numeric | =SUM(st.TotalTicketPrice) | Quantifies total revenue of all sold tickets at a given venue. |
Parameters
Filters
@Pricer (varchar)
Left blank returns all values.
Search by pricers Last name.
@Event (varchar)
Left blank returns all values.
Search values must match eibo.
@venue (varchar)
Left blank returns all values.
Search values must match eibo.
@startdate
beginning of date search range.
Default current date.
@enddate
end of date search range.
Default 1 week from current day.
Grouping
Primary Query: N/a
Sub queries: ProductionID, VenueID
Intentions for printing vs. online viewing
The report is delivered via TBPortal
This report can be accessed here: .45/.210 SSRS>Asset>Non-TM Venues
Intended delivery mechanism (run on demand vs. delivered by subscription)
Run on demand.
Future maintenance tasks or manually maintained items
Pricer assignments via Pricer Admin page.
Results
Data Accuracy
N/a
Limitations
Want to eventually add autofill for each search field. By default, defining a data set in SSRS will create a list for users to select. Given the sheer volume of events, this is not a viable solution in my opinion.