'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 »

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: 3105
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: 'OldCubeLogChanges'

Post by Wim Gielis »

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

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: 332
Joined: Mon Nov 21, 2011 12:33 pm
OLAP Product: PA 2
Version: 2.0.9
Excel Version: 2016
Contact:

Re: 'OldCubeLogChanges'

Post by Elessar »

Welcome Ben, congratulations, your 1st post is the 10000s topic in TM1 forum (without subforums)!!
10k.png
10k.png (44.35 KiB) Viewed 3789 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
Best regards, Alexander Dvoynev

TM1 and Data Science blog: 6th article - PAfE + VBA: Commit each cell without pressing “Commit” button.
Edward Stuart
Community Contributor
Posts: 247
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 »

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 »

Thanks for your help guys.

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


Cheers


Ben
Post Reply