OLAP 存储引擎中存在错误: 处理时找不到以下属性键
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]