Tm1 Alias

Post Reply
vikram.balaji16
Posts: 17
Joined: Tue Oct 29, 2019 3:50 am
OLAP Product: IBM Cognos
Version: 10.2.2
Excel Version: 1808

Tm1 Alias

Post by vikram.balaji16 » Wed Oct 30, 2019 1:50 pm

How to get an alias name by derving the element name in TM1 turbo integrator process. can some one please help on this

ascheevel
Posts: 85
Joined: Fri Feb 15, 2013 5:49 pm
OLAP Product: TM1
Version: 11.2
Excel Version: 2016

Re: Tm1 Alias

Post by ascheevel » Wed Oct 30, 2019 2:02 pm

Aliases are string attributes, you can use ATTRS to return the attribute value of an element.

https://www.ibm.com/support/knowledgece ... attrs.html

vikram.balaji16
Posts: 17
Joined: Tue Oct 29, 2019 3:50 am
OLAP Product: IBM Cognos
Version: 10.2.2
Excel Version: 1808

Re: Tm1 Alias

Post by vikram.balaji16 » Wed Oct 30, 2019 2:25 pm

Thank you soo much

howard40116
Posts: 6
Joined: Tue Oct 02, 2018 5:35 am
OLAP Product: PAL
Version: PAL 2.0.4
Excel Version: excel 2010
Contact:

Re: Tm1 Alias

Post by howard40116 » Fri Nov 01, 2019 1:25 am

##Reminder

When the alias is the same as the principle element name

You can go to the attribute viewer and the alias column will display the same name as the principle element.

But when you open attribute Cube today, you will find that the cell is blank.

So when you use "ATTRS" and "CELLGET", only the blank is taken.

Remember to add more judgments and take the element name from principle element name.


Example:

Code: Select all


sAlias=ATTRS(sDim,vEle,'Alias');

IF(sAlias@='');
     sAlias=vEle;
ENDIF;



https://github.com/howard40116/Rebellio ... 20note.txt

Wim Gielis
MVP
Posts: 2258
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0.8
Excel Version: Office 365 - latest
Location: Brussels, Belgium
Contact:

Re: Tm1 Alias

Post by Wim Gielis » Fri Nov 01, 2019 8:59 am

howard40116 wrote:
Fri Nov 01, 2019 1:25 am
Remember to add more judgments and take the element name from principle element name.
Or create a generic process that runs once in a while to loop over all dimensions. See whether there are are alias. Populate the empty cells in the }ElementAttributes cube with the element name.

Additional functionality:
- give a cube name and the process only goes through the dimensions of that cube
- treat all hierarchies of the dimensions
- use wildcards in the dimension to treat all dimensions starting with Rpt_* for example

A new Bedrock process might be born 😉
Best regards,

Wim Gielis

Excel Most Valuable Professional, 2011-2014
http://www.wimgielis.com ==> 109 TM1 articles and a lot of custom code
Newest blog article: Set up a TM1 model with AutoHotKey as a service or application

lotsaram
MVP
Posts: 3317
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: Tm1 Alias

Post by lotsaram » Fri Nov 01, 2019 1:48 pm

Wim Gielis wrote:
Fri Nov 01, 2019 8:59 am
A new Bedrock process might be born 😉
Actually I think there might be one already! We already have one in the "consultant toolkit" that basically does exactly this; find blank cells for alias attributes (and Caption regardless whether defined as String or Alias) and populate with principal name.
Ensures that CellGetS and DB return the same value as AttrS.

Of course it's not a bedrock process but it might as well be. There's hardly anything too special about what it is doing.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.

Wim Gielis
MVP
Posts: 2258
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0.8
Excel Version: Office 365 - latest
Location: Brussels, Belgium
Contact:

Re: Tm1 Alias

Post by Wim Gielis » Fri Nov 01, 2019 5:21 pm

lotsaram wrote:
Fri Nov 01, 2019 1:48 pm
Actually I think there might be one already! We already have one in the "consultant toolkit" that basically does exactly this;
I am not aware of the "consultant toolkit" is, I have mine though, in which I have such a process.
Best regards,

Wim Gielis

Excel Most Valuable Professional, 2011-2014
http://www.wimgielis.com ==> 109 TM1 articles and a lot of custom code
Newest blog article: Set up a TM1 model with AutoHotKey as a service or application

howard40116
Posts: 6
Joined: Tue Oct 02, 2018 5:35 am
OLAP Product: PAL
Version: PAL 2.0.4
Excel Version: excel 2010
Contact:

Re: Tm1 Alias

Post by howard40116 » Mon Nov 04, 2019 6:38 am

lotsaram wrote:
Fri Nov 01, 2019 1:48 pm
Wim Gielis wrote:
Fri Nov 01, 2019 8:59 am
A new Bedrock process might be born 😉
Actually I think there might be one already! We already have one in the "consultant toolkit" that basically does exactly this; find blank cells for alias attributes (and Caption regardless whether defined as String or Alias) and populate with principal name.
Ensures that CellGetS and DB return the same value as AttrS.

Of course it's not a bedrock process but it might as well be. There's hardly anything too special about what it is doing.
Maybe Bedrock4 can add this ti for public ,and then we just need setting chore by daily in this bedrock :D :D :D

Post Reply