kylin-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kumar, Manoj H" <manoj.h.ku...@jpmorgan.com>
Subject RE: Manager employee hierarchy in Kylin
Date Fri, 02 Feb 2018 03:44:50 GMT
You need to flatten it out – bring it to Column level – All hierarchy needs to be do that.

Regards,
Manoj

From: deva namaste [mailto:ohdeva@gmail.com]
Sent: Thursday, February 01, 2018 9:07 PM
To: user@kylin.apache.org
Subject: Re: Manager employee hierarchy in Kylin

Hello,

Any Idea or updates on how to achieve building hierarchy I explained in my question 2 days
ago? Any workaround I can implement in order to achive this requirement?

Any advice is appreciated. Thanks

- Deva

On Tue, Jan 30, 2018 at 5:51 PM, deva namaste <ohdeva@gmail.com<mailto:ohdeva@gmail.com>>
wrote:
Hello

I am plannning to implement Manager -  Employee Hierarchy in Dimension table and join with
the fact table similarly its been explain in following link

http://brazenly.blogspot.com/2015/02/datawarehouse-dimensional-modeling.html<https://secureweb.jpmchase.net/readonly/http:/brazenly.blogspot.com/2015/02/datawarehouse-dimensional-modeling.html>

So far, I am unable to achieve.

How do I achieve? If no straight forward solution, any workaround which I can implement?

(One employee can be under one manager for one task and also can be under another manager
for different task, so above link hierarchy will work. but unfortunately I am getting duplicate
records in dimension table when I try to achieve because Kylin looking for single record primary
key key in dimension. How can I achieve?)

Please advice.
Thanks


This message is confidential and subject to terms at: http://www.jpmorgan.com/emaildisclaimer
including on confidentiality, legal privilege, viruses and monitoring of electronic messages.
If you are not the intended recipient, please delete this message and notify the sender immediately.
Any unauthorized use is strictly prohibited.
Mime
View raw message