Page 1 of 1

Recovering when an N element has been made a consol

Posted: Thu Mar 01, 2018 5:16 pm
by paulsimon
Hi

We had a situation today where some old code meant that our base level Balance Sheet Cost Centre had another element inserted under it making it a consolidation and we lost all our Balance Sheet data.

To recover I did the following

a) Amended the process to get the Balance Sheet element back to a base level element. I deleted it using DimensionElementDeleteDirect and re-inserted it using DimensionElementInsertDirect. I am not sure if the use of the Direct version of the functions was significant.

b) Unloaded all cubes using that dimension

c) Browsed them to bring them back in to memory

The result was that the data held against the Balance Sheet Cost Centre came back. This was despite the fact that the server had been shutdown and restarted twice since the dimension change was made. It would appear that the data is still in the .cub file and this approach gets its back. In the past other approaches had not recovered the data, and it was a lengthy process of going back to backups.

Regards

Paul Simon

Re: Recovering when an N element has been made a consol

Posted: Thu Mar 01, 2018 6:32 pm
by gtonkin
Interesting that it worked-will hopefully commit to my memory, just in case I need a miracle one day. Thanks for sharing.

Re: Recovering when an N element has been made a consol

Posted: Thu Mar 01, 2018 7:04 pm
by Alan Kirk
Very useful Paul, thanks. For ones like that you may want to post them straight into Useful Tips. (As an MVP you have access.) I'll shift this one over.

Re: Recovering when an N element has been made a consol

Posted: Fri Mar 02, 2018 12:54 pm
by jim wood
Very useful indeed Paul, thanks.

Re: Recovering when an N element has been made a consol

Posted: Sat Mar 03, 2018 10:12 pm
by Wim Gielis
Thanks Paul, will be handy.

Re: Recovering when an N element has been made a consol

Posted: Mon Mar 05, 2018 11:00 am
by Elessar
Hello and thanks,

I think "RulesOverwriteCellsOnLoad" can affect this: like deleting data by a rule. Is it turn ON on your server?