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
'OldCubeLogChanges'
-
- MVP
- Posts: 3118
- 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'
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).
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
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
- Elessar
- Community Contributor
- Posts: 340
- Joined: Mon Nov 21, 2011 12:33 pm
- OLAP Product: PA 2
- Version: 2.0.9
- Excel Version: 2016
- Contact:
Re: 'OldCubeLogChanges'
Welcome Ben, congratulations, your 1st post is the 10000s topic in TM1 forum (without subforums)!!
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
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.
TM1 and Data Science blog: 6th article - PAfE + VBA: Commit each cell without pressing “Commit” button.
-
- Community Contributor
- Posts: 248
- Joined: Tue Nov 01, 2011 10:31 am
- OLAP Product: TM1
- Version: All
- Excel Version: All
- Location: Manchester
- Contact:
Re: 'OldCubeLogChanges'
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
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
-
- Posts: 3
- Joined: Tue Aug 29, 2017 7:14 am
- OLAP Product: Architect / Perspectives
- Version: 10.2
- Excel Version: 2013
Re: 'OldCubeLogChanges'
Thanks for your help guys.
Having come across from EP, This forum is essential reading.
Cheers
Ben
Having come across from EP, This forum is essential reading.
Cheers
Ben