Dimension with variable structure

View previous topic View next topic Go down

Dimension with variable structure

Post  exhortae on Fri Mar 08, 2013 1:47 pm

Hi,


I sometimes have to deal with this kind of problem and to be honest I don't really know what is the best solution.

Say you need to build an entity dimension that starts with the following hierarchy : Head Quarters > Regional Office > City office > District office.

Well fairly easy, you build a flattened hierarchy and starts linking your facts to the entity dimension. The problem arise when there is a structural change in the company organization. And the entity becomes something like : Head Quarter > National office > City Office > District Office > Block office. I just can't figure how to deal with such a scenario.

Can anyone give me some insight on it.


Thanks.

exhortae

Posts : 30
Join date : 2010-08-01

View user profile

Back to top Go down

Re: Dimension with variable structure

Post  ngalemmo on Fri Mar 08, 2013 5:37 pm

I you don't want to deal with schema and load changes when the hierarchy changes, don't store it as a flattened hierarchy.
avatar
ngalemmo

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

View user profile http://aginity.com

Back to top Go down

Re: Dimension with variable structure

Post  exhortae on Sat Mar 09, 2013 5:11 pm

Thank you

exhortae

Posts : 30
Join date : 2010-08-01

View user profile

Back to top Go down

Re: Dimension with variable structure

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