Cube Demension design implemented correctly?

• Wood Chuck

  SSC Veteran

  Points: 206

  More actions

  January 9, 2013 at 12:04 pm

  #145882

  I'm creating my first cube.

  I have a design where I need to add in a line of business demension.

  I am not sure if I'm going about this correctly. As I understand it, I should remove all normal form relationships and joins. So my table ends up looking like this...

  ID -- LocID -- LOBID -- LOBType

  1 ---- 378506 ---- 1 --- Residential

  2 ---- 384915 ---- 2 ---Commercial

  3 ---- 669256 ---- 3 ---Auto

  4 ---- 384919 ---- 2 ---Commercial

  ..... (7 million records in table matching 7 million records in cube as each fact has a LOB)

  - Do I have this correct?

  Now I create a dimension from the above table.

  I don't really see any hierarchy here (not like state, county zip) so I didn't add one.

  Should I add one or not? Perhaps ID->LOBID and ID->LOBType? Although I never reference ID...

  Appreciate the help!!

• Wood Chuck

  SSC Veteran

  Points: 206

  More actions

  January 9, 2013 at 5:03 pm

  #1575510

  I did change this so the table has only 3 records and re-built the cube but it doesn't seem to have an effect on performance...:(