Recovering when an N element has been made a consol

Ideas and tips for enhancing your TM1 application
Post Reply
User avatar
paulsimon
MVP
Posts: 808
Joined: Sat Sep 03, 2011 11:10 pm
OLAP Product: TM1
Version: PA 2.0.5
Excel Version: 2016
Contact:

Recovering when an N element has been made a consol

Post 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
User avatar
gtonkin
MVP
Posts: 1192
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: Latest and greatest
Excel Version: Office 365 64-bit
Location: JHB, South Africa
Contact:

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

Post by gtonkin »

Interesting that it worked-will hopefully commit to my memory, just in case I need a miracle one day. Thanks for sharing.
User avatar
Alan Kirk
Site Admin
Posts: 6606
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

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

Post 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.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
User avatar
jim wood
Site Admin
Posts: 3951
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

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

Post by jim wood »

Very useful indeed Paul, thanks.
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Wim Gielis
MVP
Posts: 3098
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

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

Post by Wim Gielis »

Thanks Paul, will be handy.
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
User avatar
Elessar
Community Contributor
Posts: 328
Joined: Mon Nov 21, 2011 12:33 pm
OLAP Product: PA 2
Version: 2.0.9
Excel Version: 2016
Contact:

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

Post by Elessar »

Hello and thanks,

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

TM1 and Data Science blog: 6th article - PAfE + VBA: Commit each cell without pressing “Commit” button.
Post Reply