/
Season Summary

Season Summary

Owned by Kaitlyn Niemann (Unlicensed), created
Last updated: Apr 26, 2024 by Albert Saludaga
1 min read

Requirements and Purpose

Report to view performance by season. Has two views. One for calculations by seat, one for calculations by opponent/date

Report Definition

  1. Stakeholders

    1. @Mark Shaver

    2. Alex Goldberg

  2. Author

    1. @Kaitlyn Niemann (Unlicensed)

  3. Subject matter expert(s)

    1. Alex Goldberg

  4. Presentation Medium

    1. SSRS

  5. Fields (data)

    1. EventName

    2. Opponent/SeatSection

    3. EventDate/SeatRow

    4. Inventory

    5. Sold

    6. Sales

    7. Cost

    8. Profit

    9. Margins

Data source(s)

The data gathered in this report is from the Eibo-215 Database and the STG Database. Using the stored procedure sr_getSeasonSummaryBySeats.

  1. eiboxoffice

    1. dbo.Event

    2. dbo.TicketGroup

    3. dbo.SellOrderTicketGroup

  2. stg

    1. users.pricerevents

    2. def.categories

Calculations

Column Name

Data Type

Calculation

Description

Column Name

Data Type

Calculation

Description

Margins

Currency

=(Sales-Cost)/Sales



Profit

Currency

=Sales-Cost



Parameters

  1. Filters

  2. Grouping

    1. By Primary Event

      1. By SeatSection/SeatRow

  3. Page breaks (Dashboards/Worksheets/Etc.)

  4. Intentions for printing vs. online viewing

    1. The report is delivered via SSRS

    2. This report can be accessed here:

      1. Production: 192.168.10.210\SSRS\Asset\Season Summary

      2. QA: 192.168.10.45\SSRS\Asset\Season Summary

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

    1. Static email image delivery

    2. Every 24 hours from 7:00 AM to 7:00 AM on Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, and Saturday

  6. Future maintenance tasks or manually maintained items

    1. None

Results

  1. Data Accuracy

    1. N/a

  2. Limitations

    1. Currency is stored in eibo database up to 4 decimals, can cause minor fluctuations in cost over large aggregates

  3. Validation Method

    1. Eiboxoffice > Reports > Sales & Income > Income by Event Report

Change Log

  1. https://ticketboat.atlassian.net/browse/SP-294

  2. https://ticketboat.atlassian.net/browse/SP-298

  3. https://ticketboat.atlassian.net/browse/SP-309

Images





Related content