Page 1 of 1
Tm1 Alias
Posted: Wed Oct 30, 2019 1:50 pm
by vikram.balaji16
How to get an alias name by derving the element name in TM1 turbo integrator process. can some one please help on this
Re: Tm1 Alias
Posted: Wed Oct 30, 2019 2:02 pm
by ascheevel
Aliases are string attributes, you can use ATTRS to return the attribute value of an element.
https://www.ibm.com/support/knowledgece ... attrs.html
Re: Tm1 Alias
Posted: Wed Oct 30, 2019 2:25 pm
by vikram.balaji16
Thank you soo much
Re: Tm1 Alias
Posted: Fri Nov 01, 2019 1:25 am
by howard40116
##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;
Re: Tm1 Alias
Posted: Fri Nov 01, 2019 8:59 am
by Wim Gielis
howard40116 wrote: ↑Fri Nov 01, 2019 1:25 amRemember 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
Re: Tm1 Alias
Posted: Fri Nov 01, 2019 1:48 pm
by lotsaram
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.
Re: Tm1 Alias
Posted: Fri Nov 01, 2019 5:21 pm
by Wim Gielis
lotsaram wrote: ↑Fri Nov 01, 2019 1:48 pmActually 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.
Re: Tm1 Alias
Posted: Mon Nov 04, 2019 6:38 am
by howard40116
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
