Datatype Problem - SSAS 2005

[Dodecahedron]

I am currently developing a cube with sql 2005 analysis services.

I am currently having a problem joining six tables together in the Data Source View.

In the database the fields that I am joining together in all the problem tables are of datatype tinyint.
When I join them together in a stored procedure for example there are no problems with the joins.

However when I try to join the tables in the DSV, the datatype in one table is tinyint and the field to join to in the other table is now regarded
as of datatype system.byte. Therefore I cannot join them together as they are now deeemed as different data types.

Can anybody tell me what is going on with this or help me with a solution.

 

[karbon]

i have the same problem.
Are there any cumulative update for this bug.

 

[RiverGuy]

Easiest fix would be to create a view in the database that converts to int, and use that view in your DSV.

 

[MDXer]

I typically recomend always using a view as the source table as it allows you to handle this and other items easier.

I believe in the DSV you may be able to change the datatype property.

Paul
---------------------------------------
Shoot Me! Shoot Me NOW!!!
- Daffy Duck