[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 allows for yearly and other types of analysis previously unavailable in Shoplogix reporting tools, as this means reports process 24 time less records after 2 months. The trade off is that analyzing precisely 6pm-7pm (1 hour) 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.
For example:
If you want to view data from the previous 3 months, this is possible only at the daily level, not hourly
If you want to view data from the previous 3 weeks, this is possible at the hourly level, in addition to daily level.