kylin-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From deva namaste <ohd...@gmail.com>
Subject Re: Manager employee hierarchy in Kylin
Date Thu, 01 Feb 2018 15:37:08 GMT
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
>

Mime
View raw message