This is an OLAP (Online Analytical Processing) application for OPSCON’s MoveItNow Suite.
Using this application you can generate reports and charts for various performance indicators.
Data Sets – Pre-Aggregated
Within the database there are a number of pre-aggregated tables. These tables are used to summarize some key performance indicators (KPI) based on calendar months.
Data Sets – Other
Also exposed are: All Orders, Warehouse Inventory, Vehicle Maintenance, and Trailer Maintenance.
These data sets are not pre-aggregated so you have complete access to all the exposed fields.
You can also make your own queries.
Since the system records the full postal code in the pre-aggregated tables, the cube can get quite large.
You can group postal codes together to define an area.
Postal Code Groups are loaded from text files so you can have Customer specific groups.
Since all the Toronto, ON, Canada postal codes start with the letter M you can group them together into a Toronto group.
This way the cube shows just a single line for the group rather than each postal code within.