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 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 following configuration keys are required to use all features of the Demand forecast cube:

  • Demand forecasting (ReqDemandPlanning)

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.

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

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

  • Production planner

  • Production manager


Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).

Community Additions

ADD
Show: