Pricer Portfolio -Admin

Requirements and Purpose

Report Definition

Allow viewer/s of all events sales performance

1. Stakeholders
   a. Mark Shaver

2. Author

   1.  

3. Subject matter expert(s)

   1. Juvil Soriano

   2. April Gahuman

   3. Jhon Cabalejo

   4. Department employee

4. Data source(s)

   1. dbo.TicketGroup

   2. dbo.BuyOrderTicketGroup

   3. dbo.BuyOrder

   4. dbo.SellOrderTicketGroup

   5. dbo.SellOrder

   6. dbo.Event

   7. dbo.Venue

   8. dbo.Region

   9. dbo.Production

   10. stg.users

   11. stg.pricerevents

5. Presentation Medium

   1. SSRS Reporting

6. Fields (data)

   1. Pricer

   2. Category

   3. Event Name

   4. Venue

   5. Venue Cap

   6. Date/Time

   7. Inventory

   8. Sold Qty

   9. % Sold

   10. Mkt Qty

   11. Get-In

   12. Sales

   13. Total Cost

   14. Margin

   15. Last PO

   16. Last Invoice

   17. Days Till Event

   18. Top Sales Channel

Calculations

Parameters

1. Filters

   1. Pricer

   2. Category

   3. Event Name

   4. Venue

   5. Venue Cap

   6. Date/Time

   7. Inventory

   8. Sold Qty

   9. % Sold

   10. Mkt Qty

   11. Get-In

   12. Sales

   13. Total Cost

   14. Margin

   15. Last PO

   16. Last Invoice

   17. Days Till Event

   18. Top Sales Channel

2. Intentions for printing vs. online viewing

   1. The report is delivered via Purchases

   2. This report can be accessed here: Purchases→ Purchase Analysis → Pricer Portfolio -Admin.

3. Intended delivery mechanism (run on demand vs. delivered by subscription)

   1. On Demand.

4. Future maintenance tasks or manually maintained items

   1. None

Results

1. Data Accuracy

   1. N/a

2. Limitations

   1. N/a

Change Log

1. https://ticketboat.atlassian.net/browse/TIC-1127

Images

Open