TM1 Forum

Does anyone have a way to remove an alias from a subset via TI?

It is easy to add an alias using the SubsetAliasSet but I do not see a way to remove it. So far I have tried using SubsetAliasSet and set the alias as '' . That resulted in an error.

Running 10.1.1.

Thanks!

I just delete and rebuild the subset in TI; that will make it use the default name.

If you don't need to use TI just untick it in the subset editor then save it.

Thanks for the reply.

I do not want to destroy the subset in case it is used in a view. I am setting this up so non-admins can maintain some public subsets. So the manual process of un-checking the alias will not work.

Thanks again.

M1_A1 wrote:I do not want to destroy the subset in case it is used in a view. I am setting this up so non-admins can maintain some public subsets. So the manual process of un-checking the alias will not work.

Then you're out of luck. The two options given are the only way.

Here is the work around I developed: I add an temp alias , set the temp alias in the subset , and then delete the alias
This seems to work.

AliasName= CellGetS(sCube, vDim, zSys_Subset_List, 'Alias', 'Element');
IF(AliasName@<>'' & DIMIX('}ElementAttributes_' | vDim, AliasName)<>0);
SubsetAliasSet( vDim, vSubsetName, AliasName );
ElseIf(AliasName@='');
AttrInsert(vDim, '' , 'Temp_Alias' , 'A');
SubsetAliasSet( vDim, vSubsetName, 'Temp_Alias' );
AttrDelete(vDim, 'Temp_Alias');
EndIf;

M1_A1 wrote:I do not want to destroy the subset in case it is used in a view. I am setting this up so non-admins can maintain some public subsets. So the manual process of un-checking the alias will not work.

In the TI that processes the subset, you could create a new, temporary subset and read all the elements that exist in the public subset into the new subset. This won't have the alias attached; it can be used for the duration of the TI and deleted at the end. This way, you can allow your users to maintain the public subsets and still manipulate copies of them during the TI processes without upsetting the users functionality.