CubeSetLogChanges TM1 function: Syntax and Example

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…

About John

Managing Director of Infocube. We are a management accounting consultancy that specialises in Business Analytics.

This site uses Akismet to reduce spam. Learn how your comment data is processed.