on 11-07-2017 10:26 PM
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.).
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!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.