Member of multiple hierarchies


let’s say I have the following fields in my input data: state, city, gender, name, profit
and I want to have two hierarchies:

  • state -> city -> name
  • gender -> name

to drill down into gender independently of location.

I think it is not possible to map name to both hierarchies, right?. Do I have to import the data (or just the column) twice or is there another solution?


Hi Jan,

You are right, it would not be possible to use same column for two different hierarchies in one dimension (during one import session).
We believe that in this case, the only option would be splitting import into two parts (and create two different dimensions).

Best regards,