/
Non-TM Tours

Non-TM Tours

Owned by Kaitlyn Niemann (Unlicensed), created
Last updated: Apr 22, 2024 by Albert Saludaga

Requirements and Purpose

Give a brief description of the purpose of the report and some of the features that the stakeholders have requested.

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. Pricer

    2. eEvent

    3. eVenue

    4. eDate

    5. GetIn

    6. MarketInventory

    7. CurrentInventory

    8. CurrentSOld

    9. CurrentCost

    10. CurrentSales

    11. CurrentProfit

    12. CurrentMargins

Data source(s)

The data from this report is gathered from the Eibo-215 Database, STG Database and Snowflake. Using the stored procedure sr_GetNonTmTours.

  1. 192.168.10.215(eiboxoffice)

    1. dbo.TicketGroup

    2. dbo.Production

    3. dbo.ShareTicketGroup

    4. dbo.SellOrderTicketGroup

    5. dbo.Venue

    6. dbo.Event

    7. dbo.Region

  2. 192.168.10.209(STG)

    1. users.users

    2. user.pricerevents

  3. dbo.view

  4. Snowflake

Calculations

Column Name

Data Type

Calculation

Description

Column Name

Data Type

Calculation

Description

CurrentCost

Currency

=ISNULL(ci.CurrentCost,cs.CurrentCost)

Returns Current Cost

CurrentProfit

Currency

=cs.CurrentSales-ISNULL(ci.CurrentCost,cs.CurrentCost

Current Profit

Current Margins

Percentage

=CASE WHEN ISNULL(cs.CurrentSales,0) = 0 THEN 0 ELSE (cs.CurrentSales-ISNULL(ci.CurrentCost,cs.CurrentCost)) /cs.CurrentSales END

Returns current profit margins if sales are greater than 0.

Parameters

  1. Filters

    1. Pricer

    2. Tour Start Date

    3. Tour End Date

    4. Event

    5. Venue

  2. Grouping

    1. By Production

  3. Intentions for printing vs. online viewing

    1. The report is delivered via SSRS

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

    1. On Demand

  5. Future maintenance tasks or manually maintained items

    1. N/a

Results

  1. Data Accuracy

    1. QA

      1. Report can be found under 192.168.10.45\SSRS Reports\Asset\Non-TM Tours

      2. Report can be found under 192.168.10.45\SSRS Reports\Asset\Non-TM Tours

    2. Validation

      1. Eibo Marketplace

        1. Compare current inventory to my market view.

      2. Eibo Income by Event Report.

        1. Compare Income by Event to line item in report.

  2. Limitations

    1. N/a

Change Log

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

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

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

  4. https://ticketboat.atlassian.net/browse/SP-352

Images



Related content