Skip to main content
Newcomer
Jul 27, 2022 1:54 PM UTC
Solved

Transformation Rule mapping based on a target of another dimension

Hi All,

Can we build a transformation rule with a logic that if the target of lets say UD4 is 'xxxx' and source Account number is 'yyyy' then UD3 gets mapped to a particular code?
To simplify- Need to look at Target for UD4 and Source for Account to map to a specific UD3.

Thanks.

Contributor
Aug 1, 2022 3:42 AM UTC

Are you still trying to figure this out? You can create a complex expression on a mask rule and utilise args.GetSource & args.GetTarget, e.g. below syntax return the values you asked about.

args.GetSource("A#")
args.GetTarget("UD4#")

2 replies

Contributor
Jul 27, 2022 7:25 PM UTC

Hi Mayank: I think a Conditional BR will be required, check out the solution proposed by Sal in this post. https://community.onestream.com/topic/show?tid=1902&fid=9

-db

Contributor
Aug 1, 2022 3:42 AM UTC

Are you still trying to figure this out? You can create a complex expression on a mask rule and utilise args.GetSource & args.GetTarget, e.g. below syntax return the values you asked about.

args.GetSource("A#")
args.GetTarget("UD4#")