You need to flatten it out – bring it to Column level – All hierarchy needs to be do that.
Regards, Manoj From: deva namaste [mailto:[email protected]] Sent: Thursday, February 01, 2018 9:07 PM To: [email protected] 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 <[email protected]<mailto:[email protected]>> 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.
