EAL ICP and Value dimensions have member names different from HFM
We have EAL cube based out of HFM. But for the two dimensions ICP and Value the essbase member names are different from the one in HFM. This is on account of
1. Essbase not allowing duplicate names for ICP dimension as same members already exist in Entity dimension
2. Value dimension uses special characters for members. Essbase does not allow that
For 1 and 2 above essbase prefixes FM to each member name as compared to HFM
The challenge with this is that any reports that are made for HFM cannot be reused for Essbase directly. Is there any solution so that the reports created for HFM can be directly reused with the Essbase cube created by only changing the "Connection'.