cancel
Showing results for 
Search instead for 
Did you mean: 

Changed Dept Dimension Hierarchy, erased all historical data!

shawndemers
Explorer
0 Kudos

Yesterday I made a change to our Department dimension. I changed a base level member (034) to be a "child" to another base-level member (050). I changed the Parent property for 034 to 050 and didn't make any changes to the parent of 050, then saved and processed the Dimension with no problems. We later decided we did not want this to be the structure and changed it back so 034 and 050 were both base level members again. Then I saved and processed the dimension again with no problems.

Now it seems that these changes erased all data for Department 050 for all time periods and all categories! Has anyone else experienced this? If so, do you know a way to correct it? One of our IT people looked at the data tables and the data is not there any more, so we are looking at ways to restore it, but I want to understand why this happened so we can avoid it in the future.

Thanks for any help. FYI, we are on version 7.0.115 for MS in a dual-server environment.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Shawn,

Data can only be saved in base level dimensions. Parent level members are just rollups of base members and cannot store data. By changing member 050 to be a parent, the application removed the records from 050. The only way to get the data back would be to change 050 back to a base member and then restore the records via a backup or reload the data.

Ideally the application would put up a big red flag with a warning that all data is about to be erased when a member is being changed from a base to a parent. I know that an enhancement request for this has been submitted to SAP, but you may want to open a case and submit another which may add more weight to the request.

This is also discussed in SAP Note 1390866.

Thanks,

Scott

Edited by: Scott Bean on Mar 30, 2010 4:39 PM

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

When you change the parent of your member to 050, did 050 had any other children? Currently, how many children, does 050 have? Was there any change in the number of children of 050?

shawndemers
Explorer
0 Kudos

No, 050 didn't have any other children at the time. This was the first one. We've changed it back now so 050 is a base-level member with no children.