Demand forecast accuracy cube (ReqDemPlanAccuracyCube) for Microsoft Dynamics AX 2012 R3 [AX 2012]

Updated: July 18, 2014

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.

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.

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

  • Demand forecasting (ReqDemandPlanning)

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

The Demand forecast accuracy cube includes the following measure groups.

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

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

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.

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

The Demand forecast accuracy 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: