About abhi1017

@Misbah    True that. Just gave him another solution wherein the module I have mentioned can be in the hub that would be updated via import from source and then  this would flow into the spoke models as a hierarchy list starting at the top and going down.   ~Abhi ... View more

Hi, 1. Assuming hierarchy as- L1 Cost Center, L2 Account code and L3 Cost pool. 2. Now, try to find a unique code in the source data or create one. Use this unique code to create a numbered list.     P..S: The entire hierarchical data should be present in one excel sheet based on the unique code. 3. Create a module with the dimension of the above-numbered list and import the excel sheet data into a module by creating the respective line items. 4. Create three more line items in the module to find the first occurrence of Cost center, Account Code, Cost Pool. 5. Create saved views. a.) select cost center line item and its code, and add cost center first occurrence in the filter. Import this into the L1 Cost Center list.                                      b.) Similarly for Account Code and Cost Pool, by also adding respective parent lists in the saved views.    Hope this helps.     ~Abhi   ... View more