COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: barrysaab on 15 Apr 2011 12:29:12 AM

Title: Drilling down showing only last two
Post by: barrysaab on 15 Apr 2011 12:29:12 AM
I am applying drilling up/down on a DMR model,but when i drill down to Global to region to countries it is only showing last two countries missing all prior countries in that region.Thanks for your help.
Title: Re: Drilling down showing only last two
Post by: jive on 15 Apr 2011 08:41:57 AM
First thing to check it's the dimension definition. May be the key for the unique level or the business key are not the right one.
you can also check the relation between fact and dimension, if the relation is 1-1 and 1-0 you will never show dimension without fact related. Maybe that's the case here.

Regards Jacques