Forum Discussion

julia2's avatar
julia2
New Contributor II
2 days ago

Newly created dimension member not pulling in data

I created a new dimension member as a child of our direct_department member in UD2.  I have updated all of the transformation rules and mirrored the member properties of its siblings.  I have loaded this month's data which includes the new department and none of that department's data is showing up following the load/transform process.  I'm not receiving any errors either.  Has anyone experienced this or has an idea of where I can look to resolve the issue?

  • In your Import workflow what member has the source value for the new department been mapped to? Locate a record with the new department in the Import step and right click on the row and choose the View Transformation Rules option. If your new member is a base member and you have mapped your new source department to it there is no reason the data shouldn't be present if no errors are reported.

  • In your Import workflow what member has the source value for the new department been mapped to? Locate a record with the new department in the Import step and right click on the row and choose the View Transformation Rules option. If your new member is a base member and you have mapped your new source department to it there is no reason the data shouldn't be present if no errors are reported.

  • julia2's avatar
    julia2
    New Contributor II

    Thank you! I reloaded the data this morning and turns out that the ERP data hadn't refreshed prior to my previous import.  It's working now