Demand forecast cube (ReqDemandPlanningCube) for Microsoft Dynamics AX 2012 R3 [AX 2012]
Updated: July 18, 2014
Applies To: Microsoft Dynamics AX 2012 R3
The Demand forecast cube for Microsoft Dynamics AX is used to store historical demand data and demand forecast data. This article provides details about the cube.
The Demand forecast cube is included in the Demand Forecast project. For information about how deploy the Demand Forecast project—and the cubes that it contains—see Deploy the default cubes.
The Demand forecast cube uses data from the following tables and views:
-
EcoResColor table
-
EcoResConfiguration table
-
EcoResSize table
-
EcoResStyle table
-
WHSInventStatus table
-
ReqDemPlanCubeFactView view
-
ReqDemPlanCurrentForecastView view
-
ReqDemPlanDimAllocKey view
-
ReqDemPlanDimCountryRegion view
-
ReqDemPlanDimCustomer view
-
ReqDemPlanDimCustomerGroup view
-
ReqDemPlanDimReleasedItem view
-
ReqDemPlanDimState view
-
ReqDemPlanForecastModel view
-
ReqDemPlanForecastView view
-
ReqDemPlanInventLocation view
-
ReqDemPlanInventSite view
-
ReqDemPlanMiningModelStagingView view
The Demand forecast cube includes the following measure groups.
This measure group is based on the ReqDemPlanCubeFactView view and includes the following measures.
| Measure | Measure field name | Aggregation | Description | Associated dimensions |
|---|---|---|---|---|
| Actual demand | ReqDemPlanCubeFactView.TransactionQty | Sum | Past, current, and future sales order lines, BOM requirement lines, and transfer lines that are recorded in the Microsoft Dynamics AX database that represent the actual demand. | Item allocation key Country region Customer Customer group Released product State Warehouse Site Company Styles Inventory status Colors Configurations Sizes Historical data Date |
This measure group is based on the ReqDemPlanCurrentForecastView view and includes the following measures.
| Measure | Measure field name | Aggregation | Description | Associated dimensions |
|---|---|---|---|---|
| Current AX forecast | ReqDemPlanCurrentForecastView.Qty | Sum | Demand forecast lines that are recorded in the Microsoft Dynamics AX database and consumed by master planning. They represent the current Microsoft Dynamics AX forecast. | Item allocation key Country region Customer Customer group Released product State Forecast models Warehouse Site Company Styles Inventory status Colors Configurations Sizes Date |
This measure group is based on the ReqDemPlanForecastView view and includes the following measures.
| Measure | Measure field name | Aggregation | Description | Associated dimensions |
|---|---|---|---|---|
| Forecasted quantity | ReqDemPlanForecastView.Qty | Sum | The demand forecast projection that is calculated based on different forecasting methods. | Item allocation key Country region Customer Customer group Released product State Warehouse Site Company Styles Inventory status Colors Configurations Sizes Demand forecast Date |
| Quantity | ReqDemPlanForecastView.OriginalQty | Sum | The demand forecast projection that is calculated based on different forecasting methods. |
The Demand forecast cube contains the following calculated measures.
| Calculated measure | Associated measure group | Description |
|---|---|---|
| Adjusted quantity | Demand forecast | Manual adjustments made to the forecasted demand quantity that is calculated by various forecasting methods. |
| Read only historical and forecast quantity | Demand forecast | Past actual demand and projected future demand quantities. |
Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).
