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.

Deployment Configuration keys Tables and views Measures Calculated measures Key performance indicators Security

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