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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Newbie question

Status
Not open for further replies.

vin1127

Programmer
Joined
Feb 23, 2005
Messages
2
Location
US
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.
 
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
 
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
 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top