I created a hierarchy in department dimension called 'Department Service Group'. What I have is just 3 levels- Total Department Function, Department Service Group, Department Code.

When I try to import members from the csv file, I keep getting an error which states "there is a leaf with the same name and cannot be inserted as parent". While I understood the error, I am unable to find a child with the same name. 

To replicate the issue, I created a sample file with just 4 records.

Attaching the sheet & error.

Any inputs will be of great help. 

------------------------------
Venkata Nori
------------------------------

Hi Venkata,

Is it on your first load of the dimension? 

I have tested with your file, and as I would expect, I get no errors when importing to a primary and alternative hierarchy in the same dimension.

Is it on subsequent runs you get the error?

The N level elements can be in another hierarchy. Have you checked the leafs hierarchy for holding your C level elements as N level?

------------------------------
Emil Malmberg Fosdal
Solution Architect
CogniTech A/S
------------------------------

Hi Emil..Yes i got this error on subsequent loads..Yes I figured the cause of the error and deleted the leaf level items which has it..Thanks for your response!

------------------------------
Venkata Nori
------------------------------

Original Message:
Sent: Mon June 17, 2024 02:28 AM
From: Emil Malmberg Fosdal
Subject: Unable to create a hierarchy

Hi Venkata,

Is it on your first load of the dimension? 

I have tested with your file, and as I would expect, I get no errors when importing to a primary and alternative hierarchy in the same dimension.

Is it on subsequent runs you get the error?

The N level elements can be in another hierarchy. Have you checked the leafs hierarchy for holding your C level elements as N level?

------------------------------
Emil Malmberg Fosdal
Solution Architect
CogniTech A/S
------------------------------

Hi George @George Tonkin I am able to resolve this error..thanks for the response!

------------------------------
Venkata Nori
------------------------------

Original Message:
Sent: Mon June 17, 2024 02:28 AM
From: Emil Malmberg Fosdal
Subject: Unable to create a hierarchy

Hi Venkata,

Is it on your first load of the dimension? 

I have tested with your file, and as I would expect, I get no errors when importing to a primary and alternative hierarchy in the same dimension.

Is it on subsequent runs you get the error?

The N level elements can be in another hierarchy. Have you checked the leafs hierarchy for holding your C level elements as N level?

------------------------------
Emil Malmberg Fosdal
Solution Architect
CogniTech A/S
------------------------------

Hi Ryan @Ryan Sinclair Thanks for the response..I am able to resolve the issue now.

------------------------------
Venkata Nori
------------------------------

Original Message:
Sent: Mon June 17, 2024 02:28 AM
From: Emil Malmberg Fosdal
Subject: Unable to create a hierarchy

Hi Venkata,

Is it on your first load of the dimension? 

I have tested with your file, and as I would expect, I get no errors when importing to a primary and alternative hierarchy in the same dimension.

Is it on subsequent runs you get the error?

The N level elements can be in another hierarchy. Have you checked the leafs hierarchy for holding your C level elements as N level?

------------------------------
Emil Malmberg Fosdal
Solution Architect
CogniTech A/S
------------------------------

HI Venkata,

Are you getting the error when using the attached file for a new dimension build? If so, perhaps you can screenshot or share your TI Code.

My initial thought is that your full dimension build has an alias being created/added to the elements which would cause you to be unable to "find" the element but still get the resulting error. You can always try pasting the element into the subset editor, if it is an alias it should show as valid and give you the principal element name. 

------------------------------
Ryan Sinclair
------------------------------

HI Venkata, per Emil's response, you will probably find the member in the Leaves dimension.

Open up the set editor on the Leaves dimension then paste in the alias to see which member is returned.

This can easily happen when testing and deleting all members then later inserting other members where there is a clash.

------------------------------
George Tonkin
Business Partner
MCI Consultants
Johannesburg
------------------------------