Is there a way to have a cross dimension lookup in a parser rule that is associated with a dimension in the Data Source?
Answer
- For example, if Account dimension IsIC=False, map IC dimension to None.
- We want the Account IC lookup happen before the One-to-One mapping.
- OneStream will let you access BRApi.Finance.Account.IsIC() in a Parser Business Rule, so it can be done.
- However, for this to work the account mapping must be a pass through.
- You cannot access the target account member as the mapping has not been processed at this point.
- If the account mapping is a pass through, the below code will replace the source IC field with None during the import step.
-
Please note: It is not best practice to replace source fields during the import step as you lose visibility to the source field.
- Another alternative is to have multiple Account Transformation Rule Groups where:
- One contains IC Lookup rule
- One contains the One-to-One rules
- The rule groups will run in the order in which they’re placed within the Profile, so place them as shown in the order above.
Source: Office Hours 2020-09-27 Partner Enablement
Updated 2 years ago
Version 2.0