[Unreleased feature, targeted release date Feb 22]
This document is a primer for the big data patterns used by our database to provide the right data at the right level of detail. If you are looking to better understand historical data in Shoplogix Analytics Portal this document is for you.
Shoplogix data in Analytics Portal is always accurate to the:
Job
Shift
Reason
State
This means you can filter your historical data by any of these dimension at any time frame.
To balance performance with data resolution, data over 60 days old is stored at the daily level, data less than 60 days old is stored at the hourly level. This means reports process 24 times less records to after 2 months, allowing yearly and other types of analysis previously unavailable in Shoplogix reporting tools. The trade off is analyzing precisely 6pm-7pm is only available on 2 months worth of data.
Historical data is available on:
[Fact Core]
[Dim Jobs]
[Dim Shift Instances]
[Dim Calendar DateTime]
[Fact Scrap Reasons]
and no other tables.