07-11-2023 05:40 AM
Hello,
The data I am loading have a lot of wrong account/IC combinations and my load fails because of those.
I want to create an expression rule to say:
if the 'Is IC Account' property for target account in OneStream is not set to True; then map to IC#None
Else
Do normal mappings.
Any help appreciated
07-11-2023 07:17 AM
Hi @GorkemSenol
It sounds like you do not have quality data in your source for your IC. I would suggest that you solve this in your source.
An alternative could be to do the "opposite" and map all your accout and then use a mask rule to map all the rest to IC#None using * to None. That would be the easiest option.
Nic
07-11-2023 07:22 AM
07-11-2023 07:41 AM
I hear you! The problem is then the order of the Transformation. I presume you are using this in a mask rule? Then it means you can not use One To Ones then... remember the order: SourceDerivative, OneToOne, Composite, Range, List, Mask... but if you push this BR to the Mask as it is the last the ones before can not be used.
Use the Order in the mask and push your code to be used as the first one....
07-11-2023 09:09 AM
Also,
Make sure the Account Dimension is being processed before the IC dimension. You do this on the Integration tab of the Cube properties: