STEPS ON HOW TO DELETE A PRIVATE SUBSET IN TM1

Post Reply
segunfunwaoluwa
Posts: 13
Joined: Wed Dec 07, 2011 4:18 pm
OLAP Product: cognos tm1
Version: 9.5.2
Excel Version: 2007

STEPS ON HOW TO DELETE A PRIVATE SUBSET IN TM1

Post by segunfunwaoluwa »

Hi everybody,
I would appreciate it if anyone could show me the steps to use in deleting a 'private subset' in tm1.I have gone through the TM1 online documents and all it shows are the functions to call but not the steps on how to go about doing the delete.Pointers anyone?
Thanks
Segun
User avatar
Steve Rowe
Site Admin
Posts: 2456
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: TM1 v6,v7,v8,v9,v10,v11+PAW
Excel Version: Nearly all of them

Re: STEPS ON HOW TO DELETE A PRIVATE SUBSET IN TM1

Post by Steve Rowe »

It can't be done as an admin, only as the user concerned through the front end, or by directly in file system which will break any assocaited views.
Cheers
Technical Director
www.infocat.co.uk
segunfunwaoluwa
Posts: 13
Joined: Wed Dec 07, 2011 4:18 pm
OLAP Product: cognos tm1
Version: 9.5.2
Excel Version: 2007

Re: STEPS ON HOW TO DELETE A PRIVATE SUBSET IN TM1

Post by segunfunwaoluwa »

Thanks Steve for the reply,could you please elaborate the steps the user needs to follow to do the delete?
Thanks.
Segun
lotsaram
MVP
Posts: 3702
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: STEPS ON HOW TO DELETE A PRIVATE SUBSET IN TM1

Post by lotsaram »

segunfunwaoluwa wrote:Thanks Steve for the reply,could you please elaborate the steps the user needs to follow to do the delete?
Thanks.
Segun
Huh? How about "use the delete key".
Wim Gielis
MVP
Posts: 3230
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.1.5
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: STEPS ON HOW TO DELETE A PRIVATE SUBSET IN TM1

Post by Wim Gielis »

Segun

Let the user navigate in the Server Explorer to the respective dimension and subset.
Select it and click Delete.

That's it.

Please do not use all capital letters in your topic title. Thanks.
Best regards,

Wim Gielis

IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Alan Kirk
Site Admin
Posts: 6647
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: STEPS ON HOW TO DELETE A PRIVATE SUBSET IN TM1

Post by Alan Kirk »

The question is unclear. There's no indication of which part of the interface we're talking about but the reference to "functions to call" suggests that it may be TI.

TI cannot directly delete a private subset. It only deals in public ones. The only way to delete a private subset in TI is by using the AsciiDelete function to perform that task that Steve was alluding to; that is, deleting the .sub file that will be found in the DataDirectory\UserName\DimName}subs folder. The deletion will not be visible until the user logs out (if they're already logged in) and back in. As Steve mentioned, you also run the risk of corrupting any private views that the user may have created so this would not be an approach to take lightly.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
segunfunwaoluwa
Posts: 13
Joined: Wed Dec 07, 2011 4:18 pm
OLAP Product: cognos tm1
Version: 9.5.2
Excel Version: 2007

Re: STEPS ON HOW TO DELETE A PRIVATE SUBSET IN TM1

Post by segunfunwaoluwa »

Thanks for the pointers guys.Checked it out myself by creating a private subset and then right clicked on that particular private subset and chose 'delete' and issue was resolved.Went ahead to convey the same steps mentioned to my user.Still awaiting a response but believe that the steps mentioned will resolve the issue.Thanks everyone.
Segun.
Post Reply