Recovering when an N element has been made a consol

[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

[gtonkin]

Interesting that it worked-will hopefully commit to my memory, just in case I need a miracle one day. Thanks for sharing.

[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.

[jim wood]

Very useful indeed Paul, thanks.

[Wim Gielis]

Thanks Paul, will be handy.

[Elessar]

Hello and thanks,

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