The lottery software provides all authorized users with access to various reports. Some are so-called “online” reports in that the user can specify certain query criteria, such as a date range, game(s), retailer range, retailer category, retailer region, and many others. Others are so-called “end-of-day” reports in that the system automatically generates these reports at the end of each business day and stores them for viewing at a later time.
The ADMIN module consists of a a real-time “dashboard” application that presents certain key metrics and sales figures in real time in various formats, including graphical and tabular. It provides an at-a-glance snapshot of the system such as 1) terminals connected, 2) sales by game for the day/draw, 3) peak transactions per minute, 4) average transactions per minute, 5) latest transactions per minute, 6) peak selling terminals, 7) low selling terminals, and more.
The lottery system comes with a set of standard reports. An example of some of these reports are:
- Draw Sales and Liability Report
- Retailer Sales Report (retailer ID range, Game(s), and date range are user selectable). Customized versions are by region, category, postcode, etc
- Game Sales Report. For given Draw ID range lists all major Draw statistics
- Retailer Balance Report. For given date range shows start balance, sales, payouts, commissions, remittances, end balance etc for each day
- Daily paid/claimed ticket report
- Daily Transaction Summary report
- Daily Retailer Transaction Summary Report
- Daily Cancelled Tickets Report
- Game Transaction Summary
- Taxable (high tier) Winning Tickets Report
- Weekly Retailer Accounting Report
- Weekly Sales Summary Report
- Inactive (lazy) Retailers Report
- Expired Unclaimed Winning Tickets Report
- Instant Ticket Inventory Summary Report (all games)
- Instant Ticket Inventory Detail Report
- Instant Ticket Game Accounting Report
It is normal for custom reports to be required. Dusane will work with the various operations, sales, accounts, and other staff to deliver the reports required to support the local operation.
Dusane’s lottery software is built on a high-performance relational database platform. A separate real-time replicated MIS server is necessary only when real-time data analysis that puts a heavy load on the system is being done. Normally this sort of analysis can be done offline (i.e. not in real-time) and thus real-time replication is not required.