Hi everybody,
i'd like to know if there is a procecss or if i can create one, to perform a cube private view delete.
Thanks in advice
Federico
Delete Cube private view with TI
- jim wood
- Site Admin
- Posts: 3961
- Joined: Wed May 14, 2008 1:51 pm
- OLAP Product: TM1
- Version: PA 2.0.7
- Excel Version: Office 365
- Location: 37 East 18th Street New York
- Contact:
Re: Delete Cube private view with TI
For TI to see a view it has to be public. Private views are user specific and stored in the users folder in the data dictionary,
Jim.
Jim.
Struggling through the quagmire of life to reach the other side of who knows where.
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
- jim wood
- Site Admin
- Posts: 3961
- Joined: Wed May 14, 2008 1:51 pm
- OLAP Product: TM1
- Version: PA 2.0.7
- Excel Version: Office 365
- Location: 37 East 18th Street New York
- Contact:
Re: Delete Cube private view with TI
If you know what the view is called or if you want to say clear a folder you could create a batch file and execute that from TI,
Jim.
Jim.
Struggling through the quagmire of life to reach the other side of who knows where.
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
-
- Site Admin
- Posts: 6667
- 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: Delete Cube private view with TI
In addition to Jim's suggestion, if it's a single view and you know both its name and the name of the user, you could also use the ASCIIDelete function to delete the .vue file. The deletion won't be effective until the user logs out and logs back in, though.fbroggi wrote:Hi everybody,
i'd like to know if there is a procecss or if i can create one, to perform a cube private view delete.
The other option is writing an application using the API, but the process would have to be run by the user themselves, with their login; the API can only see the logged in user's private objects, not the private objects of all users. (Not even when you're logged in as an Admin.)
"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.
- Elessar
- Community Contributor
- Posts: 413
- Joined: Mon Nov 21, 2011 12:33 pm
- OLAP Product: PA 2
- Version: 2.0.9
- Excel Version: 2016
- Contact:
Re: Delete Cube private view with TI
Alan, thanks much for the "logoff/login" method, this helped me muchAlan Kirk wrote:The deletion won't be effective until the user logs out and logs back in, though.

But sometimes it's not enough to just logout from TM1: some sessions can remain in TM1top. In this case you should kick the user in Server Manager.
-
- MVP
- Posts: 3240
- 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: Delete Cube private view with TI
That's the case for Public views and subsets, Not for private views and subsets, where log out log on is enough.Elessar wrote:I thought it would take effect only after a server restart.
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