Forum Discussion

Jeevan's avatar
Jeevan
New Contributor II
4 days ago

Map source account to target account member and Ud4 member

Hi Everyone,  I have a source file which contains multiple accounts in the columns for one month. These accounts are not there in the cube. I do not have a ud4 dimension in the source file. Each so...
Connectors
Extenders
Finance
Parsing
XFBR
jrc-dk's avatar
jrc-dk
New Contributor
3 days ago

Hello,

In your transformation rules, you should use a composite transformation when mapping to UD4 dimension and a normal 1:1 mapping when you transform the account dimension. 

So account A001 in source maps to a1 in target (1:1 rule) account dimension

U4 transformation rule: Composite: A#[a001] maps to Cost UD4 target member.

Refer to composite mapping in the handbook.

Br

Jesper