Planning Analytics

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. 

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

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?

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. 

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?

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. 

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. 

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.