TR0505

This action would result in two categories with the source value source_value under different parent categories in level level_name, which is designated as unique. The action is canceled.

You have tried to specify that the categories within a level are unique when Cognos® Transformer has verified that they are not. This can occur when you

create an alternate drill-down structure and allow Cognos Transformer to designate the convergence level as unique
change the source value of a date category in such a way that two identical date categories appear in the same level
select the Unique option on the Source tab of the Level property sheet

The category values in a convergence level that connects multiple drill-down paths must be unique. Similarly, in order for Cognos Transformer to be able to directly relate source column values to categories in a level, the category values in that level must be unique.

Procedure

If a level is at the convergence of an alternate drill-down path, or if your data source contains a column for a level that lacks the ancestor levels needed to provide its context, you must ensure that each category in that level is unambiguously identifiable by its value alone.

For example, suppose the convergence level, City, is found in a Regions dimension that contains the levels Country, State, and City. To avoid uniqueness problems, ensure that your source data qualifies all identically named cities so they can be unambiguously identified. For example, the city Burlington is found in the states Massachusetts and Vermont, so you modify your source to add qualifiers for the names Burlington-MA and Burlington-VT.