OneStream Community

kustrup · 12-06-2023

I am looking to create a transformation rule for Accounts to map to a destination if the Department on the record is a child of a specific parent in the OS department dimension.ACCT600 DEPT101 --> ACT_EXP600_100ACTT600 DEPT321 --> ACT_EXP600_100Where...

kustrup · 12-11-2023

Thank you for the responses! I was able to resolve the issue with an IF statement: If BRApi.Finance.Members.IsDescendant(si, _ BRApi.Finance.Dim.GetDimPk(si, "DIMENSION_NAME"), _ BRApi.Finance.Members.GetMemberId(si, dimTypeID.UD3, "PARENT_MEMBER"), ...

OneStream Community

User Statistics

User Activity

How to setup transformation rule to map if an item is a child member of a (another) dimension parent

Re: How to setup transformation rule to map if an item is a child member of a (another) dimension pa