ssas复合尺寸键 [英] ssas compound dimension key

问题描述

我正在使用SSAS Visual Studio2010.我有一个带有复合键的维度，该复合键指向事实表.首先，复合键包含三个键，现在我需要添加第四个键.我在DSV中做到了这一点，方法是单击它们之间的箭头，然后从下拉菜单中选择新字段.到目前为止，一切都很好.我保存了DSV并重新处理了我的多维数据集.问题就从这里开始:我注意到相关报告中的变化很小……我希望要么进行整体更改，要么什么都没有.当我在Visual Studio中查看多维数据集时，我注意到维度用法"选项卡仍只显示三个原始键，而没有显示新的第四个键.但是，在多维数据集中，没有下拉菜单来添加新键.所以现在我有点卡住了...我是否必须删除它并重新创建它?除非绝对必要，否则我不想这样做.另外，如果多维数据集中没有任何变化，那么怎么解释我注意到的那些微小差异呢?例如，一个显示$ 100,000的单元格可能会减少$ 15，但绝大多数价值仍然存在.

I'm using SSAS Visual Studio 2010. I have a dimension with a compound key pointing to a fact table. To begin with, the compound key contained three keys, and now I need to add a fourth. I did this in the DSV by clicking between the arrow between them and selecting the new fields from the dropdown menus. So far so good. I saved the DSV and reprocessed my cubes. Here's where the problem starts: I noticed only very minor changes in the relevant reports... I expected either wholesale changes or nothing at all. When I looked at the cube in Visual Studio, I noticed that "dimension usage" tab still showed only the three original keys - not the new fourth one. However, in the cube, there are no dropdown menus to add the new key. So now I'm a little stuck... Do I have to delete it and recreate it? I didn't want to do that unless absolutely necessary. Also, if nothing changed in the cube, then what explains those tiny variances I noticed? For example a cell showing $100,000 might be off by $15, but the vast majority of values were still spot on.

推荐答案

在DSV中进行更改时，不会自动将其添加到尺寸或度量值组中.您还必须手动将其添加到那里.在您的情况下，由于您添加了键，因此您可能必须重新创建该维，以指定新键在维中的角色(如果仅通过在维中添加键而无法工作).
HTH

When you change something in the DSV, it is not automatically added to your dimensions or measure groups. You have to manually go and add it there as well. In your case since you added a key, you might have to recreate that dimension specifying the new key's role in the dimension (This is if it does not work by only adding it in the dimension).
HTH

关于更改值，通常与键有关，因为键用于聚合数据(除了我不能说的以外).

About the changing values, it usually has something to do with the keys, since that is used to aggregate the data (Other than that I can not say).

这篇关于ssas复合尺寸键的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！