title | TOCTitle | ms:assetid | ms:mtpsurl | ms:contentKeyID | author | ms.date | mtps_version |
---|---|---|---|---|---|---|---|
Purchase cube (PurchCube) for Microsoft Dynamics AX 2012 R2 and R3 |
Purchase cube (PurchCube) |
5a95613f-8337-455f-bd44-04bfc4bf94e2 |
49384281 |
tonyafehr |
07/23/2014 |
v=AX.60 |
[!INCLUDEarchive-banner]
Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2
The Purchase cube for Microsoft Dynamics AX is used to report on purchase transactions. This article provides details about the cube.
![]() Units of measure and reporting with the Purchase 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 |
When working with Microsoft SQL Server Reporting Services reports that display a quantity of an item, the appropriate unit of measure must be incorporated into the report to make sure that the quantity is correct, instead of just presenting a SUM value.
For the Quantity measures in the purchase unit of measure, slicing on the Purchase Units dimension separates the quantities by unit of measure. Quantity measures in inventory unit of measure can be sliced by the Unit dimension, which represents the inventory unit.
The Purchase 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 Purchase cube:
-
General ledger (LedgerBasic)
-
Trade (LogisticsBasic)
The Purchase cube uses data from the following tables and views:
-
DlvMode table
-
InventBuyerGroup table
-
VendInvoiceJour table
-
InventTableExpanded view
-
PurchLineExpanded view
-
TAMVendRebateExpanded view
-
VendInvoiceTransExpanded view
-
VendPackingSlipTransStage view
-
VendTableCube view
Note
The TAMVendRebateExpanded view is used with this cube only in Microsoft Dynamics AX 2012 R3.
The Purchase 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 in all organizations. |
Currency Company Released products Buyer groups Vendor Styles Colors Configurations Sizes |
This measure group is based on the PurchLineExpanded view and includes the measures in the following table.
From the measures it is possible to read the cycle time in calendar days that it takes for a purchase to be fulfilled. The measure is based on events on a purchase line. The events on a purchase line included in this context are:
-
Confirming the purchase order the first time; the delivery date on the purchase line is the requested date
-
Adding the confirmed delivery date after the purchase order has been confirmed
-
Registering the first product receipt (fully received or partially received)
-
Registering the last product receipt (first product receipt = last product receipt if there is only one)
Only purchase order lines where the products are received by products receipts and have status received or invoiced are included in the cube measures.
|
|
|
|
|
---|---|---|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
This measure group is based on the VendPackingSlipTransStage view and includes the following measures.
|
|
|
|
|
---|---|---|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
This measure group is based on the VendInvoiceJour table and includes the following measures.
|
|
|
|
|
---|---|---|---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
This measure group is based on the VendTableCube view and includes the following measures.
Measure |
Measure field name |
Aggregation |
Description |
Associated dimensions |
---|---|---|---|---|
Vendors count |
Not applicable |
Count |
The number of vendor accounts. |
Currency Company Vendor Warehouses Vendor (vendor – invoice account) |
This measure group is based on the VendInvoiceTransExpanded 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 |
This measure group is based on the TAMVendRebateExpanded view and includes the following measures.
Note
This measure group is available only in Microsoft Dynamics AX 2012 R3.
Measure |
Measure field name |
Aggregation |
Description |
Associated dimensions |
---|---|---|---|---|
Vendor rebate count |
Not applicable |
Count |
Total number of Open and Approved rebate claims. |
Currency Company Released Products Vendor Vendor Rebate Date (Calculation date – Date) |
Vendor rebate amount |
TAMVendRebateExpanded.StartingRebateAmt |
Sum |
Total dollar value of Open and Approved rebate claims. |
The Purchase cube contains the following calculated measures.
Calculated measure |
Aggregation |
Associated measure group |
Description |
---|---|---|---|
Average days late |
Average |
Product receipt lines |
The average difference from expected delivery to actual product receipt for all late product receipts. |
Average days early |
Average |
Product receipt lines |
The average difference from expected delivery to actual product receipt for all early product receipt. |
Vendor performance on product receipts - percent late |
Average |
Product receipt lines |
The percent of all product receipts where the product receipt lines are received late. |
Vendor performance on product receipts - percent on time |
Average |
Product receipt lines |
The percent of all product receipts where the product receipt lines are received on time. |
Vendor performance on product receipts - percent early |
Average |
Product receipt lines |
The percent of all product receipts where the product receipt lines are received early. |
Purchase line average days from first confirmation to received |
Average |
Purchase lines |
The average difference from first confirmation to the last product receipt registered. |
Purchase line average days late from first requested delivery date to received |
Average |
Purchase lines |
The average difference from the requested delivery date of first confirmation to the last product receipt registered for purchase lines with late receipt. |
Purchase line average days early from first requested delivery date to received |
Average |
Purchase lines |
The average difference from the requested delivery date of first confirmation to the last product receipt registered for purchase lines with early receipt. |
Purchase line average days from first confirmation to first receipt |
Average |
Purchase lines |
The average difference from first confirmation to the first product receipt registered. |
Purchase line average days from first receipt to received |
Average |
Purchase lines |
The average difference from the first product receipt registered to the last product receipt registered. |
Purchase line average days from first confirmation to delivery date is confirmed |
Average |
Purchase lines |
The average difference from first confirmation to addition of the confirmed delivery date to the purchase line. |
Purchase line average number of confirmations |
Average |
Purchase lines |
The average number of confirmed purchase orders per related purchase line. |
Purchase line average number of product receipts |
Average |
Purchase lines |
The average number of product receipts registered on the purchase lines. |
The Purchase cube does not include any key performance indicators (KPIs).
The Purchase cube can be accessed by users assigned to the following Microsoft SQL Server Analysis Services roles.
-
Accountant
-
Accounting manager
-
Accounting payable manager
-
Accounting supervisor
-
Accounts payable centralized payments clerk
-
Accounts payable clerk
-
Accounts payable manager
-
Buying agent
-
Chief executive officer
-
Chief financial officer
-
Compliance manager
-
Financial controller
-
Project manager
-
Purchasing manager