Forum Discussion

Jeevan's avatar
Jeevan
New Contributor II
3 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 source account should be mapped to an account and Ud4 member.

for ex: Account a001 has to be mapped to account A#a1 and Ud4#cost. Similarly Account b001 has to be mapped to account b#b1 and Ud4#sale.

A#[a001]=A#[a1]:UD4#[cost]

A#[b001]=A#[b1]:UD4#[sale]

How can this be achieved in the transformation rule. Also, the data source needs to have ud4 or not.

Thanks,

Jeevan

Connectors
Extenders
Finance
Parsing
XFBR
  • jrc-dk's avatar
    jrc-dk
    New Contributor
    2 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

  • MarcusH's avatar
    MarcusH
    Valued Contributor
    15 hours ago

    You would only need a composite rule if the UD4 for the source account varied but I can't see that this is the case. I suggest you edit the UD4 on the Data Source and point it to the source account. Then in Account maps you have:

    Source    Target
a001    -> a1
b001    -> b1

    And in UD4 maps you have:

    Source    Target
a001    -> cost
b001    -> sales