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 🙂