[Mondrian] RES: Parent-child hierarchies

[Kleyson Rios]

Nobody to give some opinion ? L

 

I tried to update mondrian to 3.8.0 as suggested to Diethard’s Total for
parent-child problem thinking that could be some kind of bug, but I’m
getting the same results.

 

-- 

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] Em
nome de Kleyson Rios
Enviada em: quarta-feira, 7 de janeiro de 2015 08:48
Para: 'Mondrian developer mailing list'
Assunto: [Mondrian] Parent-child hierarchies

 

I'm developing a general ledger account using Parent-child hierarchies but
I'm getting a not supposed result.

 

As can be seen in the table below, I have a SQL result from my fact table
inner join with the hierarchy dimension for a given company and time.

 

mondrian1.PNG

 

But in my dashboard (even in Saiku/JPivot) I'm getting two values for the
account 2.01.04 (see image below).

 

 

mondrian3.PNG

 

Based on the SQL result above, it was supposed come just the result for
'2.01.04 - Empréstimos e Financiamentos'.

 

Checking my hierarchy dimension I have two different records sharing the
same parent_id.

 

mondrian2.PNG

 

But even with two different records sharing the same parent_id, shouldn't I
have just one result instead of both ? I mean, in my fact table there is not
fact to '2.01.04 - Relações Interfinanceiras', so, how can it be in my final
resultset ?

 

 

Regards.

 

-- 

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)

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20150108/7fa1071d/attachment-0001.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 234931 bytes
Desc: not available
Url : http://lists.pentaho.org/pipermail/mondrian/attachments/20150108/7fa1071d/attachment-0003.png 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 55660 bytes
Desc: not available
Url : http://lists.pentaho.org/pipermail/mondrian/attachments/20150108/7fa1071d/attachment-0004.png 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 20898 bytes
Desc: not available
Url : http://lists.pentaho.org/pipermail/mondrian/attachments/20150108/7fa1071d/attachment-0005.png