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
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?