BI CVW MissedRentals – Overview

Purpose:

This view provides a detailed record of missed rental opportunities, showing which rentals were missed, why, and which staff and store were involved. It helps operations and management identify gaps, track trends, and reduce lost revenue. Join it to the Items view to get more item details.

What’s Included:

• Rental & Customer Info:
  

  • Store where the missed rental occurred.

  • Item name and key.

  • Customer who missed the rental.

  • Item type and quantity.

  • Missed rental amount.
                                                

• Timing & Notes:
  

  • Date of the missed rental.

  • Notes related to the missed rental.
                                       

• Reason & Status:
  

  • Reason name for the missed rental.

  • Inactive flag for the reason (if applicable).
                               

• Staff Info:
  

  • Operator number and name associated with the missed rental.
                         

• Store Info:
  

  • Store name from the parameters file for reference.

How It Works:

• Combines MissedRentals with related reasons, store info, and operators.

• Provides a complete record for each missed rental for reporting and analysis.

Uses:

• Identify frequent causes of missed rentals.

• Track staff or store patterns related to missed opportunities.

• Support operational improvements to reduce lost revenue.

• Monitor customer trends for missed rentals over time.

POR Tables

• MissedRentals 

• MissedRentalReasons 

• ParameterFile

• OperatorId