OLAP 存储引擎中存在错误: 处理时找不到以下属性键

[maddemon]

OLAP 存储引擎中存在错误: 处理时找不到以下属性键: 表:“dbo_FactUsage”，列:“Machine”，值:“6”。该属性为“ID”。 OLAP 存储引擎中存在错误: 由于找不到属性键，已跳过该记录。属性 ID 所属维度 Dim Machine 源自: 数据库: Analysis Services Project1，多维数据集: i Note Report DW，度量值组: Fact Usage，分区: Fact Usage，记录: 1。

我的FactUsage表和DimMachine表关联的，DimMachine表有ID为6的数据，为什么会报这个错误呢？ 请大侠教教

[快溜]

列名写错了吧。

[maddemon]

FactUsage表中的字段名是 Machine
DimMachine表的主键命是 ID

这是VS自动跑的啊，不是我写的SQL。 我在网上搜索了，我的不存在全角半角的问题。
有个程序负责导入数据，先导入Dim表，再导入Fact表。 现在数据都是存在的。

[maddemon]

生成的SQL语句我执行是可以找到数据的

SELECT [dbo_FactRegister].[dbo_FactRegister0_0] AS [dbo_FactRegister0_0],[dbo_FactRegister].[dbo_FactRegisterCreateDate0_1] AS [dbo_FactRegisterCreateDate0_1],[dbo_FactRegister].[dbo_FactRegisterProduct0_2] AS [dbo_FactRegisterProduct0_2],[dbo_FactRegister].[dbo_FactRegisterChannel0_3] AS [dbo_FactRegisterChannel0_3],[dbo_FactRegister].[dbo_FactRegisterMachine0_4] AS [dbo_FactRegisterMachine0_4],[dbo_FactRegister].[dbo_FactRegisterVersion0_5] AS [dbo_FactRegisterVersion0_5]
  FROM 
      (
     

    SELECT 1   AS [dbo_FactRegister0_0],[CreateDate] AS [dbo_FactRegisterCreateDate0_1],[Product] AS [dbo_FactRegisterProduct0_2],[Channel] AS [dbo_FactRegisterChannel0_3],[Machine] AS [dbo_FactRegisterMachine0_4],[Version] AS [dbo_FactRegisterVersion0_5]
  FROM [dbo].[FactRegister]
     )
     AS [dbo_FactRegister]

[maddemon]

上面的语句是另外一个cube，贴错了，不过上面的也是报错的，是找不到Channel，Channel也有数据的，属于同样的问题

[Bajnokw]

这个最后你怎么解决的啊

[maddemon]

解决了，因为我没执行维度