Forum Discussion

YahyaOS's avatar
YahyaOS
New Contributor II
11 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
11 months ago

Use BRApi.Finance.Metadata.GetMember.

If this is Nothing, then Bypass

Else

Return MemberName

 

YahyaOS's avatar
YahyaOS
New Contributor II
11 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
    11 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