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
STEPS ON HOW TO DELETE A PRIVATE SUBSET IN TM1
-
- Posts: 13
- Joined: Wed Dec 07, 2011 4:18 pm
- OLAP Product: cognos tm1
- Version: 9.5.2
- Excel Version: 2007
- 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
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
Cheers
Technical Director
www.infocat.co.uk
www.infocat.co.uk
-
- 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
Thanks Steve for the reply,could you please elaborate the steps the user needs to follow to do the delete?
Thanks.
Segun
Thanks.
Segun
-
- 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
Huh? How about "use the delete key".segunfunwaoluwa wrote:Thanks Steve for the reply,could you please elaborate the steps the user needs to follow to do the delete?
Thanks.
Segun
-
- 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
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.
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
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
-
- 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
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.
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.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-
- 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
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.
Segun.