| Note |
|---|
[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.
...
To balance performance with data resolution, data :
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.
...
[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.