The Bean Blog

Making Sense of the Multidimensional Nature of Data

Where is my Hierarchy?
January 14, 2014 · By Chris Chase ·

~~Have you ever found yourself in a position where your dimension hierarchy in an application suddenly disappeared, or you somehow moved a member from the Shared dimension library to the application level? The good news is that it’s not your fault; there is a bug in EPMA that allows a member to be moved from the shared dimension library to the application level without any prompt, verification or dialog box. A member can be moved to the application level and replace the entire dimension hierarchy without asking for permission or giving any type of notification. 
Luckily, there is a verification process and a fix that can be applied before deploying the application. This process is done through the compare feature in the application library. Before making any changes to a deployed application you should compare the current application to the deployed application, make note of any changes then proceed with your updates. After making your updates, you need to rerun the process to verify that nothing other than your intended updates has changed. If you notice that a number of members have been unintentionally excluded, DO NOT DEPLOY. In this case, you need to go to the dimension library and exclude the member that replaced the dimension hierarchy at the application level. After excluding the member, the hierarchy should reappear.
The steps below outline the member clearing issue:
1. Before working on any application, use the compare feature to check status, updates, etc.

2. Check for any Removes or Excludes. 

3. When a member is moved from the shared library to the application level. 



4. When comparing the current to the deployed application it appears that the hierarchy is excluded but, it’s not!


5. To get the hierarchy back, exclude the member that replaced the hierarchy.

In conclusion, we always recommend using the compare feature. It provides a list of any changes that have taken place and gives you greater control of the application. On another note, we have documented the bug with Oracle and they said they were working on it.
If you have any questions, please post a comment or feel free to contact me at




0 responses