Skip to Content
0
Dec 15, 2022 at 11:10 AM

SAC - New Model Data preparation issue

82 Views

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...

image.png

Attachments

image.png (11.4 kB)