Newbie question

[vin1127]

I am trying to join two tables by product code in the cube editor, i get error saying incompatible data types, in one table the product code is char, and the other small integer. How do I handle this. Thanks.

 

[johnherman]

You will need to settle on a "least common denominator" so that the dimensions can be joined. In this case, character is less restrictive than integer, so convert the integers to character.

-------------------------
The trouble with doing something right the first time is that noboby appreciates how difficult it was.
- Steven Wright

 

[johnherman]

BTW - There is a TO_CHAR function in Transact SQL

-------------------------
The trouble with doing something right the first time is that noboby appreciates how difficult it was.
- Steven Wright

 

[vin1127]

Thanks! Where does the conversion take place, within Analysis services, or do i have to convert the data say in a view, and pull that view into the cube.