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!
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
Original Message:
Sent: Fri June 14, 2024 01:19 PM
From: Venkata Nori
Subject: Unable to create a hierarchy
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
------------------------------