Dynamics AX Inventory cube now present in AX 2012 R2

It was recently brought to my attention that Microsoft Dynamics AX finally ships with an inventory value cube out of the box in version 2012 R2. You can find details on the measures available in the cube here, which even includes some KPI's for inventory turns and other indicators. I'm looking forward to cracking this open and comparing it to the home grown inventory cube I built on AX 2009. The primary issue is that you can't simply look at inventtrans records because those statuses are updated over time as postings occur.

Other cubes added in AX 2012 R2 include Budget control, Budget plan (my team worked on this), Profit tax, and Retail. 

AX 2012 Cubes	AX 2012 R2 Cubes
Accounts payable cube (VendCube) for Microsoft Dynamics AX 2012 and Microsoft Dynamics AX 2012 Feature Pack	Accounts payable cube (VendCube) for Microsoft Dynamics AX 2012 R2
Accounts receivable cube (CustCube) for Microsoft Dynamics AX 2012 and Microsoft Dynamics AX 2012 Feature Pack	Accounts receivable cube (CustCube) for Microsoft Dynamics AX 2012 R2
	Budget control cube (BudgetControlCube) for Microsoft Dynamics AX 2012 R2
	Budget plan cube (BudgetPlanCube) for Microsoft Dynamics AX 2012 R2
Environmental sustainability cube (EMSCube) for Microsoft Dynamics AX 2012 and Microsoft Dynamics AX 2012 Feature Pack	Environmental sustainability cube (EMSCube) for Microsoft Dynamics AX 2012 R2
Expense management cube (TrvCube) for Microsoft Dynamics AX 2012 and Microsoft Dynamics AX 2012 Feature Pack	Expense management cube (TrvCube) for Microsoft Dynamics AX 2012 R2
General ledger cube (LedgerCube) for Microsoft Dynamics AX 2012 and Microsoft Dynamics AX 2012 Feature Pack	General ledger cube (LedgerCube) for Microsoft Dynamics AX 2012 R2
	Invent value cube (InventValueCube) for Microsoft Dynamics AX 2012 R2
Production cube (ProdCube) for Microsoft Dynamics AX 2012 and Microsoft Dynamics AX 2012 Feature Pack	Production cube (ProdCube) for Microsoft Dynamics AX 2012 R2
	Profit tax totals cube (RTax25OLAP) for Microsoft Dynamics AX 2012 R2
Project accounting cube (ProjCube) for Microsoft Dynamics AX 2012 and Microsoft Dynamics AX 2012 Feature Pack	Project accounting cube (ProjCube) for Microsoft Dynamics AX 2012 R2
Purchase cube (PurchCube) for Microsoft Dynamics AX 2012 and Microsoft Dynamics AX 2012 Feature Pack	Purchase cube (PurchCube) for Microsoft Dynamics AX 2012 R2
	Retail cube (RetailCube) for Microsoft Dynamics AX 2012 R2
Customer relationship management cube (smmCube) for Microsoft Dynamics AX 2012 and Microsoft Dynamics AX 2012 Feature Pack	Sales and marketing cube (smmSalesMarketingCube) for Microsoft Dynamics AX 2012 R2
Sales cube (SalesCube) for Microsoft Dynamics AX 2012 and Microsoft Dynamics AX 2012 Feature Pack	Sales cube (SalesCube) for Microsoft Dynamics AX 2012 R2
Workflow cube (WorkflowCube) for Microsoft Dynamics AX 2012 and Microsoft Dynamics AX 2012 Feature Pack	Workflow cube (WorkflowCube) for Microsoft Dynamics AX 2012 R2

Slow Inventory Reports

A user over on the AXUG Community recently posted a question about poor performance on the standard AX Inventory reports, specifically Physical Inventory by Dimension. It turns out the fix ended up being to clear the records in two tables in the database that are used only for building this report. Normally the records are created, the report run, and then the records are deleted. However if the process is cancelled the records can be left behind. Multiple users reported the same issue.

If you are having this issue or even minor performance issues with these reports, look into deleting all of the records in the InventSumDateTable and InventSumDateTrans tables via SQL.

If you haven't joined the AXUG Community forum yet go check it out. It's a great free resource for users.