Split hierarchies and hierarchy levels into multiple dimensions

View previous topic View next topic Go down

Split hierarchies and hierarchy levels into multiple dimensions

Post  dim67 on Fri May 25, 2012 12:07 pm

Hi Folks,

According to Dr. Kimball hierarchy belongs in a single, physical flat dimension table. Resist the urge to "snowflake" a hierarchy by generating a set of progressively smaller subdimension tables. I have the following hierarchy from OLTP system. Many Feeders roll up into a single subbank. Many subbanks roll up into a single substation. Many substation roll up into a single opcenter, and so on up to company. The dimension in this case is expressed at the lowest level of granularity ( such as feeder) then all the higher levels of the hierarchy can be expressed as unique values in the feeder record. Should I create a one dimension table containig all of this levels? or 5 separate
dim tables?.

Thanks in advance,


dim67

Posts : 15
Join date : 2012-05-05

View user profile

Back to top Go down

Re: Split hierarchies and hierarchy levels into multiple dimensions

Post  BoxesAndLines on Fri May 25, 2012 2:33 pm

I'd follow Kimball's advice.
avatar
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

View user profile

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