ORG HIERARCHY-TYPE 2

View previous topic View next topic Go down

ORG HIERARCHY-TYPE 2

Post  SathyJaanu on Thu Jan 07, 2016 4:02 pm

THis is how my Org Dimension table looks like.This table keeps getting updated like once in two months.As the levels keep changing in an organization or so.I am pretty new to DM and been asked to develop  a ORg Hierarchy Dimension table SO i am lil confused as in where and how to start.Any suggestions will be highly appreciated.

Organization Code
Organization Name
Level 1 Code
Level 1 Description
Level 2 Code
Level 2 Description
Level 3 Code
Level 3 Description
Level 4 Code
Level 4 Description
Level 5 Code
Level 5 Description
Level 6 Code
Level 6 Description
Level 7 Code
Level 7 Description
Level 8 Code
Level 8 Description
Level 9 Code
Level 9 Description
Level 10 Code
Level 10 Description

Thnx

SathyJaanu

Posts : 20
Join date : 2015-10-07

View user profile

Back to top Go down

Re: ORG HIERARCHY-TYPE 2

Post  zoom on Fri Jan 08, 2016 9:41 am

A table design should allow to traversing a hierarchy from higher levels to lower levels of detail. You have a hierarchies of known depth.

The table design you described is an another way to model hierarchy, so why it is not working? You have other options to design hierarchy as self referenced table or use a bridge table. You can read more for those design techniques using below links.

http://www.kimballgroup.com/2009/08/five-alternatives-for-better-employee-dimension-modeling/

http://www.kimballgroup.com/wp-content/uploads/2014/11/Building-the-Hierarchy-Bridge-Table.pdf

zoom

Posts : 97
Join date : 2010-08-23
Location : Chicago

View user profile

Back to top Go down

Re: ORG HIERARCHY-TYPE 2

Post  SathyJaanu on Fri Jan 08, 2016 3:37 pm

Thanks for the inputs.
i went thru the links i am pretty much understanding the concept of Hierarchy.
My question here is say when a new level comes or a When a org change happens where will i handle it.
Would that be in my Dim or Bridge table.
that part is really confusing me.Can you please help me in understanding the same

Thanks

SathyJaanu

Posts : 20
Join date : 2015-10-07

View user profile

Back to top Go down

Re: ORG HIERARCHY-TYPE 2

Post  ngalemmo on Fri Jan 08, 2016 8:00 pm

Both. When the hierarchy changes you update the dimensions and re-generate the bridge.
avatar
ngalemmo

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

View user profile http://aginity.com

Back to top Go down

Re: ORG HIERARCHY-TYPE 2

Post  SathyJaanu on Mon Jan 11, 2016 1:38 pm

Thanks for all your inputs.I will try to use your thoughts while designing my dim and bridge tables for Org Hierarchy .

SathyJaanu

Posts : 20
Join date : 2015-10-07

View user profile

Back to top Go down

Re: ORG HIERARCHY-TYPE 2

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

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