在BISM RC0中创建关系时出错

问题描述

限时删除！！

我正在尝试使用SQL Server 2012 RC0中的数据创建BISM模型。 此时我已经导入了2个表 - 一个没有唯一行标识符和维度表（LoanType）的事实表。  LoanType维度有3列
（LoanTypeID - 它是一个整数标识列，LoanTypeDesc和LoanTypeTerm），只有5行，如下所示：

1	已修复	30
2	已修复	15
3	ARM	5
4	ARM	7
5	ARM	10

当我尝试在两者之间创建关系时，维度表作为相关查找表和LoanTypeID作为相关字段，我收到以下错误："无法创建关系，因为每列包含重复值。"

当我尝试将LoanTypeID设置为行时，我收到类似的错误表格的标识符。 这是使用各种表格重新创建的，同样的过程在CPT3中运行良好。

这是一个已知问题吗？ 是否有必须在源表上设置特定属性以使表格数据库识别唯一列？

提前致谢。

解决方案

I am attempting to create a BISM model using data from SQL server 2012 RC0.  At this point I have imported 2 tables - a fact table that does not have a unique row identifier and a dimension table (LoanType).  The LoanType dimension has 3 columns (LoanTypeID - which is an integer identity column, LoanTypeDesc and LoanTypeTerm) and only 5 rows, as follows:

1	Fixed	30
2	Fixed	15
3	ARM	5
4	ARM	7
5	ARM	10

When I attempt to create a relationship between the two, with the dimension table as the related lookup table and LoanTypeID as the related field I get the following error: "The relationship cannot be created because each column contains duplicate values."

I receive similar errors when I attempt to set LoanTypeID as the row identifier for the table.  This has been re-created using a variety of tables, and the same process worked fine in CPT3.

Is this a known issue?  Are there any specific attributes that must be set on the source table for the tabular database to recognize a unique column?

Thanks in advance.

解决方案

这篇关于在BISM RC0中创建关系时出错的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！

1403页，肝出来的..