TR1319

Measure measure_name can be in multiple data sources, but only if the lowest levels in each regular dimension associated with those data sources are identical.

This error is generated when Cognos® Transformer detects a measure that obtains source values from columns in two or more data sources, but the data sources are not associated with the same levels and dimensions.

For example, suppose you have two data sources that contain source values for the Revenue measure. The data sources are not related in any other way. Both data sources have columns that are used as source values for levels in different dimensions. Cognos Transformer cannot perform rollups correctly because it does not know how to associate measure values with specific categories.

Procedure

To resolve the problem, we recommend that you only obtain measure values from multiple data sources if all of those data sources contribute to the same dimension. Then, to ensure that each measure gets properly applied, create an unambiguous relationship between the measures in each data source and the dimensions in your model, using one of the following methods:
  • Reconstruct your data sources so that all measure values are obtained from a single source.
  • Redesign your model so that the data sources that provide measure values contribute to the same dimension.
Tip: Use the Show Scope command to see which data sources contribute to a particular dimension.