Hi all,
I have created a 'new' model using public dimensions and 3 measures. No problem there.
I have created a data source to a known BW query and loaded the data via the data preparation steps.
After running through it and loading the model I noticed that one of the measures for no apparent reason (in the draft data) was changing to a Boolean. I assume SAC makes a call on the first x rows for a sample to determine the data type and being that there are thousands of zero's before the data appears in this measure assumes a Boolean.
I know I can change the data type later on however - even changing it to a number it refuses to load anything but a zero. The other two measures are fine. Any idea how I can override this behaviour or has anybody else experienced this?
Any help appreciated...
