Hi there.

I'm using SSAS on my Oracle relational star schema. So far everything
has been working fine: No Oracle issues have troubled me yet so I don't
want to jump to conclusions about this one. But it's the kind of
trouble I expected from the beginning.

My fact table contains two integer columns for storing a
DURATION_ACTUAL and DURATION_STD measures. Their data type is NUMBER(5)
in Oracle and they map to Int32 in the data source view.

I create a DURATION_VARIANCE column with a named calculation that takes
the difference and the DSV assigns it the Byte data type. And
processing doesn't work when I include the column as a SSAS measure.

Is there a way to control the data type?

-David