aiaiDBA

加微信获取免费职业规划+学习资料,了解年薪50万的DBA是如何练成的

13718043309

010-86462881

QSM-00506: no fact-tables could be found

QSM-00506: no fact-tables could be found
Cause: The fact-filter is not specified, and there are no fact-tables in the warehouse. A fact-table is a table having 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

请先 登录 后评论

1 个回答

小智
QSM-00506:没有事实表可以找到,
.原因:事实过滤器未指定,仓库中没有事实表。事实表是对数据仓库中的一个或多个维度表具有外键约束的表。,
.操作:检查事实过滤器是否正确指定; 检查是否存在适当的限制; 并且用户具有访问表的权限,
.
请先 登录 后评论