split one colum to different dimension

[jeffvdt]

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!

[Henning · Accepted solution]

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.