The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

OSAdmin's avatar
OSAdmin
Icon for OneStream Employee rankOneStream Employee
6 years ago

I have a file with two amount columns that I need each amount to go to different flow members

Originally posted by Jon Golembiewski 3/11/2020 Got a data source puzzler - I have a file with two amount columns that I need each amount to go to different flow members. The first amount will al...
Data Sources
OSAdmin's avatar
OSAdmin
Icon for OneStream Employee rankOneStream Employee
6 years ago
Originally posted by Puja Patel

This might be a long winded way. But keeping with the matrix data source:

1. Amnt in LOC Crcy --> (Static Value of EUR in Data Source) - Matrix DataKey for Flow Source Dimension

2. Amnt in DOC Crcy --> (Static Value of [RandomMember] in Data Source) - Matrix DataKey for Flow Source Dimension

3. Document currency --> assign to an enabled Attribute (e.g. A1)

In transformation rules,

1. Use composite mappings - e.g. A1#AED:F#[RandomMember] maps to Target F#AED

2. Can use a passthru mask rule of * to * for your Amnt in LOC Crcy mappings.