Data Module MSR-VRF-1204 The column "Report Date" has inconsistent taxonomy"

[JBCLARK20]

Hi All,
Working with Cognos analytics 11.x - we are up to date with our patches.

Building a data module and i want to connect a date from a SQL Server view to a date from an excel upload. The excel table is a date dimension with a record for each day and the associated days of the week, fiscal year, month names etc.

Creating a relation ship from data to date does not work, even though both fields look the same in the relationship dialog box.

Converting the dates from dates (YYYY-MM-DD) to 10 character text fields does not work even though  both fields look the same in the relationship dialog box and have the same properties.

Any ideas on how to get date fields to join in a data module would be appreciated.

Thank you.

[MFGF]

Hi All,
Working with Cognos analytics 11.x - we are up to date with our patches.

Building a data module and i want to connect a date from a SQL Server view to a date from an excel upload. The excel table is a date dimension with a record for each day and the associated days of the week, fiscal year, month names etc.

Creating a relation ship from data to date does not work, even though both fields look the same in the relationship dialog box.

Converting the dates from dates (YYYY-MM-DD) to 10 character text fields does not work even though  both fields look the same in the relationship dialog box and have the same properties.

Any ideas on how to get date fields to join in a data module would be appreciated.

Thank you.

Hi,

If you open the properties dialog for each of the date fields, what data type is the data module seeing each as being? Timestamp? What settings (if any) do you see in the "Represents" property? Time and Date? Is it the same for each? Finally, if you change the Represents property for each from Time to blank, do you still see the error?

Cheers!

MF.