Skip to Content
avatar image
Former Member

Analytics Cloud Hierarchies

I continue to experience difficulty implementing Analytics Cloud hierarchies (parent-child relationships). I see how a limited number of discrete relationships can be created in the model view by dragging and dropping, but I have a large number of rows and fields that need to be automatically matched. When I try to do this in the Data Integration view and subsequently build a visual, the 'parent' field is never available to chart. Also, I'm curious as to how to structure a multi-layer parent-child relationship (parents of parents, etc.).

Add comment
10|10000 characters needed characters exceeded

  • Hi Matan,

    What do you mean by:

    When I try to do this in the Data Integration view and subsequently build a visual, the 'parent' field is never available to chart ?

    I just tested this simple model text file with a multi-level hierarchy and it loads properly:

    Ent,P1,EntDesc,ACC,VAL

    A,P1A,Adesc,ACC1,10

    P1A,P2A,P1Adesc,ACC1,

    Notice that the second row has an empty data field for the VAL measure.

    I also added descriptions so that an auto-generated ID is not created.

    Mapping:

    Resulting model with PCH Hierarchy:

  • Get RSS Feed

2 Answers

  • Best Answer
    Dec 13, 2017 at 10:46 PM

    With hierarchies, it’s a bit different than your standard format… instead of having multiple columns and indicating the relationship, you just have two columns, the parent and child. But you can have many, many layers of hierarchy (max depth of 1000).
    For example:

    Child Parent

    USA > North America

    Canada > North America

    North America > World

    What someone would see on the end, would be USA>North America>World (all three levels). You could add a forth as well in the same format:

    Child Parent

    California> USA

    USA> North America

    Canada> North America

    North America> World

    This would show as California>USA>North America> World

    Here’s a rather old demo:

    https://www.youtube.com/watch?v=PCmB37gH_nw

    And a much shorter one:

    https://www.youtube.com/watch?v=r1dcVVKUrBo

    Hope this helps!

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 10, 2017 at 07:40 AM

    Hi Matan,

    Creating the hierarchy for large number of rows is quite hard by drag and drop method. I suggest to do that at source level if possible.

    Here is a sample that might help.

    Regards,
    Erdem

    Add comment
    10|10000 characters needed characters exceeded