Author Topic: surrogate key administration  (Read 1328 times)

Offline chepitoleon

  • Full Member
  • ***
  • Join Date: May 2015
  • Posts: 5
  • Forum Citizenship: +0/-0
surrogate key administration
« on: 23 May 2015 05:13:58 pm »
If I have 3 dimensions for example

Product Category
Product Family
Product Brand

When I create a dimension in Transformer Category / Family / Product

I don't have problems because the surrogate keys of Category and Family never math
they are in different range.

but when I add a new category to my dimension, brand

 Category /Family/ Brand /Product

Here my problems start, because in my business a Brand belongs to different families
so transformer return unique level error.

What can I do in this cases?

by the way, why don't remove the questions, every time you post something, is completely annoying

« Last Edit: 23 May 2015 05:20:25 pm by chepitoleon »

Offline bdbits

  • Super Moderator
  • Statesman
  • ******
  • Join Date: Feb 2010
  • Posts: 1,822
  • Forum Citizenship: +106/-0
Re: surrogate key administration
« Reply #1 on: 26 May 2015 09:28:37 am »
You normally only have one unique level in the hierarchy, typically at the bottom level. "Unique" means _every_ member is unique, like you would have with a key to a table.

From your description, it sounds like maybe your hierarchy should be Category / Brand / Family / Product. The hierarchy in a dimension should represent an actual hierarchy as found in the data. If this is not the reality, maybe Brand should be a different dimension?