Drilling down showing only last two

[barrysaab]

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.

[jive]

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