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

This entry was posted in Attributes, Rule Functions, TI Functions. Bookmark the permalink. | 1 Comment

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

This entry was posted in TI Functions and tagged ASCIIOUTPUT, DataSourceCubeView. Bookmark the permalink. | Tagged ASCIIOUTPUT, DataSourceCubeView | Leave a comment

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 entry was posted in TI Functions. Bookmark the permalink. | Leave a comment

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

This entry was posted in TI Functions. Bookmark the permalink. | Leave a comment

ViewExtractSkipCalcsSet TM1 Function: Syntax and Use

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

This entry was posted in TI Functions. Bookmark the permalink. | 1 Comment

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. Why would you use it? Two main reasons. The first one … Continue Reading

This entry was posted in TI Functions. Bookmark the permalink. | 2 Comments

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 ‘GetCellS’ – that just won’t work! 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 first dimension of the source cube … Continue Reading

This entry was posted in TI Functions and tagged CellGetN, CellGetS, DB. Bookmark the permalink. | Tagged CellGetN, CellGetS, DB | 1 Comment

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

This entry was posted in TI Coding, TI Data Sources, TI Functions. Bookmark the permalink. | 1 Comment

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

This entry was posted in TI Coding, TI Functions. Bookmark the permalink. | Leave a comment

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

This entry was posted in Dimensions, MDX. Bookmark the permalink. | Leave a comment