Planning Analytics

 View Only
  • 1.  Unable to create a hierarchy

    Posted Fri June 14, 2024 01:20 PM

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

    Attachment(s)

    csv
    test_SG.csv   68 B 1 version


  • 2.  RE: Unable to create a hierarchy

    IBM Champion
    Posted Mon June 17, 2024 02:29 AM

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



  • 3.  RE: Unable to create a hierarchy

    Posted Wed June 19, 2024 03:49 PM
    Edited by Venkata Nori Wed June 19, 2024 03:53 PM

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



  • 4.  RE: Unable to create a hierarchy

    Posted Wed June 19, 2024 03:52 PM

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



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



  • 5.  RE: Unable to create a hierarchy

    Posted Wed June 19, 2024 03:55 PM

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



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



  • 6.  RE: Unable to create a hierarchy

    Posted Mon June 17, 2024 07:49 AM

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



  • 7.  RE: Unable to create a hierarchy

    IBM Champion
    Posted Mon June 17, 2024 01:48 PM

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