Tm1 Alias

[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

[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

[vikram.balaji16]

Thank you soo much

[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;

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

[Wim Gielis]

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

[lotsaram]

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.

[Wim Gielis]

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.

[howard40116]

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