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的数据,为什么会报这个错误呢? 请大侠教教
------解决方案--------------------
列名写错了吧。
------解决方案--------------------
FactUsage表中的字段名是 Machine
DimMachine表的主键命是 ID
这是VS自动跑的啊,不是我写的SQL。 我在网上搜索了,我的不存在全角半角的问题。
有个程序负责导入数据,先导入Dim表,再导入Fact表。 现在数据都是存在的。
------解决方案--------------------
生成的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]
------解决方案--------------------
上面的语句是另外一个cube,贴错了,不过上面的也是报错的,是找不到Channel,Channel也有数据的,属于同样的问题
------解决方案--------------------
这个最后你怎么解决的啊
------解决方案--------------------
解决了,因为我没执行维度