Forum Discussion

YahyaOS's avatar
YahyaOS
New Contributor II
8 months ago

Advanced Transformation rules mapping and Dimension Library

Hello Everyone, I'm trying to build an advanced transformation rule based on a member present in my dimension. For example, I want to bypass all lines that contain a member not existing in my UD3...
Data Integration
Transformation
Steven's avatar
Steven
Contributor II
8 months ago

Use BRApi.Finance.Metadata.GetMember.

If this is Nothing, then Bypass

Else

Return MemberName

 

  • YahyaOS's avatar
    YahyaOS
    New Contributor II
    8 months ago

    Thank you, Steven, for your help.

    Could you please provide more details( an example if possible)?, as I am new to OneStream, should I implement this in a complex expression in my Transformation Rule (TR) or in a Business Rule?

    Best regards,

    Yahya

    • Steven's avatar
      Steven
      Contributor II
      8 months ago

      Something like this:

       

       

      Dim UD3 As String = args.GetSource("UD3#")
      Dim UD3Final As String = String.Empty
       
      Dim mem As Member =  BRApi.Finance.Metadata.GetMember(si, dimTypeId.UD3, UD3)
       
      If mem is Nothing Then 
       
      UD3Final = "(BYPass)"
       
      End If
       
      return UD3