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

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