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> 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

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