Hello,
It seems that in the new version of TM1 we have a couple of new control dimensions:
}Subsets_dim contains the names of the public subsets on dimension ''dim'
}Views_cube contains the names of the public views on cube 'cube'
}Hierarchies_dim contains the names of the hierarchies on dimension ''dim'
This saves us from using Wildcardfilesearch.
The control dimensions are updated when a subset or view is created or deleted.
New control dimensions
-
- 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:
New control dimensions
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
Re: New control dimensions
Thanks Wim, just off the top of my head I can see how this can be very useful... 

============================================
"You rush a miracle man, you get rotten miracles."
- Miracle Max
"You rush a miracle man, you get rotten miracles."
- Miracle Max
-
- 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: New control dimensions
Absolutely, getting rid of subsets and views that still exist after a TI process runs, can be automated in an easier way now 
In any case such objects are public and hence are part of the control dimensions.

In any case such objects are public and hence are part of the control dimensions.
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
-
- Posts: 119
- Joined: Mon Oct 27, 2014 10:50 am
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2013
Re: New control dimensions
Hi,
So how would this help?
Im thinking I could add some attributes to that dimension for all the subsets and views that are "official". I could then create cleanup-scripts that easily just loops across that dimension and deletes all unofficial public views and subsets left behind by keen users and my own TI mishaps.
Is that what you guys are thinking? Or any other good ideas on what to do with these dimensions?
So how would this help?
Im thinking I could add some attributes to that dimension for all the subsets and views that are "official". I could then create cleanup-scripts that easily just loops across that dimension and deletes all unofficial public views and subsets left behind by keen users and my own TI mishaps.
Is that what you guys are thinking? Or any other good ideas on what to do with these dimensions?
-
- 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: New control dimensions
I would look for views / subsets that start with a certain prefix (and maybe contain some other characteristic in the name) and then delete them.
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