Data Import with different level hierarchy

KS2703
KS2703
in Integrations and extensibility

Hi All,

 

I have a data hub model from where data is exported to multiple spoke models.

Hierarchy in data hub is as follows

L1
L2

KS2703_0-1663829294119.png

 

Whereas in one of spoke model the hierarchy is as below

L1
L2
L3

KS2703_1-1663829327163.png

 

I want to make a data import from Data Hub to Spoke model for loading the data at L2 level.

The above screenshot in target module is a saved view at L2 level.

 

I don't want to add a dummy L3 level in Data Hub or make any hierarchy changes in Data Hub.

Is there any other way i can import this data ?

Source Module - L2 Dimensioned.
Target Module - L3 Dimensioned.

 

Any assistance on this is highly appreciated.

Tagged:

Best Answer

  • KirillKuznetsov
    KirillKuznetsov
    Answer ✓

    @KS2703 

    You can load data into a parent level (L2) only if you use breakback on this module. But this means that child elements at L3 level will have the source data splited as per breakback rules.

    Otherwise, you can load data from Data hub into a module dimensionned by L2 list as in the source. And then refer to it in L3 module using lookup.

     

Answers

  • KS2703
    KS2703

    @KirillKuznetsov Thanks for the reply.

     

    Option 1 won't be suitable in my case so a i am looking at 2.

    I have loaded data into target module dimensioned at L2 level, But if L3 has multiple children, Lookup fetches the same value for all the children which will increase the total value.

     

    Below is L2 Import.

    KS2703_0-1664171720944.png

     

    Below is Lookup at L3 level.

    KS2703_1-1664171788612.png

     

    Looking forward for your reply.

     

    Thanks

  • Misbah
    Misbah

    @KS2703 

    Do you have L3 data in the data hub but not in a module dimensioned by L2? If you have a module where the data is available in 2D format (just rows and columns)  you could just add L3 attribute in the source module and then use that as a saved view for target.

     

    Hope that helps

    Misbah

    Miz Logix

  • KirillKuznetsov
    KirillKuznetsov

    @KS2703 

    I thought it is what you want  - to spread the same value down to children elements based on the data of thier parents. If not that, then what? Do you want to split this data somehow?

    Could you please make an example of what you are trying to achive? How data from L2 level has to be distribute on L3?

Categories