Load Account Source Value to 2 different Target Accounts with “Data Load mapping”?
Content
We are currently loading data with “Data Load Mapping” to a Custom Cube. Based on Account/CostCenter combination data is loaded to certain accounts.
Is it possible to load one Source Account to 2 different accounts in the Target Cube?
For Example:
* Source: $90,000 in Account AC70001 with CostCenter CC2000. => Target: Account FC80003
* Source $80,000 in Account AC70001 with CostCenter CC3000 => Target: Account FC90002
Now we would like to move the total amount for AC70001 to an additional account FC99999 ($170,000)?
Is that possible? HOW?
0