Removing alias from subset via TI

Post Reply
M1_A1
Posts: 5
Joined: Mon Nov 16, 2009 8:14 pm
OLAP Product: TM1
Version: 10.1.1
Excel Version: 2010
Location: Chicago

Removing alias from subset via TI

Post by M1_A1 »

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!
declanr
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

Post by declanr »

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.
Declan Rodger
M1_A1
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

Post by M1_A1 »

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.
tomok
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

Post by tomok »

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.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
M1_A1
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

Post by M1_A1 »

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;
rmackenzie
MVP
Posts: 733
Joined: Wed May 14, 2008 11:06 pm

Re: Removing alias from subset via TI

Post by rmackenzie »

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.
Robin Mackenzie
Post Reply