Customization of input source results in incorrect data
When adding a new table to an existing dimension, the test results show no data being returned.
NULL values where data is expected
Two tables were being joined on a VARCHAR field. However, in one table, the field was described as VARCHAR(4) and the other it was a VARCHAR(1).
SQL Server 2008 R2 source database
Diagnosing the problem
Individually, each table contained data and select statements show that the columns have similar values.
Resolving the problem
Cast the VARCHAR(1) field to a VARCHAR(4) field so that the join will succeed and data will be returned.
More support for:
Cognos Analytic Applications
Software version: 8.4.2, 10.1
Operating system(s): Windows
Software edition: All Editions
Reference #: 1616885
Modified date: 09 November 2012