Demand forecast cube (ReqDemandPlanningCube) 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 cube for Microsoft Dynamics AX is used to store historical demand data and demand forecast data. 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 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.

Configuration keys

The following configuration keys are required to use all features of the Demand forecast cube:

• Demand forecasting (ReqDemandPlanning)

Tables and views

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

Measures

The Demand forecast cube includes the following measure groups.

Historical data

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

Current AX forecast

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

Demand forecast

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.

Calculated measures

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.

Key performance indicators

The Demand forecast cube does not include any key performance indicators (KPIs).

Security

The Demand forecast cube can be accessed by users assigned to the following Microsoft SQL Server Analysis Services roles.

• Production planner

• Production manager