Validation Errors mapping to placeholder
Hey Folks,
I am looking to map all validation errors that might occur during an automated load to a placeholder member in the UD1 dimension, but i am running into issues as the mask rule approach i...
Forum Discussion
See this post: Is there a way to load data with validation errors | OneStream Community.
To do this all members that are valid need to have 1 for 1 mappings or mask mappings before your "catchall" and then your catch all can go to an unknow or NoU1 member.
Thanks i tried that approach but for some odd reason it won't work for me , see below the screenshot , i am using the order of operation to mask all source projects in UD2 dimension to their targets (if they exist), when something doesn't exist i am using a "CatchAll" value to map those.
However the validation step still kicks out when a new project comes in and it doesn't exist in the UD2/Project dimension.validation error with the above mask "catchAll" rule in place for UD2 dimension
The first map (StarToStar) will assign a target value to all source records on the UD2 dimension. That means that any subsequent maps that are executed will not make a change - in effect they do not execute. In order to get this to work you need to delete the StarToStar map and then (as T_Kress says) use one to one maps or any other map. Then the CatchAll map will execute and assign a value for any source records that do not have a target value assigned ie the source record has not been matched by any of the previous maps.
As MarcusH mentioned, your two mappings are identical in terms of the "Rule Expression". Basically only the first one will run because, by nature, a mapping rule means everything that did not get captured in any PRIOR rules like prior 1:1, prior complex expressions, prior ranges and prior mask mappings that happen before the final mapping.
What you want is to map all valid mappings first, either via 1:1 or mask mappings that happen FIRST, then your catch all should be to UNKNOW_U1 or something, not to .
You should have only one mapping that is rule expression "*" and then map it to None or UNKNOWN_U1 or something.
