即使存在ssas属性密钥，也不是由于重复导致 [英] ssas attribute key cannot be found even though it exists and is not due to duplicates

问题描述

前几天我对事实和维度表中的表/列名称进行了一些更改之后，我试图重建多维数据集。

I was trying to rebuild my cube after making some changes the other day to the table/column names in the fact and dimension tables.

处理多维数据集操作保持不变返回以下错误消息：

The process cube action kept returning the following error message:

处理时找不到属性键：表：
'MyFactTableName'，列：' MyDimensionKey，值： SomeValue。
属性为 MyDimensionKey。

The attribute key cannot be found when processing: Table: 'MyFactTableName', Column: 'MyDimensionKey', Value: 'SomeValue'. The attribute is 'MyDimensionKey'.

对类似问题的其他答案是指具有重复值的属性，以及

The other answers to similar questions referred to attributes with duplicate values, and cases where the attribute value was null in the or missing in either the Dimension or the Fact table.

相关示例示例如下：

• ssas维度处理键未找到错误


• 找不到密钥错误

• ssas dimension processing key not found error
• key not found error

在我的案例中，没有重复的值，事实或维度表中也不缺少属性值。

There were no duplicate values in my case and the attribute value was not missing from either the Fact or Dimension table.

感谢本文中的信息这里解决了我的问题。

Thankfully the information in this post here solved my problem.

建议是单独处理受影响的维度，然后处理受影响的度量值组。

The suggestion was to process the affected Dimension by itself, and then process the affected measure group.

为什么会发生这种情况，我该如何重现？我想知道，以便下次可以避免它，或者在将升级部署到生产环境时，它不会在糟糕的时候再次弹出。

Any idea why this happens, how I could reproduce this? I'd like to know so that I can avoid it next time or so that it doesn't pop up again at a bad time while deploying an upgrade to the production environment.

谢谢您的帮助。

编辑：我正在使用SSAS-2008，尝试从BIDS-2008内部处理多维数据集时发生了错误。

I'm using SSAS-2008, and the error occurred while trying to process the cube from within BIDS-2008.

推荐答案

之所以会发生这种情况，是因为您的度量值组在相关维之前进行了处理。 SSAS遇到了一个曾经与多维数据集维度相关联的外键，但是该维度本身并不知道该键。

This happens because your measure group is processed before the related dimensions. SSAS comes across a foreign key that's used to relate to a cube dimension, but the key is not known to the dimension itself.

这篇关于即使存在ssas属性密钥，也不是由于重复导致的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！