List of all rules

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

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 !
Tim
User avatar
PavoGa
MVP
Posts: 616
Joined: Thu Apr 18, 2013 6:59 pm
OLAP Product: TM1
Version: 10.2.2 FP7, PA2.0.9.1
Excel Version: 2013 PAW
Location: Charleston, Tennessee

Re: List of all rules

Post by PavoGa »

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.
Ty
Cleveland, TN
Wim Gielis
MVP
Posts: 3105
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: List of all rules

Post by Wim Gielis »

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

IBM Champion 2024
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