06-17-2022 02:10 AM
Hi,
Do we have a mechanism to map unmapped item to a holding member ( specific member of the dimension) during the data load to prevent data load failure.
Thanks
06-17-2022 02:17 AM
Hi Sw,
That is what the validation is for. It is all about data quality before reaching the cube. To check that everything is mapped correctly. In your case you could map the unmapped item to a specific member using a mask rule.
Thanks
06-17-2022 02:22 AM
Thanks, could you please tell me what would be the rule expression in my mask mapping in that case
06-17-2022 02:29 AM
Sure. Let's say you have unmapped items and you want them to be mapped to TEMP member, then in your mask rule you would have :
Please give kuddos for helping 🙂