TM1 Forum

Hi,

We have a big dimension with many elements and many aliases defined for each element.

How can we determine if an alias is already used as alias for different element ? is there a TM1 Api to search element alias ?

by the way, an alias needs to be unique in a dimension level i presume or in entire TM1 model ?

Thanks a lot in advance !

You can use the DIMIX function to do a simple check to see if that name already exists in the dimension but that will just tell you whether it exists be it as an alias or principal name.

If you want to ONLY check if it exists as an alias but not principal name you could always use the DIMIX function and then use either the DimensionElementPrincipalName on the (possible) alias name or a DIMNM on the dimension index and see if it results in the same as the (possible) alias name, if so it is a Principal Element name, if not it is an alias.

tm1novice wrote: by the way, an alias needs to be unique in a dimension level i presume or in entire TM1 model ?

An alias needs to be unique within a Dimension (not the same as other element aliases or principal names) but you can use the same element name within 2 separate dimensions, you just need to be careful when writing rules etc and use full DB refs instead of square brackets refs as to avoid ambiguous element names confusing the scenario.

declanr wrote:you just need to be careful when writing rules etc and use full DB refs instead of square brackets refs as to avoid ambiguous element names confusing the scenario.

That's not necessary. It's only a problem when your rule references specific elements that are not unique and for those you can simply append the dimension name to the element name and join them with a colon, and still use the shortcut method.

Declan , tomok ,

Thanks a lot. That's very helpful !
tm1novice