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: 629
Joined: Sat Sep 03, 2011 11:10 pm
OLAP Product: TM1
Version: 10.1.1 and 10.2.2
Excel Version: 2013

Recovering when an N element has been made a consol

Post by paulsimon » 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

User avatar
gtonkin
MVP
Posts: 627
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: PAL 2.0.3
Excel Version: 2016 64-bit
Location: JHB, South Africa
Contact:

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

Post by gtonkin » Thu Mar 01, 2018 6:32 pm

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: 5828
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: 9.5.2 64 bit moving to 10.2.2
Excel Version: 2010
Location: Sydney, Australia
Contact:

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

Post by Alan Kirk » Thu Mar 01, 2018 7:04 pm

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: 3599
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: TM1 10.2.2
Excel Version: 2007
Location: 1639 Route 10, Suite 107, Parsippany, NJ, USA
Contact:

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

Post by jim wood » Fri Mar 02, 2018 12:54 pm

Very useful indeed Paul, thanks.
Struggling through the quagmire of life to reach the other side of who knows where.
Application Consulting Group (ACG) TM1 Consulting
OS: Windows 10 64-bit. TM1 Version: 10.2.2

Wim Gielis
MVP
Posts: 1806
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0
Excel Version: 2016
Location: Brussels, Belgium
Contact:

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

Post by Wim Gielis » Sat Mar 03, 2018 10:12 pm

Thanks Paul, will be handy.
Best regards,

Wim Gielis

Excel Most Valuable Professional, 2011-2014
http://www.wimgielis.com ==> 105 TM1 articles and a lot of custom code
Newest blog article: Looping over input files

User avatar
Elessar
Posts: 144
Joined: Mon Nov 21, 2011 12:33 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2010
Location: Russia

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

Post by Elessar » Mon Mar 05, 2018 11:00 am

Hello and thanks,

I think "RulesOverwriteCellsOnLoad" can affect this: like deleting data by a rule. Is it turn ON on your server?
Sorry for my English ;)

Post Reply