Delete Cube private view with TI

Post Reply
fbroggi
Posts: 5
Joined: Thu Nov 18, 2010 4:16 pm
OLAP Product: TM1
Version: 9.5
Excel Version: 2010

Delete Cube private view with TI

Post by fbroggi »

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
User avatar
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

Post by jim wood »

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.
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
User avatar
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

Post by jim wood »

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.
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
Alan Kirk
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

Post by Alan Kirk »

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

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.
User avatar
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

Post by Elessar »

Alan Kirk wrote:The deletion won't be effective until the user logs out and logs back in, though.
Alan, thanks much for the "logoff/login" method, this helped me much :) I thought it would take effect only after a server restart.

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.
Best regards, Alexander Dvoynev

TM1 and Data Science blog: 10th article - AI has failed TM1 Quiz.
Wim Gielis
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

Post by Wim Gielis »

Elessar wrote:I thought it would take effect only after a server restart.
That's the case for Public views and subsets, Not for private views and subsets, where log out log on is enough.
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
Post Reply