Problem with null in Dimensional level

[b737]

I am using DMR and I have hiearchy, and I have 5 levels in the hiearchy. The problem is that it does not exist for every level 4, level 5 data, so  Report Studio returns the entire row empty, because Level 5 for particular Level 4 is null. How to solve this problem

Thanks

[nblank]

I think you can never have NULL in a dimension.

Replace NULL with -1 (Unknown).

Regards,

Nanno

[b737]

Yes, but I can not make mass in the data base, and that would be very complicated. Is there any other way to solve this problem.
Thanks