Data Import with different level hierarchy
I have a data hub model from where data is exported to multiple spoke models.
Hierarchy in data hub is as follows
Whereas in one of spoke model the hierarchy is as below
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.