I've found a workaround:

The original value was numeric(9,2) within my SQL statement I did the following

cast(round(field, 2) as money)

Now the decimals are no longer lost in the cube.

I've found a workaround:

The original value was numeric(9,2) within my SQL statement I did the following

cast(round(field, 2) as money)

Now the decimals are no longer lost in the cube.

Hi Michael,

you've been right. We've had a bug in the sql statement. I've fixed it an will try to partially load tomorrow.

Thanx for you help!

Kindest,

Ralf

Don't think so. Full processing of everything does exactly what I want. Only partial processing does not work.

Hi Michael,

thanx for the information. I've just tried in exactly the same order without success. I've still got just the old data from the cube. Do you've got any idea?

Kindest,

Ralf