Skip to main content
J
Jeevan
April 12, 2025

Map source account to target account member and Ud4 member

  • April 12, 2025
  • 2 replies
  • 0 views

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

2 replies

J
jrc-dk
April 14, 2025

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

M
MarcusH
April 14, 2025

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

 

Terms & ConditionsAccessibility statement