surrogate key administration

[chepitoleon]

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

[bdbits]

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?