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!
Removing alias from subset via TI
-
- MVP
- Posts: 1831
- Joined: Mon Dec 05, 2011 11:51 am
- OLAP Product: Cognos TM1
- Version: PA2.0 and most of the old ones
- Excel Version: All of em
- Location: Manchester, United Kingdom
- Contact:
Re: Removing alias from subset via TI
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.
If you don't need to use TI just untick it in the subset editor then save it.
Declan Rodger
-
- Posts: 5
- Joined: Mon Nov 16, 2009 8:14 pm
- OLAP Product: TM1
- Version: 10.1.1
- Excel Version: 2010
- Location: Chicago
Re: Removing alias from subset via TI
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.
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.
-
- MVP
- Posts: 2836
- Joined: Tue Feb 16, 2010 2:39 pm
- OLAP Product: TM1, Palo
- Version: Beginning of time thru 10.2
- Excel Version: 2003-2007-2010-2013
- Location: Atlanta, GA
- Contact:
Re: Removing alias from subset via TI
Then you're out of luck. The two options given are the only way.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.
-
- Posts: 5
- Joined: Mon Nov 16, 2009 8:14 pm
- OLAP Product: TM1
- Version: 10.1.1
- Excel Version: 2010
- Location: Chicago
Re: Removing alias from subset via TI
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;
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;
-
- MVP
- Posts: 733
- Joined: Wed May 14, 2008 11:06 pm
Re: Removing alias from subset via TI
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.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.
Robin Mackenzie