Forum Discussion

jeffvdt's avatar
jeffvdt
New Contributor II
6 months ago

split one colum to different dimension

Hi All,

 

How can we map one source column (from our old EPM system) to two different dimensions in onestream (Flow and UD2)

In this column we have for example acdclosing whichs need to be mapped to the flow dimension but acdCD needs to me mapped to the UD2.

 

Thanks in advance for the help!

Data Integration
  • Henning's avatar
    Henning
    6 months ago

    Hi, unfortunately I do not see your screenshot, if there is one.

    You can just assign the same source column to two different target dimensions and map those accordingly. One mapping for flow, one for UD2.

    You can achieve that by assigning the same column number here:

     

    In this example, the ERP source account column is assigned to the target dimensions account and flow. Flow mappings can then be build on accounts. You can apply the same logic to your use case.

     

  • Henning's avatar
    Henning
    Valued Contributor II
    6 months ago

    Hi, unfortunately I do not see your screenshot, if there is one.

    You can just assign the same source column to two different target dimensions and map those accordingly. One mapping for flow, one for UD2.

    You can achieve that by assigning the same column number here:

     

    In this example, the ERP source account column is assigned to the target dimensions account and flow. Flow mappings can then be build on accounts. You can apply the same logic to your use case.