QSM-00511: invalid fact-tables specified in fact-filter

QSM-00511: invalid fact-tables specified in fact-filter
Cause: The tables specified in the fact-filter are not valid fact-tables. A fact-table must have foreign-key constraints to one or more of the dimension-tables in the data warehouse.
Action: Check the fact-filter is correctly specified; check that appropriate constraints exist; and the user has privileges to access the tables

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 18:54

QSM-00511：事实过滤器中指定的无效事实表,
.原因：事实过滤器中指定的表不是有效的事实表。事实表必须对数据仓库中的一个或多个维度表具有外键约束。,
.操作：检查事实过滤器是否正确指定; 检查是否存在适当的限制; 并且用户具有访问表的权限,
.

aiaiDBA

13718043309

010-86462881

QSM-00511: invalid fact-tables specified in fact-filter

1 个回答

相似问题