Hello everybody, I have a problem that I can't solve. I have the main data set which is the daily stock of the warehouse. The single points are the daily stock while the solid line is the minimum stock. The minimum stock is calculated as the average consumption of the reference month of the previous year multiplied for 7 (internal convention) I have the following tables:
[MasterCalendar]:
| Date | MonthAbbr | Month | Day | DayAbbr | Trim | Quarter | DaysMonth | Year |
In DaysMonth it's indicated the number of day for a derminated
[DailyWarehouse]:
| Date | Location | Type | Value |
[HistoricalConsumption]:
| District | Month | Year | Consumption |
[LocationDistrict]:
| Location | District |
Can anyone give me some advice on how to structure the snowflake scheme? Thanks so much!
