Database design for Organization hierarchy for collecting data at different level for creating metrics
Page 1 of 1
Database design for Organization hierarchy for collecting data at different level for creating metrics
Hi ,
Im new to database. I have requirement for developing metrics framework. In my organization we have hierarchy. Each hierarchy we have certain metrics thats common for all some metrics specific to particular department. I have defined Level master table which links to each hierarchy level. And I have User Role defined. Based on the level she/he can see the dashboard of his level to bottom level. I dont know whether am doing right or wrong. Please correct me if Im wrong and give me idea how to automate this using database. Is role should be links to Hierarchy level?
Thanks,
Sivanandan.R
Im new to database. I have requirement for developing metrics framework. In my organization we have hierarchy. Each hierarchy we have certain metrics thats common for all some metrics specific to particular department. I have defined Level master table which links to each hierarchy level. And I have User Role defined. Based on the level she/he can see the dashboard of his level to bottom level. I dont know whether am doing right or wrong. Please correct me if Im wrong and give me idea how to automate this using database. Is role should be links to Hierarchy level?
Thanks,
Sivanandan.R
sivanandan.r- Posts : 1
Join date : 2013-03-27
![-](https://2img.net/i/empty.gif)
» Modelling, level of hierarchy, employee and organization structure
» question on handling unassigned records for type 2 SCD for Organization Hierarchy
» Creating Database View on Fact Table with Dimension tables
» Constraints at Database Level or at ETL side .
» Automating dimension and fact loading ETL at the database level - Good or Bad?
» question on handling unassigned records for type 2 SCD for Organization Hierarchy
» Creating Database View on Fact Table with Dimension tables
» Constraints at Database Level or at ETL side .
» Automating dimension and fact loading ETL at the database level - Good or Bad?
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum