sql-server - SQL Server数据工具中无法将维表作为嵌套表使用

Question

我在事实表和维度表之间建立了以下关系。

尝试创建数据挖掘结构时，我不得不选择维度表 Dimension_Status 作为事实表的嵌套表，因为我试图使用“IssuedVia”预测事实表中“TimelyResponse”的概率在 Dimension_Status 表中。但是当尝试这样做时，我收到以下错误。

Dimension_Status table cannot be used as a nested table because it does not have a many-to-one relationship with the case table.  You need to create a many-to-one relationship between the two tables in the data source file

我在这里做错了什么？为什么我的维度表与事实表保持着多对一的关系，但我会收到此错误？请指教。

Answer 1

我可能完全没有注意到这里(我没有使用 SSAS 进行大量数据挖掘)，但据我所知，嵌套表是多对多关系的“多”面.来自MSDN article on Nested Tables它显示“产品”表嵌套在“客户”表中，因为每个客户可以有很多产品:

In this diagram, the first table, which is the parent table, containsinformation about customers, and associates a unique identifier foreach customer. The second table, the child table, contains thepurchases for each customer. The purchases in the child table arerelated to the parent table by the unique identifier, the CustomerKeycolumn. The third table in the diagram shows the two tables combined.

A nested table is represented in the case table as a special columnthat has a data type of TABLE. For any particular case row, this kindof column contains selected rows from the child table that pertain tothe parent table.

所以看起来嵌套表不是您想要的 - 不幸的是，我对 SSA 数据挖掘工具不够熟悉，无法推荐合适的方法(除非切换它们并制作 DimStatus 列出您的 Case 表和 Fact_CustomerComplaints 您的 Nested 表将适用于您的情况。)