Empty dimension values (#) not loading into the model

[kashif_abbas1]

Hi there,

I have created a data model for planning. I have successfully loaded the master data in the dimension and now i am loading transaction data.

For any dimension, if the values are empty (210 records), the records are being rejected eventhough the # (unassigned) is always maintained in Dimension master data? What could be the reason?

[Susanne_Helbig · Accepted solution]

Dear @kashif_abbas1,

it's important to have "# - unassigned" as member in your dimension master data, but you also need to do the mapping during data wrangling in the import job.

Create a transform to replace empty with # for dimension cost center

Best regards
Susanne