Replacing Smartview Excel Reports after Renaming the GL Hierarchy

Summary:

We are updating our GL Hierarchy Parent Node. We pushed this data from EDMCS to our ERP dev environment and we are attempting to help the accounting team replace their existing Smartview reports with the updated hierarchy names which is successful but when we refresh the data, we get zeros in the numerical fields. Has anyone completed a hierarchy update and converted Smartview reports from an ERP instance?  

Content (required):

Version (include the version you are using, if applicable):

Smartview Essbase

Code Snippet (add any code snippets that support your topic, if applicable):