hi,

i try to set up a cube based on a teradata data source.
i have the problem that my decimal(18,5) and decimal(18,3) teradata
datatypes obviously cannot be represented correctly in sql analysis server
2005. when using a table with these datatypes data exploration is possible
and the values are displayed correctly. The cube can be loaded as expected
but in the end contains values that are wrong (eg. the value 234234.12345
will appear as 23423412345.00). integers and decimal(18,0) are represented
correctly. conversion of the attributes in question to integers also worked
fine - but it's not the preferred solution as i need the full precision.
has anyone an idea how to solve this?

thanks in advance!

br,

guenter