question

Llecktv-9578 avatar image
0 Votes"
Llecktv-9578 asked Llecktv-9578 commented

SSAS converts zero and low decimals into nulls when processing cube

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.

sql-server-analysis-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

LukasYu-msft avatar image
0 Votes"
LukasYu-msft answered Llecktv-9578 commented

Hi,

Have you set the column format ? Check the property and set you column format so you could have 2 decimal place measure.

You could follow the suggestions in this thread: Any way to control number of decimal places while browsing SSAS cube?

Regards,
Lukas

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi Lukas,
Yes I set the format in different ways in Format String property of the measure.
I don't have problems with decimal places but the fact that after processing the cube, I get many values converted in nulls so I can't perform aggregations or filters with my whole data.
Thanks.

0 Votes 0 ·