<html><head><meta http-equiv="Content-Type" content="text/html charset=windows-1252"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class=""><div class="">Hi Kleyson,</div><div class=""><br class=""></div><div class="">So just some general thoughts/questions to this:</div><div class=""><br class=""></div><div class="">The results from the join indicate that there are no records for 'Relações Interfinanceiras’ in the fact table … but what about its children (I guess they are 2.01.04.01 and 2.01.04.03 ???) … are there any for them (from the second screenshot it looks like this (if you expand the node and take another screenshot we could see that))?</div><div class=""><br class=""></div><div class="">So if Empréstimos e Financiamentos really shows up with 0 in the fact table and Relações Interfinanceiras’ children’s records ( 2.01.04.01 and 2.01.04.03 or whatever they are) show up in the fact table, then it seems to me that the result in the second screenshot is valid. But I haven’t had my Espresso yet, so I might be completely on the wrong path ;)</div><div class=""><br class=""></div><div class="">BTW, which component did you use to display the hierarchy in CDE?</div><div class=""><br class=""></div><div class="">Best regards,</div><div class="">Diethard</div><br class=""><div><blockquote type="cite" class=""><div class="">On 8 Jan 2015, at 09:46, Kleyson Rios <<a href="mailto:kleyson.rios@saude.go.gov.br" class="">kleyson.rios@saude.go.gov.br</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><span style="font-family: Consolas; font-size: 14px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; float: none; display: inline !important;" class="">Relações Interfinanceiras</span></div></blockquote></div><br class=""></body></html>