Forum Discussion

Sw's avatar
Sw
New Contributor
3 years ago

unmapped item in TB to map to a specific member during the data load

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 
Data Integration
NicolasArgente's avatar
NicolasArgente
Valued Contributor
3 years ago

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

  • Sw's avatar
    Sw
    New Contributor
    3 years ago

    Thanks, could you please tell me what would be the rule expression in my mask mapping in that case

    • NicolasArgente's avatar
      NicolasArgente
      Valued Contributor
      3 years ago

      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 🙂