Production cube (ProdCube) for Microsoft Dynamics AX 2012 R2 and 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, Microsoft Dynamics AX 2012 R2

The Production cube for Microsoft Dynamics AX is used to manage and track production activities. 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 Production cube is included in the Dynamics AX project. For information about how deploy the Dynamics AX 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 Production cube:

• Production series I (Prod)

• Production series II (ProdRouting)

• Trade (LogisticsBasic)

• Resources (WrkCtr)

• Product dimension – configuration (Config)

• Product dimension – color (EcoResProductColor)

• Product dimension – size (EcoResProductSize)

Tables and views

The Production cube uses data from the following tables and views:

• InventLocationExpanded view

• InventTableExpanded view

• PmfCoByProdCalcTransExpanded view

• ProdCalcTransExpanded view

• ProdCalcTransLevel view

• ProdRouteTransExpanded view

• ProdTableExpanded view

• WrkCtrTableExpanded view

Measures

The Production cube includes the following measure groups.

Released products

This measure group is based on the InventTableExpanded view and includes the following measures.

Measure	Measure field name	Aggregation	Description	Associated dimensions
Released products count	Not applicable	Count	The number of released products.	Currency Company Released products Styles Colors Configurations Sizes

Co-product cost calculation

This measure group is based on the PmfCoByProdCalcTransExpanded view and includes the following measures.

Measure	Measure field name	Aggregation	Description	Associated dimensions
Co-product cost calculation count	Not applicable	Count	The number of cost calculations performed for the co-product.	Company Released products Warehouses Production level Styles Colors Configurations Sizes Co-product cost calculation Date Date (ended date) Date (exchange rate date)
Co-product cost amount	PmfCoByProdCalcTransExpanded.CostAmount	Sum	The total cost amount for the co-product.
Co-product cost markup	PmfCoByProdCalcTransExpanded.CostMarkup	Sum	The total markup cost amount for the co-product.
Co-product real cost adjustment	PmfCoByProdCalcTransExpanded.RealCostAdjustment	Sum	The total adjusted realized cost amount for the co-product.
Co-product actual cost amount	PmfCoByProdCalcTransExpanded.RealCostAmount	Sum	The total actual cost amount for the co-product.

Cost calculation

This measure group is based on the ProdCalcTransExpanded view and includes the following measures.

Measure	Measure field name	Aggregation	Description	Associated dimensions
Cost calculation count	Not applicable	Count	The number of calculations.	Company Released products Warehouses Production level Styles Colors Configurations Sizes Cost calculation Production order Date Date (ended date) Date (exchange rate date)
Cost amount	ProdCalcTransExpanded.CostAmount	Sum	The estimated cost of production.
Cost markup	ProdCalcTransExpanded.CostMarkup	Sum	The estimated cost of miscellaneous charges.
Actual cost amount	ProdCalcTransExpanded.RealCostAmount	Sum	The actual cost of the production.
Real cost adjustment	ProdCalcTransExpanded.RealCostAdjustment	Sum	The actual adjustment made by inventory closing.

Route transactions

This measure group is based on the ProdRouteTransExpanded view and includes the following measures.

Measure	Measure field name	Aggregation	Description	Associated dimensions
Route transactions count	Not applicable	Count	The number of route transactions.	Currency Company Released products Warehouses Resources Styles Colors Configurations Sizes Route transactions Date
Amount posted to ledger	ProdRouteTransExpanded.Amount	Sum	The amount that the transaction has been posted to the ledger.
Error quantity	ProdRouteTransExpanded.QtyError	Sum	The number of error items reported on the operation or job.
Good quantity	ProdRouteTransExpanded.QtyGood	Sum	The number of good items reported on the operation or job.

Production order

This measure group is based on the ProdTableExpanded view and includes the following measures.

Measure	Measure field name	Aggregation	Description	Associated dimensions
Production order count	Not applicable	Count	The number of production orders.	Currency Company Released products Warehouses Production order Date Date (ended date) Date (production order – ship date) Date (started) Date (reported as finished) Date (start date)
Days delayed	ProdTableExpanded.DaysDelayed	Sum	The number of days the production order has been delayed based on the scheduled end date and the actual end date.
Lead time	ProdTableExpanded.LeadTime	Sum	The actual lead time in production, that is, the average time from production start to finish.
Planned lead time	ProdTableExpanded.PlannedLeadTime	Sum	The planed lead time in production, that is, the average time from the planned start of production to the planned end of production.

Exchange rates by day

This measure group is based on the BIExchangeRateView view and includes the following measures.

Measure	Measure field name	Aggregation	Description	Associated dimensions
Exchange rate	BIExchangeRateView.CrossRate	Max	The exchange rate.	Currency Date (exchange rate date) Analysis currency

Calculated measures

The Production cube contains the following calculated measures.

Calculated measure	Aggregation	Associated measure group	Description
Production efficiency	Average	Production order	The actual processing time as a percentage of the processing time estimated based on the route.
Planned cost amount	Average	Cost calculation	The planned resource and materials consumption.
Planned cost markup	Average	Cost calculation	The calculated additional charges.
Realized cost amount	Average	Cost calculation	The actual cost of production.
Realized cost adjustment	Average	Cost calculation	The actual additional charges.
Cost of planned consumption	Average	Cost calculation	The total cost of planned resource and materials consumption, including calculated additional charges.
Cost of actual consumption	Average	Cost calculation	The total cost of actual resource and materials consumption, including actual additional charges.
Actual vs. planned consumption	Average	Cost calculation	The difference between actual and planned consumption.
Defect ratio	Average	Route transactions	The number of reported errors in parts per million.
WIP level	Average	Cost calculation	The cost associated with the current work-in-progress.
On-time production rate	Average	Production order	The percentage of production orders that are completed on or before the requested date.

Key performance indicators

The following sections describe the key performance indicators (KPIs) in the Production cube.

KPI calculations

The following table lists the KPIs that are associated with the Production cube. You can use the information in the following table to help verify the information in your KPIs.

KPI	Associated measure group	Calculation
Production cost	Cost calculation	This KPI is bound to the Actual vs. planned consumption calculated measure.
Production efficiency	Production order	This KPI is bound to the Production efficiency calculated measure.

Role Centers

The following table lists the Role Centers and web parts that display the KPIs associated with the Production cube.

Role Center	Web parts and KPIs
Production manager	Production KPIs: On-time production rate (%) Planned vs. actual cost (%) Defect ration (ppm) Production efficiency (%) Production lead time (seconds)
Operations manager	Production KPIs: On-time production rate (%) Planned vs. actual cost (%) Defect ration (ppm) Production efficiency (%) Production lead time (seconds) Graphs: Defect ratio
CEO	Organization performance indicators: Production efficiency Production cost Graphs: Actual vs. planned consumption

Security

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

• Chief executive officer

• Production manager