Text File Export from TM1 – AsciiOutput Functions

When we are exporting from TM1 to a text file there is a set of functions we can set that modify the way the AsciiOutput process behaves.  These include:

Suppress Rule Calculated values or not ViewExtractSkipRuleValuesSet
Suppress Zero values or not ViewColumnSuppressZeroesSet
Suppress Rollup, or Consolidation Calculated values or not ViewExtractSkipCalcsSet
Set the datasource server name DatasourceNameForServer
Set the datasource cube view DatasourceCubeView

These can all be defined prior to starting an AsciiOutput to modify the data set that is exported.

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.