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

AttrPutN TM1 Function: Syntax and How to Use

AttrPutN is a TM1 Turbo Integrator function that inserts a numeric value onto a specific attribute for the current element in a specified dimension. Note that this function does not insert a string into an attribute. To insert a string value into an attribute please see AttrPutS.

Note this is not AttPutN. It has an “r” in it!

Syntax of AttrPutN

The syntax is AttrPutN(Value, DimName, ElName, AttrName, [LangLocaleCode] );
  • value, is the number that you want to insert
  • dimname, is the dimension that you want to update
  • elname, is the element in the dimension that you want to update
  • attrname, is the attribute of the dimension that you want to update

Usage

AttrPutN is used for assigning a specified attribute to an element in a dimension.  For example if we define a couple of variables:

vDim = 'Map Factory'; 
vAtt = 'Product';
vFactoryTime = 'ABC';
AttrPutN ( 123456, vDim, vFactoryTime, vAtt);

This will place the value 123,456 against the attribute ‘Product’ on the element ABC in the dimension Map Factory.

Note that this will not work when it is combined with a DimensionElementInsert where both are on the Metadata tab. Please see this explanation for more information.

See AttrPutS for inserting the value of a string attribute in the same way that AttrPutN does for a numeric attribute.

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

Post Sections

Related Posts

John Vaughan

John Vaughan

John is a CPA, MBA and has been a Performance Management consultant for over 25 years. He is the founder of ExploringTM1 and highly regarded for his experience combining financial management with corporate planning, reporting and analysis. He lives in Sydney with his wife, two of his three children, their cat, Freckles, a bunch of chooks and some fish. John is a sports nut, who played rugby until he was 40, started playing football at 54 and loves being outdoors.

Leave a Reply

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