[Mondrian] RES: RES: Parent-child hierarchies

Diethard Steiner diethard.steiner at gmail.com
Fri Jan 9 11:23:16 EST 2015


Hi Kleyson,

Good to here that the problem got resolved!
I am looking forward to reading your blogpost.

Best regards,
Diethard

> On 9 Jan 2015, at 16:10, Kleyson Rios <kleyson.rios at saude.go.gov.br> wrote:
> 
> Hi Diethard,
>  
> With your comments about the children, I could realize that they had different parent_id, when they should share the same parent_id.
>  
> I fixed my ETL and I’ll load my data again to check the result.
>  
> Thanks a lot for the help.
>  
> And about the hierarchy in CDE, is a Table Component + Jquery Treetable plugin (http://ludo.cubicphuse.nl/jquery-treetable <http://ludo.cubicphuse.nl/jquery-treetable>). I will write a post in how to use it.
>  
> Best regards.
>  
> Kleyson Rios.
>  
> -- 
> Kleyson Rios
> Gestor Estadual em Tecnologia da Informação
> Gerência de Tecnologia da Informação
> Secretaria de Estado da Saúde de Goiás
> (62) 3201-3707
>  
> Se não pode vencer pelo talento, vença pelo esforço. (Dave Weinbaum)
>  
> De: mondrian-bounces at pentaho.org <mailto:mondrian-bounces at pentaho.org> [mailto:mondrian-bounces at pentaho.org <mailto:mondrian-bounces at pentaho.org>] Em nome de Diethard Steiner
> Enviada em: quinta-feira, 8 de janeiro de 2015 08:12
> Para: Mondrian developer mailing list
> Assunto: Re: [Mondrian] RES: Parent-child hierarchies
>  
> Hi Kleyson,
>  
> So just some general thoughts/questions to this:
>  
> 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))?
>  
> 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 ;)
>  
> BTW, which component did you use to display the hierarchy in CDE?
>  
> Best regards,
> Diethard
>  
>> On 8 Jan 2015, at 09:46, Kleyson Rios <kleyson.rios at saude.go.gov.br <mailto:kleyson.rios at saude.go.gov.br>> wrote:
>>  
>> Relações Interfinanceiras
> 
>  
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org <mailto:Mondrian at pentaho.org>
> http://lists.pentaho.org/mailman/listinfo/mondrian <http://lists.pentaho.org/mailman/listinfo/mondrian>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20150109/1c8e3f6e/attachment-0001.html 


More information about the Mondrian mailing list