'OldCubeLogChanges'

Post Reply
teamkenji
Posts: 3
Joined: Tue Aug 29, 2017 7:14 am
OLAP Product: Architect / Perspectives
Version: 10.2
Excel Version: 2013

'OldCubeLogChanges'

Post by teamkenji » Fri Sep 01, 2017 8:21 am

Hi all,

I have seen the following code used in a TI that I'm trying to understand:


PROLOG TAB:
OldCubeLogChanges = CUBEGETLOGCHANGES('FB Loan');
CUBESETLOGCHANGES('FB Loan', 0);


EPILOG TAB:
CUBESETLOGCHANGES('FB Loan', OldCubeLogChanges);


I have also seen "OldCubeLogChanges' referenced in the 'Generated Statements' Section of the TI Tabs

Can anyone give me a basic run down of what is going on here as I cannot find much to do with the 'OldCubeLogChanges' piece.

Thanks for your time .

Regards

Ben

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

Re: 'OldCubeLogChanges'

Post by Wim Gielis » Fri Sep 01, 2017 9:00 am

It's just the name of a variable.
That variable stores the value of 0 or 1, whether logs should be recorded or not. During the process we tend to disable transaction logging (put it to 0) while at the end of the process in the Epilog tab we restore the initial value (taken from the variable).
Best regards,

Wim Gielis

Excel Most Valuable Professional, 2011-2014
http://www.wimgielis.com ==> 104 TM1 articles and a lot of custom code
Newest blog article: Delete a cube and its dimensions

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

Re: 'OldCubeLogChanges'

Post by Elessar » Fri Sep 01, 2017 9:37 am

Welcome Ben, congratulations, your 1st post is the 10000s topic in TM1 forum (without subforums)!!
10k.png
10k.png (44.35 KiB) Viewed 219 times

If you want more information, google about the functions "CUBEGETLOGCHANGES", "CUBESETLOGCHANGES"
The functions change the target cube's logging behavior which is stored in }Cuperpoperties cube, in "Logging" measure
Sorry for my English ;)

Edward Stuart
Community Contributor
Posts: 191
Joined: Tue Nov 01, 2011 10:31 am
OLAP Product: TM1
Version: All
Excel Version: All
Location: Manchester
Contact:

Re: 'OldCubeLogChanges'

Post by Edward Stuart » Fri Sep 01, 2017 10:24 am

OldCubeLogChanges is a variable generated by TM1 as part of the wizard, this is why you see it in the generated statements section.

The wider context is around what needs to be logged and when, it is worth reading through the Operations Guide >System and Performance Monitoring > Logging Transactions to delve into this further

teamkenji
Posts: 3
Joined: Tue Aug 29, 2017 7:14 am
OLAP Product: Architect / Perspectives
Version: 10.2
Excel Version: 2013

Re: 'OldCubeLogChanges'

Post by teamkenji » Wed Sep 06, 2017 4:13 am

Thanks for your help guys.

Having come across from EP, This forum is essential reading.


Cheers


Ben

Post Reply