Why are there multiple rows for each item in the Demand Forecast Table in Microsoft Dynamics AX 2012?
This is helpful to know for BI for cubes that aggregate the data in the [FORECASTSALES] table.
Basically the overview line and each exploded line of the same item is stored in the same [FORECASTSALES] table. Therefore, if any measure in this table needs to be aggregated per item, filter out just the overview rows. You can do this by filtering the column [EXPANDID] = 0.
This is the Demand Forecast entry form which has 3 exploded lines.
This creates 1 overview + 3 exploded line rows in the [FORECASTSALES] table.
Note that the EXPANDID column contains the RECID of the overview line. Therefore to filter out just the overview line, set the filter to [EXPANDID] = 0.
Here are the FREQCODE of each allocation unit period:
- Day = 0
- Month = 1
- Year = 2