Update the Alias using TI or Worksheet

Post Reply
ExApplix
Posts: 103
Joined: Mon Sep 21, 2009 7:09 pm
OLAP Product: Cognos Tm1
Version: 10.2.2
Excel Version: 2016

Update the Alias using TI or Worksheet

Post by ExApplix »

I want to update the value to my Element Alias using TI or Worksheet.

Is there any Tm1 function which I can use?

Please reply ASAP

Thanks in advance
User avatar
Alan Kirk
Site Admin
Posts: 6610
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: Update the Alias using TI or Worksheet

Post by Alan Kirk »

ExApplix wrote:I want to update the value to my Element Alias using TI or Worksheet.

Is there any Tm1 function which I can use?

Please reply ASAP
As per the request for assistance guidelines, you didn't include
a brief outline of what you've done to find the answer; which manuals or guides you've looked in,


The Reference Material section of the on-line help would be the fastest location to find AttrPutN, AttrPutS and and DBSA.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
User avatar
rkaif
Community Contributor
Posts: 328
Joined: Fri Sep 05, 2008 6:58 pm
OLAP Product: IBM Cognos TM1
Version: 9.1 or later
Excel Version: 2003 or later

Re: Update the Alias using TI or Worksheet

Post by rkaif »

You can use the ATTRPUTS function to update the Attribute. Following is the syntax:

Code: Select all

AttrPutS(Value, DimName, ElName, AttrName);
Cheers!
Rizwan Kaif
User avatar
wissew
Posts: 54
Joined: Tue Jun 17, 2008 7:24 pm
OLAP Product: TM1
Version: 9.5.2; 10.2.2; 11
Excel Version: 2003 SP3 - 2013
Location: Beaverton, OR

Re: Update the Alias using TI or Worksheet

Post by wissew »

RTFM

:twisted:
Post Reply