New control dimensions

Post Reply
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:

New control dimensions

Post by Wim Gielis »

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.
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
User avatar
Glass
Posts: 5
Joined: Fri Aug 28, 2015 4:13 pm
OLAP Product: TM1
Version: 1022
Excel Version: 2013

Re: New control dimensions

Post by Glass »

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
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: New control dimensions

Post by Wim Gielis »

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.
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
Bakkone
Posts: 119
Joined: Mon Oct 27, 2014 10:50 am
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2013

Re: New control dimensions

Post by Bakkone »

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?
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: New control dimensions

Post by Wim Gielis »

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
Post Reply