Terry is a BI Developer in London, focusing on DataWarehouse design and Reporting using SQL Server SSIS/SSAS/SSRS.
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 […]