Exploring TM1 - a Chartertech Company
Search
Close this search box.

ViewColumnSuppressZeroesSet

This is one of a set of functions that define the behaviour of a Turbo Integrator AsciiOutput. The ViewColumnSuppressZeroesSet function sets the output to either extract zero values values or not, depending if a flag is set (0 for export, 1 for skip).

Syntax ofViewColumnSuppressZeroesSet

ViewColumnSuppressZeroesSet(Cube, ViewName, Flag); where:

  • cube, is the name of the cube that has the view you want to export
  • viewname, is the view in the cue that is to be exported
  • flag, is the setting, either 0 for export zero values, or 1 for skip zero values.

Example

vCubeExport  = 'Sales';

vViewExport = 'Sales Export'

ViewColumnSuppressZeroesSet (vCubeExport , vViewExport , 0);

In this example we have defined  variables for the cube and view to be exported, then used them in the function where we have set the flag to 0, so rule calculated values will be exported.

This function is valid for use in Turbo Integrator processes only.

 

 

  • This field is for validation purposes and should be left unchanged.

Post Sections

Related Posts

Leave a Reply

Your email address will not be published. Required fields are marked *

Log In