Modelling, level of hierarchy, employee and organization structure
Page 1 of 1
Modelling, level of hierarchy, employee and organization structure
I have to design and report on Revenue performance for the Home Office. The report should be able to show revenue by Team and roll up to Department, Division etc, show revenue by MGR and roll up to Senior VP etc..Not exactly sure where to begin. Looking for some help and any resources I can refer to help me design a data model for it. I think once the model is right, I should be able to report correctly.
Home Office --> Division --> Unit --> Department --> Team
There is also a Cost Centre associcated with each of the level above.
CEO --> Senior VP --> VP --> Senior DIR --> DIR --> Senior MGR --> MGR --> Team Lead
Some of the rules:
- Each Division is managed by a Senior VP, sometimes its a VP
- Each Unit is managed by a Senior DIR, sometimes its a DIR
- Each Department is managed by a Senior MGR, sometimes its a MGR
- Each Senior VP has 1 or many reporting VPs (but a VP may not have a Senior VP to report to, this VP reports directly to the CEO)
- Each VP has 1 or many reporting Senior DIRs (but a Senior DIR may not have a VP report to, this Senior DIR reports directly to the Senior VP)
- Each Senior DIR has 1 or many reporting DIRs ( rest is similar reporting rules as above)
- Each DIR has 1 or many reporting Senior MGRs
- Each Senior MGR has 1 or many reporting MGRs
Home Office --> Division --> Unit --> Department --> Team
There is also a Cost Centre associcated with each of the level above.
CEO --> Senior VP --> VP --> Senior DIR --> DIR --> Senior MGR --> MGR --> Team Lead
Some of the rules:
- Each Division is managed by a Senior VP, sometimes its a VP
- Each Unit is managed by a Senior DIR, sometimes its a DIR
- Each Department is managed by a Senior MGR, sometimes its a MGR
- Each Senior VP has 1 or many reporting VPs (but a VP may not have a Senior VP to report to, this VP reports directly to the CEO)
- Each VP has 1 or many reporting Senior DIRs (but a Senior DIR may not have a VP report to, this Senior DIR reports directly to the Senior VP)
- Each Senior DIR has 1 or many reporting DIRs ( rest is similar reporting rules as above)
- Each DIR has 1 or many reporting Senior MGRs
- Each Senior MGR has 1 or many reporting MGRs
BI_reporter- Posts : 5
Join date : 2011-09-11
Similar topics
» 2 fact at different granuality demanding different level of a dimension hierarchy.
» Modelling help for multiple level facts
» Employee Dimension and Reports to Hierarchy
» Employee Hierarchy Dimension Table
» Transaction with Multi level Hierarchy
» Modelling help for multiple level facts
» Employee Dimension and Reports to Hierarchy
» Employee Hierarchy Dimension Table
» Transaction with Multi level Hierarchy
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum