What are TM1 Rules Capabilities?

Post Reply
Ashleigh W
Posts: 46
Joined: Mon Oct 24, 2016 1:21 pm
OLAP Product: TM1
Version: TM1 Perspectives 10
Excel Version: Excel 2016

What are TM1 Rules Capabilities?

Post by Ashleigh W » Mon Jan 22, 2018 11:23 am

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

Wim Gielis
MVP
Posts: 1673
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0
Excel Version: 2016
Location: Brussels, Belgium
Contact:

Re: What are TM1 Rules Capabilities?

Post by Wim Gielis » Mon Jan 22, 2018 11:27 am

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

Excel Most Valuable Professional, 2011-2014
http://www.wimgielis.com ==> 105 TM1 articles and a lot of custom code
Newest blog article: Looping over input files

Ashleigh W
Posts: 46
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?

Post by Ashleigh W » Mon Jan 22, 2018 11:35 am

Thanks for confirming that Wim! Appreciate your help.

ascheevel
Posts: 36
Joined: Fri Feb 15, 2013 5:49 pm
OLAP Product: TM1
Version: 11.2
Excel Version: 2016

Re: What are TM1 Rules Capabilities?

Post by ascheevel » Mon Jan 22, 2018 2:21 pm

TM1 reference guide is a good place to start.

https://www.ibm.com/support/knowledgece ... 80006.html

Ashleigh W
Posts: 46
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?

Post by Ashleigh W » Tue Jan 23, 2018 7:27 am

Thank you for reference link. Very helpful.

BariAbdul
Regular Participant
Posts: 414
Joined: Sat Mar 10, 2012 1:03 pm
OLAP Product: TM1,Cognos
Version: 9.5.2
Excel Version: 2007

Re: What are TM1 Rules Capabilities?

Post by BariAbdul » Wed Jan 24, 2018 1:12 pm

And for most complex part, that is Feeders, please read this document:
https://www.ibm.com/developerworks/data ... ge620.html Thanks
"You Never Fail Until You Stop Trying......"

Ashleigh W
Posts: 46
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?

Post by Ashleigh W » Thu Jan 25, 2018 12:20 pm

Thank you BariAbdul!

Post Reply