Hi guys, as the title states when I process the cube I get several values converted into nulls in 2 measures from my cube (measures datatype=currency, source column in SQL DB=money).
Values like '0.13', '0.04' or '0.00' are stored in my source database and I get to see them there with no problems. I can see them too in the DSV and in the cube itself when I Explore Data.
But the moment I process the cube about 3000 records get transformed in nulls so I can't perform aggregations or filters in a proper way. I tried to fix it by setting it to ZeroOrBlank in 'Nullprocessing', I tried some combinations in 'FormatString' and I even changed the datatype to decimal and numeric (in both source and cube) but nothing seems to work.
Has anyone face this before? Is there something that I am missing? Any help would be appreciated. Thanks.