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

maddemon 2012-10-09 03:10:07

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的数据，为什么会报这个错误呢？请大侠教教

...全文

814 6 打赏收藏转发到动态举报

写回复

用AI写文章

6 条回复

切换为时间正序

请发表友善的回复…

发表回复

maddemon 2012-12-04

打赏
举报

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

Bajnokw 2012-10-15

打赏
举报

这个最后你怎么解决的啊

maddemon 2012-10-09

打赏
举报

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

maddemon 2012-10-09

打赏
举报

生成的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]