List of all rules

Post Reply
Posts: 22
Joined: Mon Oct 01, 2018 1:50 pm
OLAP Product: TM1
Version: 10.2.20500.75
Excel Version: 2016
Location: Montreal, Canada

List of all rules

Post by CellPutN » Wed Mar 13, 2019 6:53 pm

Hello everyone,

I know we can easily get a list of all dimensions or cubes using the control objects, but is there a way to get a list of all other types of TM1 object ?

There's no such dimension as }Rules or }Views.

Thanks and have a nice day !

User avatar
Community Contributor
Posts: 359
Joined: Thu Apr 18, 2013 6:59 pm
OLAP Product: TM1
Version: 10.2.2 FP7, PA2.0.05
Excel Version: 2013 PAW
Location: Cleveland, Tennessee

Re: List of all rules

Post by PavoGa » Wed Mar 13, 2019 7:22 pm

Write a TI that uses WilcardFileSearch in the Data folder the instance. Create dimensions as needed to capture the returned objects you wish to catalog.

Put this in a chore that runs regularly to keep those dimensions updated. There may be other methods, but that will do it.

In Planning Analytics, there are dimensions for subsets and views, although they are by dimension and cube respectively.
Cleveland, TN

Wim Gielis
Posts: 2109
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0.7
Excel Version: Office 365 - latest
Location: Brussels, Belgium

Re: List of all rules

Post by Wim Gielis » Wed Mar 13, 2019 7:23 pm

In PA there are control objects for subsets and views. I mean subsets for a dimension and views for a cube. For rules you might want to look at the }StatsForRules control cube. Or just open up the .rux text files.
Best regards,

Wim Gielis

Excel Most Valuable Professional, 2011-2014 ==> 109 TM1 articles and a lot of custom code
Newest blog article: Set up a TM1 service with AutoHotKey

Post Reply