Hi Experts, what are TM1 Rules Capabilities? Can it create cubes, dimension, other TM1 Objects etc. like the TI Process? I believe the answer is 'No' and that TM1 Rules are used majorly to calculate real-time numbers rather than storing numbers as a static value.
Thank You
What are TM1 Rules Capabilities?
-
- Posts: 88
- Joined: Mon Oct 24, 2016 1:21 pm
- OLAP Product: TM1
- Version: TM1 Perspectives 10
- Excel Version: Excel 2016
-
- MVP
- Posts: 3113
- 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: What are TM1 Rules Capabilities?
Indeed, rules are like Excel formulas, to calculate certain areas in a cube in a dynamic way (i.e. calculation on the fly with every refresh).
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
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
-
- Posts: 88
- Joined: Mon Oct 24, 2016 1:21 pm
- OLAP Product: TM1
- Version: TM1 Perspectives 10
- Excel Version: Excel 2016
Re: What are TM1 Rules Capabilities?
Thanks for confirming that Wim! Appreciate your help.
-
- Community Contributor
- Posts: 287
- Joined: Fri Feb 15, 2013 5:49 pm
- OLAP Product: TM1
- Version: PA 2.0.9.1
- Excel Version: 365
- Location: Minneapolis, USA
Re: What are TM1 Rules Capabilities?
TM1 reference guide is a good place to start.
https://www.ibm.com/support/knowledgece ... 80006.html
https://www.ibm.com/support/knowledgece ... 80006.html
-
- Posts: 88
- Joined: Mon Oct 24, 2016 1:21 pm
- OLAP Product: TM1
- Version: TM1 Perspectives 10
- Excel Version: Excel 2016
Re: What are TM1 Rules Capabilities?
Thank you for reference link. Very helpful.
-
- Regular Participant
- Posts: 424
- Joined: Sat Mar 10, 2012 1:03 pm
- OLAP Product: IBM TM1, Planning Analytics, P
- Version: PAW 2.0.8
- Excel Version: 2019
Re: What are TM1 Rules Capabilities?
And for most complex part, that is Feeders, please read this document:
https://www.ibm.com/developerworks/data ... ge620.html Thanks
https://www.ibm.com/developerworks/data ... ge620.html Thanks
"You Never Fail Until You Stop Trying......"
-
- Posts: 88
- Joined: Mon Oct 24, 2016 1:21 pm
- OLAP Product: TM1
- Version: TM1 Perspectives 10
- Excel Version: Excel 2016
Re: What are TM1 Rules Capabilities?
Thank you BariAbdul!