Recovering when an N element has been made a consol
Posted: Thu Mar 01, 2018 5:16 pm
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
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