title | TOCTitle | ms:assetid | ms:mtpsurl | ms:contentKeyID | author | ms.date | mtps_version |
---|---|---|---|---|---|---|---|
Production cube (ProdCube) for Microsoft Dynamics AX 2012 R2 and R3 |
Production cube (ProdCube) |
306e60b1-757a-493b-abcd-642597fafa19 |
49384278 |
tonyafehr |
07/23/2014 |
v=AX.60 |
[!INCLUDEarchive-banner]
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 |
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.
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)
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
The Production cube includes the following measure groups.
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 |
This measure group is based on the PmfCoByProdCalcTransExpanded view and includes the following measures.
|
|
|
|
|
---|---|---|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
This measure group is based on the ProdCalcTransExpanded view and includes the following measures.
|
|
|
|
|
---|---|---|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
This measure group is based on the ProdRouteTransExpanded view and includes the following measures.
|
|
|
|
|
---|---|---|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
This measure group is based on the ProdTableExpanded view and includes the following measures.
|
|
|
|
|
---|---|---|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
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 |
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. |
The following sections describe the key performance indicators (KPIs) in the Production cube.
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. |
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:
|
Operations manager |
Production KPIs:
Graphs:
|
CEO |
Organization performance indicators:
Graphs:
|
The Production cube can be accessed by users assigned to the following Microsoft SQL Server Analysis Services roles.
-
Chief executive officer
-
Production manager