Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Employee Hierarchical - Rolling down reporting

2 posters

Go down

Employee Hierarchical - Rolling down reporting Empty Employee Hierarchical - Rolling down reporting

Post  imkoolkrab Wed Jul 01, 2009 8:41 pm

Hi All,

I have employee table with following structure

empid
mgrid
startdate
enddate
other emp details

I have built reporting tool that lets user select date and manager and it will list all employees under that manager. i have used oracle connect by to list all employees reporting to selected manager recursively till last level. It takes too long to list. Is there anyway i can organize data that can help me speed up query?

Thank you in advance.

imkoolkrab

Posts : 1
Join date : 2009-07-01

Back to top Go down

Employee Hierarchical - Rolling down reporting Empty Re: Employee Hierarchical - Rolling down reporting

Post  ngalemmo Thu Jul 02, 2009 12:03 pm

The general solution is a hierarchy bridge table. Review this thread for more information:

http://forum.kimballgroup.com/dimensional-modeling-and-data-architecture-f6/how-to-model-product-bundles-t147.htm

Warren sums it up nicely in the last post.
ngalemmo
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

http://aginity.com

Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum