Skip to main content
J
julia2
January 17, 2025
Solved

Newly created dimension member not pulling in data

  • January 17, 2025
  • 2 replies
  • 0 views

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?

Best answer by SimonHesford

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.

2 replies

S
SimonHesfordAnswer
January 17, 2025

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.

J
julia2Author
January 17, 2025

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

 

Terms & ConditionsAccessibility statement