Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Help TR1319 Error
- Thread starter yenfen
- Start date
yenfen,
this error comes when one is trying to get one measure (or more) from more than one datasource and transformer lacks information about the relationships between datasources. Best practise is to source measures from only one datasource, but this is not always possible.
the error arises when:
there is not a source column in all datasources (that contain measures) for all dimensions in the model
or
there is a duplication of a column being used as a measure source within one datasource.
In the first instance, check that the datasource column names are identical and that levels in dimensions that need to be unique have been specified as such.
In the latter, delete or rename the duplicate column.
If one has no way of trying datasources together in a dimension, one can always insert a column to match the relevant level and fill it with a value that will both satisfy the requirements of transformer and indicate to the user of the cube of the limitation of the data within the level.
hth,
lex
this error comes when one is trying to get one measure (or more) from more than one datasource and transformer lacks information about the relationships between datasources. Best practise is to source measures from only one datasource, but this is not always possible.
the error arises when:
there is not a source column in all datasources (that contain measures) for all dimensions in the model
or
there is a duplication of a column being used as a measure source within one datasource.
In the first instance, check that the datasource column names are identical and that levels in dimensions that need to be unique have been specified as such.
In the latter, delete or rename the duplicate column.
If one has no way of trying datasources together in a dimension, one can always insert a column to match the relevant level and fill it with a value that will both satisfy the requirements of transformer and indicate to the user of the cube of the limitation of the data within the level.
hth,
lex
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question