Incorrect data in hierarchy

[rangasubhe]

Hi,

I am getting incorrect hierarchy when specify consolidation/element with the below.

Source Data:

Code: Select all

City		Country		User
NewYork		US		  David
London		UK		  David
Bangalore	INDIA		David
Pune		INDIA		  Marc 

My hierarchy is User -> Country -> City
I set the User and Country as consolidation and City as element. But in return when i check the dimension i am getting the below

Code: Select all

David
	US
		NewYork
	UK
		London
	INDIA
		Bangalore
		Pune
Marc
	INDIA
		Bangalore
		Pune

For David the city Pune is mapped and for Marc the city Bangalore is mapped in dimension, but which is not the case. Am i doing something wrong? Please help me with your suggetions. Thanks in advance.

[jim wood]

Are you using dimension destroy before you create the hierarchy? It may be inheriting something you had there previously?

[rangasubhe]

I tried with and without dimension destroy.. But still the result is same.

[Steve Rowe]

What you are seeing is exactly what I would expect.

Bangalore is a child of INDIA is a child of David
Pune is a child of INDIA is a child of Marc

But Bangalore and Pune are both children of India which is why the consolidation is why you see what you see. You can't have two different Indias.

Depending on what you want to do you either need two different hierarchies one that does Geography and one that does "Owner" or make one of the Owner/Geographies an attribute or something like this.

City Country User
NewYork US David
London UK David
Bangalore INDIA David
Pune INDIA1 Marc
INDIA1 INDIA
But that's not nice.

Anyway you need to think about what you are trying to achieve and firgure out what you need to build on that basis.

Cheers,