tschi2001


Hello experts,

I¡¯ve got I little problem how the Null values are stored in the Cube.

I¡¯ve got a Dimension what contains an Attribute e.g. ¡°MyPerfectDate¡±.

Sometimes this Attribute has a Null value.

So far so long no problems.

Now if I try to build a Report with SSRS and found out, that SSAS stored the NULL values as blank or ¡°empty¡± and change the datatype.

I tried to work with the DataItem and set NullProcesing to ¡°Preverse¡± or ¡°UnknownMember¡± but this doesn¡¯t resolve my Problem.

Have someone another idea

Thanks a lot

Alex




Re: Allow Null values

tschi2001


Hello,

Have nobody any idea

This problem sounds not so complex to me, I think I forgot an option.

Could it be that I forget some information that you couldn¡¯t help me

Yours sincerely,

Alex






Re: Allow Null values

phuhn

We had a similar problem with a string value containing nulls and empty values in RS. Our solution was to go back to the cube and change the value to "". Since, yours is a date you might want to set the date to 1/1/1753.







Re: Allow Null values

tschi2001

Hello phuhn,

Thanks a lot for the response. Today I thought about this option too.

You never found a better solution I don¡¯t know why my solution didn¡¯t work, because there are some others threads and there is the solution to change the DataItem¡­.

Best regards,

Alex