Where did my members go?

Recently, we encountered an odd error in a Hyperion Life Cycle Manager 11.1.2.1 environment, where the primary instance of a member was incorrectly deleted upon importing an Account dimension into both ASO and Planning EPMA applications.  An alternate hierarchy requiring some changes had some shared members removed, and the dimension was then migrated between a development and production environment. Upon initial import, the primary instance was deleted, even though it still existed in the import package and the target environment. This is, of course, dangerous due to the nature of the data loss that occurs when a primary instance of a member is deleted and the application subsequently deployed.

Compare to the rescue!

A simple compare is what can prevent data loss from occurring when this glitch has taken place.    After you have run the LCM dimension import to your target environment, but before you deploy the application, go to Application Library  -> Right-Click on your Application -> Compare -> Compare To Deployed Application

The missing primary instances will be very prominently noted as deletes, which should aid in investigation. Although this issue has potentially very damaging implications, the fix is rather simple. Simply import the dimension with the deleted shared members again (for a second time), and the missing primary instance magically reappears! As long as the application(s) were not deployed with the primary instance missing, nothing will have been hurt and no data loss will have occurred.

Questions?  Comments?   Feel free to reach us at:

Eric Milbrandt, emilbrandt@ecapitaladvisors.com

Amy Stine, astine@ecapitaladvisors.com

Eric Milbrandt

Eric Milbrandt has been in Finance and Technology roles for over a decade, the latter half has been with eCapital since 2013 where he serves as a project lead and lead developer. Eric is Oracle certified in Hyperion Planning 11 as well as Essbase 11 and has experience working with resources in all corners of the globe through all phases of the implementation process. Eric has also delivered custom FDQM and FDMEE solutions and is passionate about creating dynamic low-maintenance solutions to achieve the most value for his clients.

Comments are closed.