Skip to main content
G
GorkemSenol
Newcomer
July 11, 2023

Transformation rule, Mapping IC based on account property

  • July 11, 2023
  • 3 replies
  • 0 views

Hello,

The data I am loading have a lot of wrong account/IC combinations and my load fails because of those.

I want to create an expression rule to say:

if the 'Is IC Account' property for target account in OneStream is not set to True; then map to IC#None

Else

Do normal mappings.

Any help appreciated

    3 replies

    N
    NicolasArgente
    Veteran
    July 11, 2023

    Hi GorkemSenol 

    It sounds like you do not have quality data in your source for your IC. I would suggest that you solve this in your source.
    An alternative could be to do the "opposite" and map all your accout and then use a mask rule to map all the rest to IC#None using * to None. That would be the easiest option.
    Nic

    G
    GorkemSenolAuthor
    Newcomer
    July 11, 2023
    Thanks Nicolas,
     
    Yes but it's not an option to fix the issues in the source at the moment. I've written an expression to check if the target accounts ICP property is set to True or false. But since this mapping is being picked up by all the lines, the rest of the mappings are completely ignored. I'm sharing my expression below:
     
    'Grab the target account value   
    Dim vaccount As String = args.GetTarget("A#")
    Dim vAcc_ID As Integer = BRApi.finance.members.Getmemberid(si,dimtype.Account.ID,vaccount)
    'Grab the is IC property
    Dim vAccountIC As String = BRApi.Finance.Account.IsIC(si, vAcc_ID).ToString
    Dim vIC As String = args.GetSource("IC#")
    'brapi.ErrorLog.LogMessage(si, vaccountic)
    If (vAccountIC = "FalseValue") Then
    Return "None"
    ' Return args.GetSource("IC#")
     
    Else
    This should allow the mapping for these accounts should be done normally
     
    End If
      N
      NicolasArgente
      Veteran
      July 11, 2023

      I hear you! The problem is then the order of the Transformation. I presume you are using this in a mask rule? Then it means you can not use One To Ones then... remember the order: SourceDerivative, OneToOne, Composite, Range, List, Mask... but if you push this BR to the Mask as it is the last the ones before can not be used. 
      Use the Order in the mask and push your code to be used as the first one....

        S
        Steven
        Contributor
        July 11, 2023

        Also,

        Make sure the Account Dimension is being processed before the IC dimension.  You do this on the Integration tab of the Cube properties:  

        Steven_0-1689080939582.png

         

          Terms & ConditionsAccessibility statement