Exporting Flat Lists from Saved View from the Hub to Spoke Model and Create Hierarchy

LilyLiuAnaplan

Dear Community,

 

I am building 4 flat lists in the Hub as below. L4 is the lowest level, L3 is L4's parent, L3 is L2's parent and L1 is L2's parent.  The next step would be to create saved views to build Level 1 to Level 4 in the spoke model based on the parent - child relation assigned below.

 

Do I need to build a separate module in the Hub dimensionlized with each list (e.g. one module for L1, one for L2, one for L3 and one for L4) in order for the export to work properly?  Would it be possible to just use the below one module to create all four levels? I am getting a lots of errors for duplicated records when I try to create L2 using just the below. 

 

Many thanks,

 

Lily

jasonblinn

@LilyLiuAnaplan 

You can just use the L4 Module that you have set up. I would recommend creating line items that show the first occurrence of each level so that you can create a filter. ISFIRSTOCCURRENCE() can be found here: https://help.anaplan.com/anapedia/Content/Calculation_Functions/All/ISFIRSTOCCURRENCE.htm

 

From there, create a saved view for ;

- L1 showing the L1 line items, filtered on the First occurrence of L1

- L2 showing the L2 line items, L1 for the parent, filtered on the First occurrence of L2

- L3 showing the L3 line items, L2 for the parent, filtered on the First occurrence of L3

- L4 showing the L4 line items, L3 for the parent, filtered on the First occurrence of L4

 

Then in your spoke model, you can run 4 imports, one from each saved view, and only have the records in the saved views that you need to build the hierarchy. 

 

Let me know if it would be helpful to see a mockup of this.

Jason