When we run a Turbo Integrator process in TM1, the Transaction Log will normally have a record written for each data change. To speed up the TI, we can turn off transaction logging for a TI using the command CubeSetLogChanges to set the logging properties for a specific cube. It can only be used in a TI process.
Syntax of CubeSetLogChanges
The syntax is:
CubeSetLogChanges ( Cube , LogChanges ); where:
- Cube is the name of the cube that you want to set the logging for, and
- LogChanges is either 0 or 1, where 0 is sets logging off and 1 sets logging on.
Example
A quick example is
Prolog
CubeSetLogChanges ( 'Gross Profit', 0 );
where this turns off the transaction log for the Gross Profit cube while the TI runs.
Epilog
CubeSetLogChanges ( 'Gross Profit', 1 );
where this turns back on the transaction log for the Gross Profit cube after running the TI.
If you like this post, please spread the love…
You must log in to post a comment.