TR2703错误解决方法

xiaoerp

想试试不加Unique，让Transformer自己去匹配数据，结果发现如下错误，错误号是TR2703。

A column in data source data_source_name matches level level_name in dimension dimension_name by name. Values from this data source column cannot be related to categories in this level because insufficient context is specified in the data source.

This error appears on category generation if a data source column cannot be associated with some level in the model.

加上unique就没问题了。错误原理不是很明白，希望有高手帮忙解释下。

以下是IBM官方的说法：

You can solve the problem in the following ways:

• If the level you want to associate with the column contains only unique category values, select the Unique check box on the Source tab of the Level property sheet. This allows Transformer to directly associate the values from the column with the level. Transformer can then use columns from other data sources to obtain values for the ancestor categories.

• Restructure your source files so that the data source named in the error contains all the required ancestor columns.

• For all ancestor columns, ensure that the Data Class box on the General tab of the Column property sheet is not set to Ignore.