Error when switching between Fusion Essbase Sources

Summary:

We are building reports in NRCS using Oracle Fusion Essbase as a data source. As we are in development, we have need to switch between different source environments. What we are finding is, although the trees are identical in structure, we are getting an ID reference error after switching (see content section below).

We imagine this is a pointer error due to the different environments. When we look into the tree selector for one of the members in error, it shows that the member is already selected from the tree.

When speaking to a colleague working with FRS reports he was advised to use the migration process to repoint the reports and pick up correct references. With that said, we are not aware of a way to migrate or refactor the reports based on the data source.