TM1 Forum

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.

Thanks Wim, just off the top of my head I can see how this can be very useful...

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.

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?

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.