Print Page - Problem with null in Dimensional level

Title: Problem with null in Dimensional level
Post by: b737 on 20 Jan 2014 07:33:42 AM

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

Title: Re: Problem with null in Dimensional level
Post by: nblank on 20 Jan 2014 08:36:55 AM

I think you can never have NULL in a dimension.

Replace NULL with -1 (Unknown).

Regards,

Nanno

Title: Re: Problem with null in Dimensional level
Post by: b737 on 20 Jan 2014 01:29:36 PM

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

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: b737 on 20 Jan 2014 07:33:42 AM