I have two tables.
TEST_KEY numeric(19,0) IDENTITY,
TEST_KEY BIGINT NOT NULL
I am trying to use SQL Analysis Server to create a relationship between those two tables but I get an error that the data types are different. Is there a setting to let SQL Server know that they are similar and to allow the relationship to be built?