Monthly Archives: December 2015

ATTRN TM1 Function: Use and Syntax within TI and Rules

ATTRN stands for ATTRibute Number, in other words it returns the contents of a string attribute from an element in a dimension in TM1. Syntax of ATTRN The syntax is ATTRN (dimension, element, attribute); where: dimension is the dimension you want to interrogate element is the element you want to find the attribute for attribute is the name of the attribute you want to get the result of Usage Assume that … Continue Reading

DataSourceCubeView: Syntax, Use and Example

Another piece of the puzzle of setting up an AsciiOutput is to define a view and then export that view. Why would you do this?  Well, you can either go through a series of IF statements in your metadata or data tab checking each record to see if it satisfies a long list of criteria (e.g. if the Account is Sales and if the Scenario is Actual etc.), or you can … Continue Reading

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 … Continue Reading


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 … Continue Reading

ViewExtractSkipCalcsSet TM1 Function: Syntax and Use

Allows you to skip Consolidated (or rolled up) values when using an AsciiOutput in a TM1 TI process.

ViewExtractSkipRuleValuesSet TM1 Function: Syntax and Use

This is one of a set of functions that define the behaviour of a Turbo Integrator AsciiOutput. The ViewExtractSkipRuleValuesSet function sets the output to either extract rule calculated values or not, depending if a flag is set (0 for export, 1 for skip). It is the equivalent of the Skip Rule Calculated Values option in the View Extract dialog box. If you want to skip Consolidated (as distinct from Rule Calculated) … Continue Reading

CellGetS TM1 Function: Use and Syntax

CellGetS gets a string from a specific intersection of a cube from within a Turbo Integrator process. It can be used as in a similar way to a DB function in a TM1 Rule. Also, don’t confuse it with ‘GetCellN’ (which retrieves numbers) – that just won’t work with strings! Syntax of CellGetS The syntax is CellGetS (Cube, element1, element2, elementn ); where cube is the cube you want to get a number from element1 is an element from the … Continue Reading

How to Create Headers in AsciiOutput

I was creating a text file the other day using AsciiOutput and then realised that I needed to have a header line in there with column headers. The column headings are useful for then uploading into an external database with some confidence that each column is what you expect and also can form the identifiers in a subsequent TI to reload the data into TM1. Method to Create Headers in AsciiOutput … Continue Reading

WHILE TM1 Function: Syntax and Use

Sometimes in a TI process we need to run loops. This is often done to aggregate data prior to loading or exporting. The TI process we use for this is called WHILE and it will force a set of commands to repeat until the condition set becomes invalid. Syntax of While WHILE ( logical expression); TI statement1; TI statement2; TI statement n; END; Example Here we want to export both monthly … Continue Reading

Creating Dynamic Subsets in TM1

Have you ever needed to have a TM1 subset that automatically includes all elements? What, I hear you say, doesn’t that always occur? Well no.  You can have static subsets (which is the default), or you can make dynamic subsets using MDX. And it’s easy! How to Create Dynamic Subsets using MDX Open Subset editor Turn on View, Expression Window Tools, Record Expression Manipulate elements to what you want Tools, … Continue Reading