为AX 2012r2实施库存立方体 [英] Implementing an Inventory Cube for AX 2012r2

问题描述

Hello Experts，我需要为我的公司开发一个库存立方体。

Hello Experts, I have a requirement to develop an Inventory Cube for my company.

任何人都可以帮助我使用什么表来创建视图以及它们是如何相关的？关于该措施的任何建议？任何你认为重要的东西都会非常感激。

Can anyone help me with what are the tables am to use to create the view and how they are related? Any recommendation on the measure? Anything that you guys deem important would be greatly appreciated.

对于这个立方体，他们希望看到库存是怎样的。这是物理数量和这些数量的价值...... 

For this Cube they want to see how the inventory is. That is Physical quantity and the dollor value to those quantities..... 

我试过使用inventoryValueCube，但它没有给我这个信息。

I have tried to use the inventoryValueCube but it does not give me this information.

感谢帮助

推荐答案

嗨  Loinelf07，

Hi  Loinelf07,

当你想创建多维数据集时，你需要有维度表和事实表，你需要根据键来链接它们。您可以尝试基于数据结构来选择维度结构  Dimensions
- 简介。

When you want to create cube, you need to have dimension table and fact table , and you need to link them based on key. You could try to based on data structure to choose dimension structure Dimensions - Introduction.

为了创建多维数据集，你可以尝试引用  多维建模（Adventure Works Tutorial）和  库存
SQL Server Analysis Services 2005中的管理计算以获取详细信息。

For creating cube, you could try to refer to Multidimensional Modeling (Adventure Works Tutorial) and Inventory Management Calculations in SQL Server Analysis Services 2005 for details.

最诚挚的问候，

Zoe Zhi

这篇关于为AX 2012r2实施库存立方体的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！