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
Recovering when an N element has been made a consol
- gtonkin
- MVP
- Posts: 742
- 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
Interesting that it worked-will hopefully commit to my memory, just in case I need a miracle one day. Thanks for sharing.
- Alan Kirk
- Site Admin
- Posts: 6002
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2 Classic (PAW-free zone)
- Excel Version: 2010 and 2016
- Location: Sydney, Australia
- Contact:
Re: Recovering when an N element has been made a consol
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.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
- jim wood
- Site Admin
- Posts: 3749
- 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
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
Application Consulting Group (ACG) TM1 Consulting
OS: Windows 10 64-bit. TM1 Version: 10.2.2
-
- MVP
- Posts: 2278
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1
- Version: PAL 2.0.8
- Excel Version: Office 365 - latest
- Location: Brussels, Belgium
- Contact:
Re: Recovering when an N element has been made a consol
Thanks Paul, will be handy.
Best regards,
Wim Gielis
Excel Most Valuable Professional, 2011-2014
http://www.wimgielis.com ==> 109 TM1 articles and a lot of custom code
Newest blog article: Set up a TM1 model with AutoHotKey as a service or application
Wim Gielis
Excel Most Valuable Professional, 2011-2014
http://www.wimgielis.com ==> 109 TM1 articles and a lot of custom code
Newest blog article: Set up a TM1 model with AutoHotKey as a service or application
- Elessar
- Regular Participant
- Posts: 169
- 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
Hello and thanks,
I think "RulesOverwriteCellsOnLoad" can affect this: like deleting data by a rule. Is it turn ON on your server?
I think "RulesOverwriteCellsOnLoad" can affect this: like deleting data by a rule. Is it turn ON on your server?
Sorry for my English ;)