ATTRN TM1 Function: How to 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. Note this is not AttrGetN! That function does not exist! Syntax of ATTRN The syntax is: ATTRN (dimension, element, attribute); where: dimension is the dimension you want to interrogate element is the […]
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. […]
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 […]