[Mondrian] RES: RES: Parent-child hierarchies
diethard.steiner at gmail.com
Fri Jan 9 11:23:16 EST 2015
Good to here that the problem got resolved!
I am looking forward to reading your blogpost.
> 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,
>> 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...
More information about the Mondrian