Demand forecast accuracy cube (ReqDemPlanAccuracyCube) for Microsoft Dynamics AX 2012 R3
Important
This content is archived and is not being updated. For the latest documentation, see Microsoft Dynamics 365 product documentation. For the latest release plans, see Dynamics 365 and Microsoft Power Platform release plans.
Applies To: Microsoft Dynamics AX 2012 R3
The Demand forecast accuracy cube for Microsoft Dynamics AX is used to calculate and store demand forecast versus realized demand accuracy measurements. This article provides details about the cube.
.png "Reference")
Deployment Configuration keys Tables and views Measures Calculated measures Key performance indicators Security |
.png "Resources")
Analytics in Microsoft Dynamics AX Cube and KPI reference for Microsoft Dynamics AX 2012 R2 and R3 Cube and KPI reference for Microsoft Dynamics AX 2012 and Microsoft Dynamics AX 2012 Feature Pack |
Deployment
The Demand forecast accuracy cube is included in the Demand Forecast Accuracy project. For information about how deploy the Demand Forecast Accuracy project—and the cubes that it contains—see Deploy the default cubes.
Configuration keys
The following configuration keys are required to use all features of the Demand forecast accuracy cube:
- Demand forecasting (ReqDemandPlanning)
Tables and views
The Demand forecast accuracy cube uses data from the following tables and views:
EcoResColor table
EcoResConfiguration table
EcoResSize table
EcoResStyle table
WHSInventStatus table
ReqDemPlanAdjustedCubeFactView view
ReqDemPlanAdjustedForecastView view
ReqDemPlanDimAllocKey view
ReqDemPlanDimCountryRegion view
ReqDemPlanDimCustomer view
ReqDemPlanDimCustomerGroup view
ReqDemPlanDimReleasedItem view
ReqDemPlanDimState view
ReqDemPlanForecastModel view
ReqDemPlanInventLocation view
ReqDemPlanInventSite view
Measures
The Demand forecast accuracy cube includes the following measure groups.
Historical demand
This measure group is based on the ReqDemPlanAdjustedCubeFactView view and includes the following measures.
Measure |
Measure field name |
Aggregation |
Description |
Associated dimensions |
|---|---|---|---|---|
Historical demand quantity |
ReqDemPlanAdjustedCubeFactView.TransactionQty |
Sum |
Past sales order lines, BOM requirement lines, and transfer lines, recorded in the Microsoft Dynamics AX database represent the historical demand quantity. |
Item allocation key Country region Customer Customer group Released product State Warehouse Site Company Styles Inventory status Colors Configurations Sizes Historical demand Date |
Adjusted forecast
This measure group is based on the ReqDemPlanAdjustedForecastView view and includes the following measures.
Measure |
Measure field name |
Aggregation |
Description |
Associated dimensions |
|---|---|---|---|---|
Current AX forecast |
ReqDemPlanAdjustedForecastView.Qty |
Sum |
Demand forecast lines recorded in the Microsoft Dynamics AX database and consumed by master planning represent the current forecast. |
Item allocation key Country region Customer Customer group Released product State Forecast models Warehouse Site Company Styles Inventory status Colors Configurations Sizes Date |
Calculated measures
The Demand forecast accuracy cube contains the following calculated measures.
Calculated measure |
Associated measure group |
Description |
|---|---|---|
Error percentage |
Adjusted forecast |
The discrepancy between realized demand and projected demand, expressed in percentage. |
Error absolute |
Adjusted forecast |
The discrepancy between realized demand and projected demand, expressed in absolute values. |
Key performance indicators
The Demand forecast accuracy cube does not include any key performance indicators (KPIs).
Security
The Demand forecast accuracy cube can be accessed by users assigned to the following Microsoft SQL Server Analysis Services roles.
Production planner
Production manager