Forum Discussion

SC's avatar
SC
New Contributor III
3 years ago

Derivative rules

Hi experts,   I have a group of GL accounts that I need to map to either an expense / revenue based on the sum of the balances. I thought this would be easy enough with a derivative rule; first cr...
Data Integration
Transformation
  • Sai_Maganti's avatar
    Sai_Maganti
    3 years ago

    My guess is that, in order for the first line in your DR to create an aggregation you must use all the dimensions including any attribute dimensions similar to this:

    E#[*]=All_Entities:F#[*]=All_Flow:IC#[*]=All_IC:UD1#[*]=All_UD1:UD2#[*]=All_UD2........:A1#[*]=All_A1:A2#[*]=All_A2......

    This will then create a one line sum for all your specified accounts and assign that sum to A#[Map_SwapProd] and then the next 2 rules should work fine.

SC's avatar
SC
New Contributor III
3 years ago

Hi Nic,

Based on what you suggested, this is what I tried:

 

1. Aggregate the accounts into Map_SwapProd

2. Multiply by 1 and create Map_SwapProd_New

3. Check if Map_SwapProd_New >0 0r <0 and map to Map_SwapProd_Po / Map_SwapProd_Ne

 

In my transformation rule, I then have Map_SwapProd_Po mapped to an expense account and Map_SwapProd_Ne mapped to a revenue account. So, the total balance can either go to an expense or  a revenue account.

 

However, I still see data in both accounts and I can see that the GL accounts with negative balances are mapping to Map_SwapProd_Ne and the GL accounts with +ve balances mapping to Map_SwapProd_Po. This seems strange as I am creating both of them from Map_swapProd_New which should have the aggregate balance.

 

Regards,

S

Regards,

Sounak