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?

Application Properties
Extensibility
Metadata
  • SimonHesford's avatar
    SimonHesford
    15 hours ago

    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
    8 hours ago

    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

     

  • SimonHesford's avatar
    SimonHesford
    Contributor
    15 hours ago

    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.